BigQuery

Seemore natively supports Google BigQuery, which allows you to seamlessly integrate your Big Query with your Seemore workspace.

📜 Prerequisites for a Big Query integration

• Service Accounts: Service accounts are special Google accounts that can be used by applications to access Google APIs programmatically via OAuth 2.0. A service account uses an OAuth 2.0 flow that does not require additional authorization. Instead, it uses a key file that only your application can access.

• Project ID: The project ID is a unique identifier for a Google Cloud project.

🔑 Big Query user permissions

👀 Note: Make sure you have permissions to grant access to resources. For more information, visit "Granting, changing, and revoking access to resources".

1. Create a service account. For detailed steps on creating a service account, visit "Creating and managing service account keys".

2. Grant those roles to the user:

   Metadata BigQuery Viewer
   Logs Viewer
   Data Catalog Viewer 
   Storage Object Viewer
   BigQuery User
   BigQuery Resource Viewer 
   BigQuery Job User
   Logs View Accessor

If you have access to Seemore, please continue. Otherwise, keep your credentials for an onboarding session with your Seemore account manager.

🚀 A step-by-step guide to integrating Big Query with Seemore

STEP 1: Select the source

1. Log into your Settings >> Integrations.

2. On the home screen, click on the + button on the top right corner. You will see a dialogue box with the list of sources available on your workspace.

3. Select "Big Query" from the list of options, and click on "Next".

STEP 2: Provide Project ID + Credentials

1. You will need to provide the project ID.

2. You will be required to fill in your Big Query credentials. Below is an example of the credentials required:

Service Account:

{
  "type": "service_account",
  "project_id": "mybigproject",
  "private_key_id": "0adfdf1",
  "private_key": "-----BEGIN PRIVATE KEY-----\nMIIEghoQ=\n-----END PRIVATE KEY-----\n",
  "client_email": "[e-mail]",
  "client_id": "12345",
  "auth_uri": "https://accounts.google.com/o/oauth2/auth",
  "token_uri": "https://oauth2.googleapis.com/token",
  "auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
  "client_x509_cert_url": "https://www.googleapis.com/robot/v1/metadata/x509/bq-test1%40seemorenhq.iam.gserviceaccount.com"
}

1. Once you have filled in the details, click on "Next".

STEP 3: Data configuration

You can filter data asset you don't want to fetch base on regex that you can provide

Congratulations! You have now integrated Seemore with your Big Query 🎉