Connections
Prophecy lets you work with various data providers when building your pipelines. To make this easier, you can create connections between Prophecy and a data provider. Once you add connections a fabric and use that fabric in a project, you can:
- Reuse credentials that are established in the connection.
- Browse data from the data provider in the Environment browser of your Prophecy project.
- Auto-index data for search in the Prophecy interface.
Connections access
Prophecy controls access to connections through fabric-level permissions.
- To access a connection, you must have access to the fabric where it was created. You can only access fabrics that are assigned to one of your teams.
- To use a connection in your project, attach a fabric that includes that connection. You can attach any fabric that belongs to one of your teams.
- To create a new connection, you can do so inside of a fabric or in the project itself after attaching to a fabric.
info
Most connections are only used to read from and write to data sources. The SQL Warehouse connection is an exception—it also provides the compute environment for pipeline execution.
Supported connections
If you are using a Prophecy fabric, you can add the following connections. You will have to be attached to a fabric to utilize its connections.
| Connection | Type |
|---|---|
| Databricks | Cloud data warehouse |
| Snowflake | Cloud data warehouse |
| Amazon S3 | File store |
| SFTP | File store |
| Microsoft SharePoint | File store |
| Smartsheet | Web application |
| MSSQL | Database |
| MongoDB | Database |
| Tableau | BI tool |
What's next
To learn more about fabric components, visit the documentation on Prophecy fabrics and secrets.