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

Electrik.AI currently supports Google BigQuery as destination when exporting data from Google Ads. Drop us a message, if you don’t see your favorite data warehouse.

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.

Don’t have a Google BigQuery account? Refer this link.

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

  1. Access to Google BigQuery
  2. Google BigQuery Account User Id and Password.

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-ElectrikAI

Step 5: Select the Connections Icon in the left most panel and Click “Add” button at the top.

Add Connections-ElectrikAI
Step 5b Add Connections-ElectrikAI

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

Step 6 Select Target tab and now click on “Google BigQuery” connection-ElectrikAI

Step 7: Enter your Google Cloud Platform UserId and Password.

GA Username and password-Electrik.ai

Step 8: Allow Electrik.AI to access your Google BigQuery account.

Access your Google BigQuery Account-Electrik.ai

Step 9: Choose your Google BigQuery Project

Choose your Google BigQuery Project-ElectrikAI

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

BigQuery console-Electrik.ai

Step 10: Click “Save”, to continue.

Click “Save”, to continue-ElectrikAI

Step 11: Congratulations, you have successfully created a Google BigQuery connection in Electrik.AI

Congratulations, you have successfully created a Google BigQuery connection-EelctrikAI