Source
Zero-code, low-cost data ingestion: New BigQuery DTS capabilities
Google has introduced new connectors and capabilities to the BigQuery Data Transfer Service (DTS) to automate zero-code data ingestion from various sources into BigQuery.
Why it matters
This reduces the engineering time and cost enterprises spend building manual data pipelines, allowing teams to focus on data analysis rather than maintenance.
The details
- Added support for Apache Iceberg, MS SQL Server, PostgreSQL, MySQL, and Snowflake.
- New connectors available for Shopify, Klaviyo, HubSpot, and Mailchimp platforms.
- First-party Google sources and some cloud storage providers have zero ingestion costs.
Show entities and relationshipsHide entities and relationships
In this article
Products
Companies
Technologies
Key connections
Amazon provides the Amazon S3 cloud object storage service.
Microsoft owns Microsoft SQL Server
Microsoft develops the SQL Server relational database management system.
Google owns BigQuery Data Transfer Service
Google provides BigQuery Data Transfer Service as part of Google Cloud.
Google owns Google Analytics 4
Google owns Google Analytics 4.
Google owns Campaign Manager
Google owns Campaign Manager.
Google owns CloudSQL.
Show 27 more connectionsShow fewer connections
Microsoft owns Azure Blob Storage
Microsoft owns Azure Blob Storage.
BigQuery Data Transfer Service uses Model Context Protocol
BigQuery DTS supports a fully managed remote Model Context Protocol (MCP) Server for programmatic data discovery and transfer execution.
BigQuery Data Transfer Service is related to BigQuery
BigQuery DTS automates data ingestion into BigQuery.
BigQuery Data Transfer Service uses Google Cloud Storage
BigQuery DTS ingests data directly from Google Cloud Storage.
BigQuery Data Transfer Service uses Amazon S3
BigQuery DTS ingests data directly from Amazon S3.
BigQuery Data Transfer Service uses Azure Blob Storage
BigQuery DTS ingests data directly from Azure Blob Storage.
Amazon owns Amazon Redshift
Amazon owns and provides the Amazon Redshift data warehouse service
BigQuery Data Transfer Service uses Apache Iceberg
BigQuery DTS supports direct ingestion into Apache Iceberg managed tables.
BigQuery Data Transfer Service uses Microsoft SQL Server
BigQuery DTS supports data transfers from Microsoft SQL Server.
BigQuery Data Transfer Service uses PostgreSQL
BigQuery DTS automates data delivery and replication from PostgreSQL databases.
BigQuery Data Transfer Service uses MySQL
BigQuery DTS automates data delivery and replication from MySQL databases.
BigQuery Data Transfer Service uses Shopify
BigQuery DTS automates extraction of order histories and customer profiles from Shopify.
BigQuery Data Transfer Service uses Klaviyo
BigQuery DTS extracts email and SMS engagement logs from Klaviyo.
BigQuery Data Transfer Service uses HubSpot
BigQuery DTS syncs pipeline and contact tracking metrics from HubSpot.
BigQuery Data Transfer Service uses Mailchimp
BigQuery DTS automatically moves campaign performances from Mailchimp into BigQuery.
BigQuery Data Transfer Service uses Snowflake
BigQuery DTS supports data migration from Snowflake with incremental transfers.
BigQuery Data Transfer Service uses ServiceNow
BigQuery DTS includes enhanced native incremental update support for ServiceNow.
BigQuery Data Transfer Service uses Salesforce
BigQuery DTS includes enhanced native incremental update support for Salesforce.
BigQuery Data Transfer Service uses Oracle
BigQuery DTS includes enhanced native incremental update support for Oracle.
BigQuery Data Transfer Service uses Teradata
BigQuery DTS provides zero-cost data ingestion for Teradata.
BigQuery Data Transfer Service uses Google Ads
BigQuery DTS provides zero-cost data ingestion for Google Ads.
BigQuery Data Transfer Service uses Google Analytics 4
BigQuery DTS provides zero-cost data ingestion for Google Analytics 4.
BigQuery Data Transfer Service uses Campaign Manager
BigQuery DTS provides zero-cost data ingestion for Campaign Manager.
BigQuery Data Transfer Service uses YouTube
BigQuery DTS provides zero-cost data ingestion for YouTube.
BigQuery Data Transfer Service uses CloudSQL
BigQuery DTS supports data replication from CloudSQL environments.
BigQuery Data Transfer Service uses Amazon Redshift
BigQuery DTS provides zero-cost data ingestion for Amazon Redshift.
BigQuery Data Transfer Service is related to Data Ingestion
BigQuery Data Transfer Service is a fully managed, zero-code data ingestion solution.
Related events
Google Cloud Expands BigQuery Data Transfer Service Capabilities
Get the weekly recap
The stories like this one, picked and explained — once a week, straight to your inbox.