Google BigQuery – Additional Information

Obtaining Project ID and Dataset ID Values

You will need a Project ID and a Dataset ID to use Methods in the Connector’s Tables Category.

Project ID

From the Google Cloud Platform dashboard:

  1. Select the project name from drop down button in the navigation bar.
  2. Make a note of the project ID listed under the ID heading. As an example, that might be:
    myproject-389110

Note: You can also find the project ID if you install the Google BigQuery Connector without a project ID or dataset ID set, then use the Utilities > Projects > List Projects Method.
After you this, you can re-authenticate the Connector and set the Project ID on it.

Dataset ID

From the Google BigQuery dashboard:

  1. In the Explorer pane, select the arrow to the left of the project ID to expand it.
  2. Select the arrow to the left of each dataset to view the tables within it and make a note of the dataset ID.

Note: You can also find the dataset ID if you install the Google BigQuery Connector without a project ID or dataset ID set, then use the Utilities > Datasets > List Datasets Method.
After you this, you can re-authenticate the Connector and set the Dataset ID on it.

Create a Table Custom Object Category

You can create a Custom Object Category to access each table within a project and dataset as it’s own method category. Create multiple Custom Object Categories to access multiple tables under a single connector installation.

Note: You need to install the Google BigQuery Connector with a Project ID and Dataset ID for table custom objects to function.

To create a table Custom Object, from the Edit Connector page of the Google BigQuery connector:

  1. Under the Methods & Fields heading, select the Tables methods category.
  2. Select the pink Copy this Category to create a Custom Category Object icon.
  3. Select the Select object dropdown.
  4. Select the table you want to create a Custom Object Category for.
  5. Select Copy.

The methods within the new method category you created now target the selected table.

Give dataset access to another user

You can give other users access to a dataset. For more information, see Google BigQuery’s documentation on IAM access control.

Add access for another user from the Google BigQuery console:

  1. From the Explorer pane, navigate and select the dataset.
  2. From the dataset navigation menu bar, select Sharing > Permissions.
  3. Select Add Principal.
  4. Under the Add principals heading, in the New principals field, enter users, groups, domains, or service accounts to give access to.
  5. Under the Assign roles heading, select the Select a role dropdown box to assign roles.
  6. Select Save.

Insert table data delay

Because Google BigQuery needs to process and stream the data from Google’s internal servers to the table before you can access it, there might be a delay when you insert table data, before you can access the data.

If the insert call doesn’t return an error, the data appears in your table within 24 hours.