Skip to main content
Available on the Enterprise Edition only.
To create a fabric using Google BigQuery as the provider, follow the steps below.
1

Create a new fabric entity

Begin by creating a new fabric entity in Prophecy.
  1. From the left sidebar, click the + sign.
  2. On the Create Entity page, select Fabric.
2

Fill in the Basic Info tab

The Basic Info tab lets you define the key identifiers of the fabric.
  1. Provide a name for the fabric.
  2. (Optional) Provide a description for the fabric.
  3. Select a team that can access the fabric.
  4. Click Continue.
3

Select the provider

The Providers tab allows you to choose a SQL warehouse provider. You cannot change the fabric provider after you create the fabric.
  1. Under Provider, select BigQuery.
4

Fill in the Connections tab

The Connections tab allows you to store your credentials to various external data providers for reuse while attached to the fabric.
  • Under SQL Warehouse Connection, click + Connect SQL Warehouse.
  • Select BigQuery as the connection type and configure the connection details.
You can add Data Ingress/Egress Connections to your fabric if you want, but these are not required.
5

Save the fabric

Click Complete to save the fabric.

​
Column name handling

BigQuery does not allow certain special characters in column names. When a pipeline uses a BigQuery fabric, Prophecy automatically encodes column names that contain unsupported characters for storage in BigQuery, then decodes them back to their original form for display throughout the pipeline UI and when writing to external targets. For example, when Prophecy encounters a column named revenue(USD), it stores this column as _PCYBQ__revenue_lp_USD_rp_ for BigQuery fabrics. In schema panels, the expression builder, and data previews, Prophecy displays the original name. You can hover over an encoded column name to see the physical name stored in BigQuery. The following characters trigger encoding: !, ", $, (, ), *, ,, ., /, ;, ?, @, [, \, ], ^, `, {, }, ~. See BigQuery’s docs for more information on this topic.
Automatic encoding applies to column names ingested from external sources. Manually entering unsupported characters in column name fields (for example, in a Reformat gem) is not currently supported.

​
Edit an existing fabric

To edit an existing fabric:
  1. From the left sidebar, click the Metadata page.
  2. Navigate to the Fabrics tab.
  3. Open the fabric you want to edit.
  4. Update the fabric. Prophecy automatically saves your changes.

​
Edit advanced settings

To edit advanced settings, click the Advanced tab for the fabric. Here, you can select or deselect Allow agent to access data. This allows Prophecy agents to suggest data transformations and actions based on the data in the fabric.