Exporting to BigQuery

First, choose the object you want to export. This can be a source or a query.

Next, select the columns to be exported. Filters can also be applied. 

If not columns are added all columns will be exported.

Next, select your connection to BigQuery.

Then fill in your data set name and table name. It can be whatever you want it to be. You can't use spaces or special characters in the name. 

Note: In order to be able to export data to bigquery, the service account associated to the warehouse needs to be granted BigQuery Admin access 

Lastly, you can choose to "auto run" this export. This means it will run either daily, weekly or monthly on its own. 

After you've configured your export, you'll be asked if you want to run it. You can click the "Run Export" button, or wait for the auto-run to execute.

After you've run your export, you'll see some information related to your export and it's data.

a) You'll see info about the last load, the size of the data, and your auto-run settings.

b) You can always change your configuration by clicking the "settings" button.

c) To open this export in BigQuery, click the "View Export" button

d) Click the "Run Export" button to manually execute the export process and push data to BigQuery.

e) This is the "configuration preview" bar that shows you at-a-glance how you've configured this export

f) This is a list of all your exports, automatic and manual. You'll see the status, the name of the export and if it was automated, the type (source or query), when it was uploaded, the number of rows, and the location (with the dataset and name you chose).

Still need help? Contact Us Contact Us