BigQuery

Overview

Send your ecommerce data to Google BigQuery for advanced analytics, custom SQL queries, and integration with Looker Studio dashboards.

Setup

1. 1

   Create a GCP project and BigQuery dataset (see the setup guide on the Outputs page).

2. 2

   Generate a service account with BigQuery Data Editor and Job User roles.

3. 3

   Go to Dashboard > Outputs, click Connect on BigQuery, and paste your credentials.

4. 4

   Data will sync to your BigQuery dataset on the same schedule as your sources.

Tips

• Use Looker Studio to build dashboards on top of your BigQuery data for free.
• BigQuery charges for storage and queries — the free tier covers most small datasets.

Fields Required

Setup Guide

1. 1

   Go to Google Cloud Console and note your Project ID (or create a new project).

   https://console.cloud.google.com/
2. 2

   Go to BigQuery and click the three dots next to your project, then "Create dataset".

   https://console.cloud.google.com/bigquery
3. 3

   Name the dataset (this is your Dataset ID), choose a location (e.g., US), and click Create.

4. 4

   Go to IAM > Service Accounts.

   https://console.cloud.google.com/iam-admin/serviceaccounts
5. 5

   Click "+ Create Service Account", name it smartecom-etl, and click Create and Continue.

6. 6

   Assign the roles BigQuery Data Editor and BigQuery Job User, then click Done.

7. 7

   Click the service account, go to Keys tab, click "Add Key" > "Create new key" > JSON.

8. 8

   Copy the entire downloaded JSON file contents into the Service Account JSON field.