Skip to main content
Version: 0.0.36

Google BigQuery

Integrating Google BigQuery with Lakehousecat allows seamless interaction with your BigQuery environment for efficient data management and analytics. This guide will walk you through the steps required to set up a BigQuery connection within the Lakehousecat workspace.

Prerequisites​

Ensure you have the following before starting the integration process:

  • Access to Lakehousecat as an admin or builder
  • An existing Google BigQuery environment with connection credentials

Step-by-Step Guide​

  1. Start in the Workspace

    • Navigate to your Lakehousecat workspace where you manage data connections.

  2. Go to the Data Section

    • Click on the 'Data' menu to explore various data-related options within Lakehousecat.

  3. Select "Datasource Types"

    • To view available data sources, select the "Datasource Types" option.

  4. Choose "BigQuery Datasource Type"

    • Click on the "Google BigQuery Datasource Type" to initiate the configuration process.

Configure the BigQuery Connection​

  • Connection Name: Enter a clear and descriptive name for your connection. This name will be used to identify the connection throughout Lakehousecat.
  • BigQuery Connection-URI: Input the BigQuery connection URI in the correct format. Ensure this URI is complete and correct to facilitate a successful connection.
  • Description (Optional): Provide an optional description. This can help other administrators understand the purpose or scope of this connection.

Validate and Create the Connection​

  1. After entering the required information, click on the Create button.
  2. Lakehousecat will initiate validation of the connection parameters. Ensure that all details are correct to avoid validation errors.
  3. Once the validation is successful, your BigQuery connection will be established and ready for use.

Best Practices​

  • Naming Conventions: Use a consistent naming convention for connection names to improve recognition and manageability.
  • Description Usage: Utilize the description field to provide insights into the connection's intended use, especially if multiple connections exist.

Troubleshooting​

If you encounter issues during the connection setup:

  • Validation Errors: Double-check the BigQuery Connection-URI for correctness.
  • Access Issues: Ensure you have the necessary permissions within both Lakehousecat and BigQuery.