Create a Prophecy fabric
Use the following instructions to create a Prophecy fabric.
Create entity
- From the left sidebar, click the + sign.
- On the Create Entity page, select Fabric.
Each of the following sections corresponds to a tab of the fabric settings.
Basic Info
The Basic Info tab lets you define the key identifiers of the fabric.
| Parameter | Description | Required |
|---|---|---|
| Name | Name of the fabric. | Yes |
| Description | Description of the fabric. | No |
| Team | Team that can access the fabric. | Yes |
Providers
The Providers tab allows you to configure what type of execution environment you would like to create.
| Parameter | Description | Required |
|---|---|---|
| Provider Type | Type of fabric. Choose Prophecy. | Yes |
| Provider | Provider of the primary SQL warehouse. Prophecy supports Databricks and BigQuery. | Yes |
| Advanced Settings | Option to use Prophecy Automate from a different networking zone (only applicable if not deployed in Prophecy network). | No |
Connections
The Connections tab allows you to store your credentials to various external data providers for reuse while attached to the fabric.
| Parameter | Description | Required |
|---|---|---|
| SQL Warehouse Connection | Primary SQL warehouse connection. A connection must be made to the Provider defined in the previous tab. When you use this fabric, all SQL queries will be executed on this warehouse. | Yes |
| Ingress/Egress Connections | Additional connections to external data providers that can be reused throughout pipelines. For a complete list of supported connections, visit Connections. | No |
Your SQL warehouse connection gives Prophecy access to both the execution environment and cloud storage of that connection. Additional ingress/egress connections in your fabric are only used for reading and writing data (not pipeline execution).
Secrets
The Secrets tab lets you encrypt your sensitive data, so you can use values without directly exposing them in your projects or pipelines. Prophecy fabrics leverage Prophecy secrets to manage both text-based and binary secrets.
| Parameter | Description | Required |
|---|---|---|
| Secrets | Encrypted data that can be used by anyone in the fabric team. | Required for certain connections |
Save the fabric
Once you have configured these parameters:
- Prophecy will test the connection for you.
- If the connection fails, Prophecy will provide an error to help you troubleshoot the connection.
- If the connection succeeds, you can Save the connection.