Skip to main content

Google BigQuery SQL

To use your Google BigQuery warehouse for execution in Prophecy, you need to create a SQL fabric with a BigQuery connection.

Create a fabric​

Fabrics define your Prophecy project execution environment. To create a new fabric:

  1. Click on the Create Entity button from the left navigation bar.
  2. Click on the Fabric tile.

Basic Info​

Next, complete the fields in the Basic Info page.

  1. Provide a fabric title. It can be helpful to include descriptors like dev or prod in your title.
  2. (Optional) Provide a fabric description.
  3. Select a team to own this fabric. Open the dropdown to see the teams you belong to.
  4. Click Continue.

Provider​

The provider is both the storage warehouse and the execution environment where your SQL code will run. To configure the provider:

  1. Select SQL as the Provider type.
  2. Open the Provider types dropdown and select BigQuery.
  3. Fill in the Database (or BigQuery dataset), which will be the default location for target models.
  4. Add your KMS Key Name to identify your BigQuery key.
  5. Upload your key to authenticate the BigQuery connection.

Optional: Connections​

If you want to crawl your warehouse metadata on a regular basis, you can set a connection here.

What's next​

Attach a fabric to your SQL project and begin data modeling!