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": "mybigproj@mybigorg.iam.gserviceaccount.com",
  "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 🎉

PreviousAirflowNextLooker

Last updated