Catalog, document, and query live data from BigQuery by configuring a virtual connection.
When connecting your data systems to data.world, often your system or firewall may have a network policy that only allows access from specific IP addresses--your allowlist. In those cases, you must add data.world to your network policy IP allowlist.
Allow the following IP addresses:
Go to the BigQuery integration page and click Enable integration to set up a connection.
In order to create a virtual connection to BigQuery you will use the following parameters:
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. This file will be uploaded when you enter the other configuration information into the dialog.
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:
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:
Go to the 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.
Database connectors - A full list of our connection integrations