Project Configuration
Information needed: GCP JSON key for authentication. (Guide on how to get the JSON key https://developers.google.com/workspace/guides/create-credentials)
Project Creation
- Go to “Settings”->“System Settings”. Click on “Add New Project”.
- Select “Google BigQuery” from the list and click on “Create Project” on the next page.
- This is where you will start configuring the project.
- Project Id, Private key Id, Private key, Client email, Client id – Use your GCP authentication key information here. Please Note – Private Key starts with 5 ‘-’ and ends with ‘\n’.
- Another way is for users to directly upload JSON key file.
(See Figure 1)
- Choose the data type (metric/log) you want to load and click on verify to continue.
- If the verification is successful, input the query needed to execute. The query MUST have the time_stamp and instance_name field. (See Figure 2)
- Sample query: select first_served_timestamp AS time_stamp, ad_type AS instance_name, spend_range_max_usd AS moneyMax from `bigquery-public-data.google_political_ads.creative_stats`
- To learn more about Google bigquery (https://cloud.google.com/bigquery/)