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.
Prerequisitesβ
To leverage connections, you need a Prophecy fabric and a SQL project.
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.
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.
What's nextβ
Visit the following pages to learn more about available connections.
ποΈ Amazon Redshift
Learn how to connect to Redshift
ποΈ Amazon S3
Learn how to connect to Amazon S3 buckets
ποΈ Databricks
Learn how to connect with Databricks
ποΈ Snowflake
Learn how to connect with Snowflake
ποΈ Microsoft SharePoint
Learn how to connect with SharePoint
ποΈ Microsoft OneDrive
Learn how to connect to OneDrive
ποΈ MongoDB
Learn how to connect with MongoDB
ποΈ MSSQL
Learn how to connect with Microsoft SQL Server
ποΈ Oracle DB
Learn how to connect to Oracle
ποΈ SFTP
Learn how to set up an SFTP connection in Prophecy
ποΈ Smartsheet
Learn how to connect with Smartsheet
ποΈ SMTP
Learn how to configure an SMTP connection
ποΈ Tableau
Learn how to connect with Tableau