1. Home
  2. Knowledge Base
  3. Exporting and Publishing Data
  4. [Online] – How To Export To BigQuery

How To Export To BigQuery

You must first provide access to BigQuery using the Service Account for your subscription.  See the article “Getting started” or How to Import Data from BigQuery.

1. Drag and drop the BigQuery block from the Export Data section. You will see that it only has one node to accept inputs. Link the previous block, the one where you’re sending the information from, to the “BigQuery” block.

 

2. Click on the output node of the previous block to have a look at the incoming data. You can see the same data by clicking on the input node of the “BigQuery” block once the link is made.

 

Image

3. Select the BigQuery block by clicking on the centre of it. Click 'Select Table' to select an existing table, or to create a new table within an existing data set. 

To create a Date Partitioned table in BigQuery, select the option then choose the granularity.  If there is more than one date column in your table, you will also be asked to select a Date column.

Note that the maximum number of partitions is 4,000 - keep that in mind when choosing the granularity as this cannot be changed later.  

 

Image

After clicking 'Select Table', use the tree view on the left to navigate through the datasets from your BigQuery account and select the one where you want to add the new data.  Note that only the projects that have authorized the Analytics Canvas Service Account for your subscription will be shown here.

After you make the selection, either create a new table by entering a name and clicking 'Create', or overwrite an existing table by clicking on “Select” next to its name.

 

Image

4. Click on 'WriteOutput' to process just the selected output block, or run the Canvas from the top of the screen to add the data to the selected table and process ALL other outputs on the Canvas.

 

Image

Was this article helpful?

Related Tutorials/Video