You’ll need to be an owner in your Google Cloud project to create a service account. If you’re not, please contact the administrator of your BigQuery database.
Visit the Credentials page in Google Cloud Console
Select your project
Create credentials, and then
Service account key
New service account, name it (ie “PopSQL BigQuery” or your full name), give it the BigQuery Admin role, select JSON, and hit the Create button.
Download the .json file, open it in a text editor, and copy the entire file contents to your clipboard.
Open the PopSQL connections modal, click
New Connection, name it, choose BigQuery as the type, paste your clipboard (the .json file contents) into the Service Account field, and hit Connect.
Once you’re connected, try this sample query:
SELECT title FROM [bigquery-public-data:samples.wikipedia] LIMIT 5;
Happy querying! 🍭