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.
info
Connections are stored per fabric.
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 |
| Databricks volumes | File store |
| Snowflake stage | File store |
| Amazon S3 | File store |
| SFTP | File store |
| Microsoft Sharepoint | File store |
| Smartsheet | Web application |
| MSSQL | Database |
| MongoDB | Database |
| Tableau | BI tool |