To connect to Google BigQuery with a service account, you need a JSON service account key.

To get the key for your project using the Google Cloud Console:

1. Open Google Cloud Console.
2. Select the required project, then navigate to IAM & Admin > Service Accounts.

   

3. Continue based on whether you want to create a new service account or use an existing one:
   • For a new account:
     1. Click Create service account.

        

     2. Name the account, enter the description, then click Create and continue.

        

     3. Grant the necessary role, then click Continue.

        

     4. Optional: Grant access to users or groups.
     5. Click Done.

        

   • For an existing account: Click the email address of the account.

     

4. Click Keys.

   

5. Select Add key > Create new key.

   

6. Select JSON as a key type, then click Create.

   

7. Save the file on your computer.

The JSON file is downloaded to your computer.

Specify the path to this file or its content in the ServiceAccount Json connection string parameter (Private Key JSON in the connection dialog) and set Authentication Type to ServiceAccount.