Loved by 24,000+ organizations across the globe
Why export queries from BigQuery to BigQuery?
Extract the required data
Extract the fields you need from a massive BigQuery table that contains hundreds of nested columns. Create a separate table, which will only contain the relevant columns, and connect it to your source table. Automate the data stream of the specific query results to the destination table every hour, or at a more or less frequent schedule.
Prepare a data set for a dashboard
Separate the data that you’ll use for building an analytical dashboard. Create a new table and integrate it with a bigger data repository stored in BigQuery. Stream the relevant data to this separate table, which will be used as a data source for your dashboard created in Google Data Studio, Tableau, or another data visualization tool.
Share a specific dataset with third-parties
Use the BigQuery to BigQuery integration to share specific pieces of data or data ranges with third-party users. Extract the information to be shared into a separate table and automate data transfer to it on a scheduled basis. Share the destination table with stakeholders by providing them with view access.
What BigQuery to BigQuery export you can perform
Stream data from a bigger table into a smaller one within the same dataset to separate the relevant information for reporting, analytics or sharing. Connect both tables using the BigQuery to BigQuery integration and automate dataflow on a schedule.
Transfer data from one BigQuery dataset to another to maintain the consistency of the information stored in specific repositories. Single out the columns that have to be added to a table stored in another dataset and schedule their export at a custom frequency.
Connect BigQuery tables from different projects to automate data flow between them. Extract the data that you want to share with your external BigQuery project or even third-party projects maintaining the security of your data. Configure the load of the custom query to the destination BigQuery project on the desired schedule.
How to automate BigQuery to BigQuery transfer
Step 1. Select BigQuery as a source application and connect the source BigQuery project2 minutes
Step 2. Enter or copy and paste an SQL query for export30 seconds
Step 3. Select BigQuery as a destination application and connect the destination BigQuery project2 minutes
Step 4. Specify a dataset and table to load the transferred query results15 seconds
Step 5. Configure the frequency to automate BigQuery to BigQuery transfer15 seconds
See what our customers say
"Coupler.io automatically imports the full dataset you need and it refreshes it completely on any schedule you want. No triggers necessary. And the best of all, the team is very supportive.
"The integrations are easy to set up and automate, my colleagues think I'm a genius, but it's really Coupler.io that is doing the heavy lifting.
Set up multiple integrations to count on every day
Looking to import data from Shopify, Clockify, QuickBooks, or any other app? Not a problem. Use Coupler.io to link a data source to BigQuery to automate workflows and leverage the power of spreadsheets across all your projects!