You must have a Google account and must create service account credentials in the form of a key file in JSON format to use the Google BigQuery loader job entry. You must also set permissions for your BigQuery and Google Cloud accounts. To create service account credentials, see https://cloud.google.com/storage/docs/authentication.
Perform the following steps to set up your system to use Google BigQuery:
- Download the service account credentials file that you have created using the Google API Console to your local machine.
- Create a new system environmental variable on your operating system named GOOGLE_APPLICATION_CREDENTIALS.
- Set the path to the downloaded JSON service account credentials file as the value of the GOOGLE_APPLICATION_CREDENTIALS variable.
- Reboot your local machine.
Note: The environment variable and credentials must be set up on each machine that runs the BigQuery loader job. The Google BigQuery loader dialog box will not open for editing in the job canvas until this procedure is completed.