After you purchase and activate the connector, you can proceed with creating a Google BigQuery connection in AWS Glue Studio.

Take the following steps to create a Google BigQuery connection in AWS Glue Studio.

  1. Sign in to the AWS Glue Console.
  2. Click AWS Glue Studio from the left-hand navigation menu.
  3. Click Connectors from the left-hand navigation menu.
  4. Under Your connectors, select the Google BigQuery connector.
  5. Click Create connection to open the Create connection page.
  6. Enter a name and description for your connection in the corresponding fields.
  7. In Connection access, select a JDBC URL format for your connection. oauth_refresh_token_grant is currently the only supported format.

    Step result:

    The JDBC URL result pane populates with the corresponding JDBC URL template.

    oauth_refresh_token_grant template

    jdbc:ddcloud:googlebigquery:Project=${Project};Dataset=${Dataset};
   ClientId=${ClientId};ClientSecret=${ClientSecret};AccessToken=${AccessToken};
   RefreshToken=${RefreshToken}
  8. Under Data source credentials, select Use a secret. Then, from the Secret drop-down menu, select the name of the secret used to store credential information in AWS Secrets Manager.
  9. Under Additional URL parameters, provide additional key-value pairs to be used in the JDBC URL.

    See the following topics for additional information on supported properties.

    Step result:

    The JDBC URL result pane populates with the key-value pairs you have specified.

  10. Click Create connection to create a connection to your Google BigQuery data source.
    Note: Network options do not apply when connecting to SaaS data sources.

Results:

Once the connection is created, the Connector page appears, showing both the available connectors and your connections. A green informational banner at the top lists the name of the recently created connection.

What to do next:

See Creating and running an ETL job in AWS Glue descriptions.