How to link BigQuery in Tableau

After accessing the connector and creating a Cognetik account, you need to link your BigQuery credentials in order to bring your BigQuery data into Tableau.

Here’s how you do that:

1. Create a service account for your Google BigQuery project.

After selecting your Google BigQuery project in your Google Cloud Console, go to ‘IAM & admin’ in the navigation menu, then select ‘Service accounts.’

2018-12-13_0825

Click the ‘+ CREATE SERVICE ACCOUNT’ button.

2018-12-13_0825_001

Name your service account.

2018-12-13_0826

 

Choose a Project role by clicking the ‘Select a role’ button.

2018-12-13_0826_001

 

Choose ‘BigQuery,’ then choose the ‘BigQuery Admin’ role.

2018-12-13_0826_002

 

Make sure you check the ‘Furnish a new private key’ box, and select the JSON format. 

2018-12-13_0826_003

 

Hit ‘SAVE’ in order to download your JSON file. This will be saved in the folder selected in your browser settings.

2018-12-13_0827

 

Now that you have the JSON file, access the connector and create a Cognetik account, to link your BigQuery credentials

2. Go to 'Link a new credential' and then select BigQuery from the data source list.

Advanced Mode

2019-08-06_1634


3. Paste your Big Query JSON file content.

2019-08-06_1638

 

4. The query page is displayed and you can now query the data you need.

2019-08-06_1542

 

How to link Big Query credentials (video)

 

final_5dde830ae3ae79001410566e_607131