SQL fabrics

SQL fabrics let Prophecy connect to SQL warehouses for storage and compute engine capabilities.

info

You can only run models on SQL fabrics. To run pipelines in a SQL project, use a Prophecy fabric.

Job scheduling

If you use a SQL fabric, you can set up jobs on a regular basis using Databricks Jobs or Apache Airflow. However, we recommend you use Prophecy scheduling with Prophecy fabrics for SQL projects.

What's next

Prophecy supports the following providers for SQL fabrics.

Databricks SQL

Run models on a Databricks SQL warehouse

Snowflake SQL

Run models on a Snowflake warehouse

Google BigQuery SQL

Run models on a Google BigQuery warehouse