Admin: Google Bigtable configuration

Overview

This section describes how to configure Google Bigtable. Please follow the steps below:

Obtaining a Bigtable instance ID

1. In a web browser, navigate to https://console.cloud.google.com to log into the Google Cloud console.

2. Once you have successfully logged on, you will be redirected to the portal’s main page.

3. In the dashboard navigation menu, select Bigtable.

4. Once the Bigtable interface is displayed, take note of the Bigtable Instance ID, as this will be used to configure Google BigQuery.

Obtaining a Google Cloud project ID

1. While in the Google Cloud console, select the project selector to the right side of the Google Cloud Platform interface.

2. Once the project selector is displayed, take note of the currently-selected project ID, as this will be used to configure Google BigQuery.

Creating a Google BigQuery dataset

1. Open the BigQuery page in the Google Cloud console.

2. In the Explorer panel, select the project where you want to create the dataset.

3. Expand the three dot action menu option and select Create dataset.

4. On the Create dataset page:

   • For Dataset ID, enter a unique dataset name.

   • For Data location, choose a geographic location for the dataset. After a dataset is created, the location can't be changed.

5. Select Create dataset.

Creating a Google Bigtable table

1. Open the list of Bigtable instances in the Google Cloud console.

2. Select the instance whose tables you want to view.

3. Select Tables in the left pane. The Tables page displays a list of tables in the instance.

4. Select Create a table.

5. Enter a table ID for the table.

6. Add column families (optional).

7. Select Create.

Creating a Google BigQuery table

1. In the Google Cloud console, go to the BigQuery page.

2. In the query editor, enter the following statement.

CREATE EXTERNAL TABLE DATASET.NEW_TABLE
OPTIONS (
  format = 'CLOUD_BIGTABLE',
  uris = ['URI'],
  bigtable_options = BIGTABLE_OPTIONS );

3. Replace the following:

   • DATASET: dataset name created at Google BiqQuery.

   • NEW_TABLE: table Id from the Google Bigtable created.

   • URI: https://googleapis.com/bigtable/projects/[YOUR-PROJECT-ID]/instances/[YOUR-BIGTABLE-INSTACEID]/tables/YOUR-BIGTABLE-TABLE-ID.

   • BIGTABLE_OPTIONS: the schema for the Bigtable table in JSON format.

CREATE EXTERNAL TABLE DATASET.NEW_TABLE
OPTIONS (
  format = 'CLOUD_BIGTABLE',
  uris = ['https://googleapis.com/bigtable/projects/[PROJECT-ID]/instances/[INSTANCE-ID]/tables/[TABLE-ID]'],
  bigtable_options = """
    {
      bigtableColumnFamilies: [
        {
          "familyId": "[FamilyName]",
          "type": "INTEGER",
          "encoding": "BINARY"
        }
      ],
      readRowkeyAsString: true
    }
    """
);

4. Select RUN.

Installing Google BigQuery ODBC driver for Bigtable

Google Bigtable database connector required Google BigQuery ODBC driver, please refer to the Google BigQuery ODBC driver configuration section above. Once all set, you may want to test the connection by selecting Test. Otherwise, select OK to save your settings.