Catalog, document, and query live data from Google BigQuery by configuring a virtual connection.
In order to create a virtual connection to Google BigQuery you need to have the following:
- Project ID - The unique identifier for your BigQuery project
- Service account username - A Google account that is associated with your Google project, as opposed to a specific user
- Service account key file - Provides the authentication information used in the connection configuration
If your system has policies in place which specify the IP addresses that are allowed in, you must add data.world to your network policy IP allowlist. Allow the IP addresses noted on this documentation page.
Set up Connection
Go to the BigQuery integration page and click Enable integration to set up a connection:
Choose a Display name for your connection. This is the name everyone in your organization will see for the connection. Then enter your user credential information into the dialog screen and upload the key file:
Click Test BigQuery configuration to make sure it works, and then save it by selecting Configure.
After your connection is configured you can use it anytime you select Add data:
Choose the connection you want to use from My data sources:
Add or modify a connection
Go to the BigQuery integration page integration page (easily found under My integrations on our Integrations page) and select Manage:
From here you can edit your current connection or add a new one:
You will need your original credentials (password or key file) to make changes to an existing connection.