Google BigQuery

BigQuery is Google’s fully managed, petabyte scale, low cost analytics data warehouse. BigQuery is NoOps—there is no infrastructure to manage and you don’t need a database administrator—so you can focus on analyzing data to find meaningful insights, use familiar SQL, and take advantage of Google’s pay-as-you-go model.

Electrik.AI exports data from your marketing data source to a database destination of your choice. It is important to note that Electrik.AI itself is not a destination. A destination is required to export data from various marketing data sources using Electrik.AI

Do not have a Google BigQuery account? Refer this link.

Create a Google BigQuery connection in Electrik.AI

Step 1: Ensure you have following prerequisites to create a Google BigQuery Connection in Electrik.AI

  1. Access to Google BigQuery
  2. Google BigQuery Service Account Key File (extension JSON).

Step 2: Signup for your Electrik.AI account

Step 3: Sign-in into your Electrik.AI account

Step 4: Select IO in Electrik.AI dashboard

Select IO in Electrik.AI dashboard

Step 5: Select the Connections Icon in the left most panel.

Select the Connections Icon

Step 6: Select Target tab and now click on “Google BigQuery(Service Account)” connection.

Select Target tab and now click on “Google BigQuery(SA)” connection

Step 7: Upload the Service Account Key downloaded from Google Cloud. How to create Service Account for BigQuery.

Upload the Service Account Key downloaded

Step 8: Choose your Project from the dropdown.

Choose your Project from the dropdown

Step 9: Click “Save”, to continue.

Click “Save”, to continue

Note: Google BigQuery Project can be found in your Google BigQuery console. Refer screenshot below for details.

Note Google BigQuery Project can be found

Congratulations, you have successfully created a Google BigQuery (Service Account) connection in Electrik.AI.

Congratulations, you have successfully created a Google BigQuery (Service Account) connection

Creating Service Account for BigQuery in Google Cloud Console

Step 1: Login to your Google Cloud Console.
Step 2: On Home page, click on the Burger Menu.
Step 3: Go to IAM & Admin.
Step 4: Choose Service Accounts option.

Creating BQSA account

Step 5: Click on the Create Service Account button on the top.

Creating BQSA account-Click on the Create Service Account button on the top

Step 6: Provide required service accounts details and click on “CREATE”.

Creating BQSA account-Provide required service accounts details and click on “CREATE”

Step 7: Now you should see the option to assign Service Account permissions. Under that you should find a dropdown. Choose BigQuery-> BigQuery Admin.

Choose BigQuery- BigQuery Admin

Step 8: Click on Continue. On the next screen, you should now see an option to Create Key. Click on Create Key.

Creating BQSA account-Click on Continue. On the next screen, you should now see an option to Create Key

Step 9: Click on Continue. On the next screen, you should now see an option to Create Key. Click on Create Key.

Creating BQSA account-Choose the key format JSON and click Create

Step 10: This will start with the download of a .json file. Save the file to upload while creating BigQuery Service account in Electrik AI.