Dataflows - New Destination: Google BigQuery
Data Factory · Public preview · Planned
Description
We are introducing Google BigQuery as a new data destination for Dataflow Gen2 in Preview, enabling customers to publish transformed data from Microsoft Fabric directly into BigQuery tables using Dataflow Gen2's low-code Power Query experience.This preview expands Dataflow Gen2's destination ecosystem to better support multi-cloud analytics architectures, giving customers with existing investments in Google Cloud a simple way to deliver Fabric-based transformations into their BigQuery data warehouse -- without building or maintaining custom pipelines and orchestration.Key benefits and scenarios:* Publish curated outputs from Dataflow Gen2 directly into Google BigQuery datasets and tables* Support multi-cloud analytics and data sharing scenarios while keeping transformation logic centralized in Fabric* Prepare, standardize, and reshape data in Fabric before making it available to BigQuery-based reporting, machine learning, and downstream processing* Complete the round trip for BigQuery customers, complementing existing read connectivity and mirroring with a first-class write path* Reduce operational overhead by replacing hand-built export and load jobs with a governed, refreshable dataflowDuring Preview, the Google BigQuery data destination is intended for evaluation and feedback, allowing customers to validate connectivity patterns, load performance, and integration workflows ahead of broader production use.This release is part of our broader effort to make Dataflow Gen2 a flexible, low-code transformation layer across clouds, with ongoing investments planned to further mature and expand multi-cloud destination support in Microsoft Fabric.
Change History
-
2026-08-26
Roadmap Item Added
Workload: Data Factory