Pipelines - Pipelines now supports SQL transformations and Apache Iceberg
9mo ago
Source
CloudflarePipelines - Pipelines now supports SQL transformations and Apache Icebergcloudflare.comToday, we're launching the new Cloudflare Pipelines : a streaming data platform that ingests events, transforms them with SQL , and writes to R2 as Apache Iceberg tables or Parquet files. Pipelines can receive events via HTTP endpoints or Worker bindings , transform them with SQL, and deliver to R2 with exactly-once guarantees. This makes it easy to build analytics-ready warehouses for server logs, mobile application events, IoT telemetry, or clickstream data without managing streaming infrastructure. For example, here's a pipeline that ingests clickstream events and filters out bot traffic while extracting domain information: INSERT into events_table SELECT user_id, lower ( event ) AS event_type, to_timestamp_micros(ts_us) AS event_time, regexp_match( url , '^https?://([^/]+)' )[1] AS domain, url , referrer, user_agent FROM events_json WHERE event = 'page_view' AND NOT regexp_like(user_agent, '(?i)bot|spider' ); Get started by creating a pipeline in the dashboard or running a single command in Wrangler : npx wrangler pipelines setup Check out our getting started guide to learn how to create a pipeline that delivers events to an Iceberg table you can query with R2 SQL. Read more about today's announcement in our blog post .
You might also wanna read
Cloudflare Launches Fully-Managed Data Platform for Analytical Data on Global Infrastructure
Cloudflare announced the Cloudflare Data Platform, a fully-managed suite of products for ingesting, storing, and querying analytical data. B
WarpStream Tableflow: Converting Kafka Data to Iceberg Tables with Low Latency
WarpStream Tableflow is a new product that addresses the challenges of converting Kafka topic data into Apache Iceberg tables. The article a
warpstream.com·9mo agoGitHub - viggy28/streambed: Stream Postgres to Apache Iceberg on S3 via logical replication, queryable over the Postgres wire protocol.

The Role of Apache Iceberg in Modern Data Infrastructure and the Equality Delete Problem
The article discusses the growing significance of Apache Iceberg in the data infrastructure landscape, highlighting major acquisitions by Da
Key Enhancements in Apache Iceberg V3 for Data Lake Efficiency
The article discusses the new features in Apache Iceberg V3, focusing on improvements like more efficient row-level transactions with deleti
Introducing EventQL: A Query Language for Event Sourcing Systems
The article introduces EventQL, a new event query language developed for EventSourcingDB that addresses the limitations of traditional proje

Comments
Sign in to join the conversation.
No comments yet. Be the first.