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