This topic presents a general procedure on how you can connect to BigQuery from PyCharm. It is assumed that you already have the necessary prerequisites.
In the Database tool window ( ), click the Data Source Properties icon .
On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select BigQuery.
At the bottom of the data source settings area, click the Download missing driver files link. As you click this link, PyCharm downloads drivers that are required to interact with a database. The IDE does not include bundled drivers in order to have a smaller size of the installation package and to keep driver versions up-to-date for each IDE version.
You can specify your drivers for the data source if you do not want to download the provided drivers. For more information about creating a database connection with your driver, see Add a user driver to an existing connection.
Specify database connection details. Alternatively, paste the JDBC URL in the URL field.
To delete a password, right-click the Password field and select Set Empty.
Specify information about the project to which you want to connect.
Project ID:: a unique identifier for your project.
OAuthType:: an option that specifies how the driver obtains or provides the credentials for OAuth 2.0 authentication. You can select between the following options:
OAuthServiceAcctEmail(a Google service account email address),
OAuthPvtKeyPath(the full path to a private key file for the service account), and
OAuthType=0. Consider the following example JDBC URL.
OAuthAccessToken(an access token),
OAuthClientId(a refresh token),
OAuthClientSecret(a client secret), and
OAuthType=2. If you are using a refresh token, set the
OAuthClientIdproperty to to your client ID and set the
OAuthClientSecretproperty to your client secret. For more information about tokens, see Using OAuth 2.0 to Access Google APIs at developers.google.com.
To ensure that the connection to the data source is successful, click the Test Connection link.