Ingest high volumes of real-time data, transform it with SQL, and write to Apache Iceberg tables or files on R2.
Durable, buffered data streams that receive events via HTTP or Worker bindings
Filter, normalize, and transform data in-flight with standard SQL
Write to R2 Data Catalog (Iceberg) or raw files (JSON/Parquet)
1-- Transform and filter clickstream events2INSERT INTO events_table3SELECT4 user_id,5 lower(event) AS event_type,6 to_timestamp_micros(ts_us) AS event_time,7 regexp_match(url, '^https?://([^/]+)')[1] AS domain,8 url,9 referrer,10 user_agent11FROM events_json12WHERE event = 'page_view'13 AND NOT regexp_like(user_agent, '(?i)bot|spider');
$ npx wrangler pipelines setup