Google expands BigQuery transfer service with new connectors
Sun, 9th Aug 2026 (Today)
Google has added new connectors and features to BigQuery Data Transfer Service, expanding it across databases, marketing platforms and data migration tools.
The update includes preview support for Microsoft SQL Server, Shopify, Klaviyo, HubSpot and Mailchimp, alongside general availability for PostgreSQL, MySQL and a Snowflake migration connector. Google also introduced preview support for direct ingestion into Apache Iceberg managed tables and a managed remote Model Context Protocol server for developers connecting AI applications and agents to the service.
BigQuery Data Transfer Service is Google's managed tool for moving data into BigQuery. The latest changes are intended to reduce the manual work required to build and maintain extract, transform and load pipelines.
Database links
Among the new database options, Microsoft SQL Server enters preview with support for full and incremental transfers. PostgreSQL and MySQL are now generally available, with support for replication from on-premise environments, Cloud SQL and other cloud platforms.
These releases extend BigQuery's reach into operational data stored in transactional systems. They also put Google in more direct competition for workloads that businesses often move into central analytics platforms for reporting and modelling.
Google has also expanded support for enterprise software connectors. ServiceNow, Salesforce and Oracle now have native incremental update support, intended to improve refresh times for larger CRM, IT service management and finance data pipelines.
Marketing data
On the marketing and eCommerce side, the service now includes preview connectors for Shopify, Klaviyo, HubSpot and Mailchimp. The integrations are designed to pull commerce, campaign and customer engagement data into BigQuery for analysis.
Shopify covers order histories, inventory logs and customer profiles, while Klaviyo focuses on email and SMS engagement records such as clicks, sends and opens. HubSpot brings in pipeline and contact tracking data, and Mailchimp adds campaign results and audience list information.
The launch reflects continued demand from companies that want to combine sales, marketing and operational data in one warehouse rather than rely on separate specialist tools and custom scripts.
Lakehouse and AI
Another change adds direct ingestion into Apache Iceberg managed tables in preview. The feature supports data from Google Cloud Storage, Amazon S3 and Azure Blob Storage.
This gives customers a way to store and manage data in formats associated with open lakehouse architectures while still using BigQuery as the analytical destination. Support for storage across Google Cloud, Amazon Web Services and Microsoft Azure also highlights Google's continued focus on multi-cloud data workflows.
Google also unveiled a fully managed remote Model Context Protocol server in preview. Developers can use it to connect AI applications and agents to BigQuery Data Transfer Service so those systems can discover data sources and configure or run transfers on a user's behalf.
Migration push
For companies moving data estates from rival platforms, Google's Snowflake migration connector is now generally available. The connector includes incremental transfer, automatic schema detection, private connectivity and support for migrating data across the three main cloud providers.
The release underlines Google's effort to make BigQuery a more straightforward landing point for customers shifting data warehouse workloads. Snowflake remains a major competitor in cloud analytics, and migration tooling has become an increasingly important part of vendor competition in the market.
Google also outlined pricing and operational details for the service. Ingestion carries no charge for first-party Google sources except Google Play, and is also free for Amazon S3, Azure Blob Storage, Amazon Redshift and Teradata. For third-party software sources, pricing is based on compute consumption rather than row volume.
On security, transfers integrate with Cloud IAM and inherit destination dataset controls, including column-level security, row-level security and customer-managed encryption keys. The service runs within Google Cloud and is backed by a monthly uptime percentage of at least 99.99% under its service-level agreement.
The update broadens BigQuery Data Transfer Service across data movement tasks, from database replication and SaaS ingestion to lakehouse storage and warehouse migration, as Google pushes to make BigQuery a more central tool for enterprise data operations.