Connect to BigQuery
To create a project, select in the Navigation menu of the Google Cloud Platform. Alternatively, click the Create a project list on the Dashboard page and click New project.
To select an existing project, click a project that you want to use in the Select a project list on the Dashboard page.
note
BigQuery is automatically enabled in new projects. To activate BigQuery in a preexisting project, click Enable the BigQuery API.
To connect to the database, create a data source that will store your connection details. You can do this using one of the following ways:
From the main menu, navigate to and select BigQuery.
In the Database tool window ( ) , click the New icon (
) in the toolbar. Navigate to Data Source and select BigQuery.
Check if there is a Download missing driver files link at the bottom of the connection settings area. Click this link to download drivers that are required to interact with a database. For a direct download link, refer to the JetBrains JDBC drivers page.
You can find the downloaded JDBC drivers in the GoLand configuration directory.
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 also use your drivers for the database instead of the provided ones. For more information about connecting to a database with your driver, see Add a user driver to an existing connection.
If there is no Download missing driver files link, then you already have the required drivers.
From the Authentication list, select Google User Account.
In the Project ID field, type the project identifier.
Usually, it is a part of the service account email identifier that goes after the at sign (
@). In our case, it isbigqueryproject-322409.From the Authorization Code Required dialog, cut the URL, paste it into the address bar of your web browser and press Enter to follow the URL.
Authorize access to your BigQuery application in your Google account.
Copy the authorization code received from Google, paste it in the Authorization Code Required dialog, and click OK.
Ensure that the connection to the database can be established using the provided details. To do that, click the Test Connection link at the bottom of the connection details area.
In case of any connection issues, refer to the Cannot connect to a database page.
(Optional) By default, only the default project and dataset are introspected and available to work with. If you also want to work with other projects and datasets, in the Schemas tab, select them for the introspection.
Click OK to create the data source.
Find your new data source in the Database tool window (Alt01) .
To learn more about the Database tool window, see the corresponding reference topic.
tip
To see more projects and datasets under your new data source node, click the N of M button and select the ones you need. GoLand will introspect and show them.
To learn how to work with database objects in GoLand, see Database objects.
To write and run queries, open the default query console by clicking the data source and pressing F4.
To view and edit data of a database object, open Data Editor and Viewer by double-clicking the object.
In the Navigation menu of the Google Cloud Platform, select .
On the Service accounts page, click Create service account.
On the Service account details step in the wizard, type a project name and description.
On the Grant this service account access to the project step in the wizard, select roles for this service account.
For example, for read-only access, select BigQuery Data Viewer, BigQuery Job User, and BigQuery User from the BigQuery menu. Alternatively, select for access to all resources within the project. For more information about roles and permissions, see Predefined roles and permissions at cloud.google.com.
On the Service accounts page (), click the configuration icon in the Actions column and select Manage keys.
Click the Add key list and select Create new key.
In the Create private key dialog, select JSON and click Create.
The private key download is started automatically.
To connect to the database, create a data source that will store your connection details. You can do this using one of the following ways:
From the main menu, navigate to and select BigQuery.
In the Database tool window ( ) , click the New icon (
) in the toolbar. Navigate to Data Source and select BigQuery.
Check if there is a Download missing driver files link at the bottom of the connection settings area. Click this link to download drivers that are required to interact with a database. For a direct download link, refer to the JetBrains JDBC drivers page.
You can find the downloaded JDBC drivers in the GoLand configuration directory.
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 also use your drivers for the database instead of the provided ones. For more information about connecting to a database with your driver, see Add a user driver to an existing connection.
If there is no Download missing driver files link, then you already have the required drivers.
From the Authentication list, select Application Default Credentials.
In the Service account key file field, type the path to the service account key file that you generated on Step 2.
Ensure that the connection to the database can be established using the provided details. To do that, click the Test Connection link at the bottom of the connection details area.
In case of any connection issues, refer to the Cannot connect to a database page.
(Optional) By default, only the default project and dataset are introspected and available to work with. If you also want to work with other projects and datasets, in the Schemas tab, select them for the introspection.
Click OK to create the data source.
Find your new data source in the Database tool window (Alt01) .
To learn more about the Database tool window, see the corresponding reference topic.
tip
To see more projects and datasets under your new data source node, click the N of M button and select the ones you need. GoLand will introspect and show them.
To learn how to work with database objects in GoLand, see Database objects.
To write and run queries, open the default query console by clicking the data source and pressing F4.
To view and edit data of a database object, open Data Editor and Viewer by double-clicking the object.
In the Navigation menu of the Google Cloud Platform, select .
On the Service accounts page, click Create service account.
On the Service account details step in the wizard, type a project name and description.
On the Grant this service account access to the project step in the wizard, select roles for this service account.
For example, for read-only access, select BigQuery Data Viewer, BigQuery Job User, and BigQuery User from the BigQuery menu. Alternatively, select for access to all resources within the project. For more information about roles and permissions, see Predefined roles and permissions at cloud.google.com.
On the Service accounts page (), click the configuration icon in the Actions column and select Manage keys.
Click the Add key list and select Create new key.
In the Create private key dialog, select JSON and click Create.
The private key download is started automatically.
To connect to the database, create a data source that will store your connection details. You can do this using one of the following ways:
From the main menu, navigate to and select BigQuery.
In the Database tool window ( ) , click the New icon (
) in the toolbar. Navigate to Data Source and select BigQuery.
Check if there is a Download missing driver files link at the bottom of the connection settings area. Click this link to download drivers that are required to interact with a database. For a direct download link, refer to the JetBrains JDBC drivers page.
You can find the downloaded JDBC drivers in the GoLand configuration directory.
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 also use your drivers for the database instead of the provided ones. For more information about connecting to a database with your driver, see Add a user driver to an existing connection.
If there is no Download missing driver files link, then you already have the required drivers.
From the Authentication list, select Google Service Account.
In the Service account email field, type the service account email identifier.
You can get the identifier on the Service accounts page () on the Google Cloud Platform (see Generating service account keys). In our case, it is
intellij-ide@bigqueryproject-322409.iam.gserviceaccount.com.In the Project ID field, type the project identifier.
Usually, it is a part of the service account email identifier that goes after the at sign (
@). In our case, it isbigqueryproject-322409.In the Key file field, type the full path to the JSON key file that you downloaded on Step 3. Generating service account keys.
Ensure that the connection to the database can be established using the provided details. To do that, click the Test Connection link at the bottom of the connection details area.
In case of any connection issues, refer to the Cannot connect to a database page.
(Optional) By default, only the default project and dataset are introspected and available to work with. If you also want to work with other projects and datasets, in the Schemas tab, select them for the introspection.
Click OK to create the data source.
Find your new data source in the Database tool window (Alt01) .
To learn more about the Database tool window, see the corresponding reference topic.
tip
To see more projects and datasets under your new data source node, click the N of M button and select the ones you need. GoLand will introspect and show them.
To learn how to work with database objects in GoLand, see Database objects.
To write and run queries, open the default query console by clicking the data source and pressing F4.
To view and edit data of a database object, open Data Editor and Viewer by double-clicking the object.
In the Navigation menu on the Google cloud platform, click .
Follow the wizard and complete the configuration. For more information about user consent, see the User consent section at support.google.com.
In the Navigation menu on the Google cloud platform, click .
On the Credentials page, click .
From the Application type list, select Web application.
In the Authorised redirect URIs section, click Add URI and paste the following URI:
https://developers.google.com/oauthplaygroundClick Create.
In the OAuth client created window, you will see your client ID and client secret. Alternatively, you can click the created OAuth client ID configuration and get your credentials here.
Open the OAuth 2.0 Playground in a separate browser tab.
Click the OAuth 2.0 Configuration icon, select the Use your own OAuth credentials checkbox.
Paste your client ID and client secret in OAuth Client ID and OAuth Client secret fields.
Click Close in the OAuth 2.0 Configuration window.
In the wizard on Step 1. Select & authorize APIs, select .
Click Authorize APIs.
Follow the wizard in a browser and give permissions to the application.
On Step 2 Exchange authorization code for tokens, click Exchange authorization code for tokens.
Copy received refresh and access tokens.
To connect to the database, create a data source that will store your connection details. You can do this using one of the following ways:
From the main menu, navigate to and select BigQuery.
In the Database tool window ( ) , click the New icon (
) in the toolbar. Navigate to Data Source and select BigQuery.
Check if there is a Download missing driver files link at the bottom of the connection settings area. Click this link to download drivers that are required to interact with a database. For a direct download link, refer to the JetBrains JDBC drivers page.
You can find the downloaded JDBC drivers in the GoLand configuration directory.
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 also use your drivers for the database instead of the provided ones. For more information about connecting to a database with your driver, see Add a user driver to an existing connection.
If there is no Download missing driver files link, then you already have the required drivers.
From the Authentication list, select Access and Refresh Tokens.
In the Project ID field, type your project name.
Usually, it is a part of the service account email identifier that goes after the at sign (
@). In our case, it isbigqueryproject-322409.In the Access token field, paste your access token.
In the Refresh token field, paste your refresh token.
In the Client ID field, paste your client ID.
In the Client secret field, paste your client secret.
Ensure that the connection to the database can be established using the provided details. To do that, click the Test Connection link at the bottom of the connection details area.
In case of any connection issues, refer to the Cannot connect to a database page.
(Optional) By default, only the default project and dataset are introspected and available to work with. If you also want to work with other projects and datasets, in the Schemas tab, select them for the introspection.
Click OK to create the data source.
Find your new data source in the Database tool window (Alt01) .
To learn more about the Database tool window, see the corresponding reference topic.
tip
To see more projects and datasets under your new data source node, click the N of M button and select the ones you need. GoLand will introspect and show them.
To learn how to work with database objects in GoLand, see Database objects.
To write and run queries, open the default query console by clicking the data source and pressing F4.
To view and edit data of a database object, open Data Editor and Viewer by double-clicking the object.
Thanks for your feedback!