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