> ## Documentation Index
> Fetch the complete documentation index at: https://docs.prophecy.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Snowflake SQL fabric

> Run models on a Snowflake warehouse

<Callout icon="/images/icon.png" color="#FFC107">
  Available only in [Enterprise Edition](/data-engineering/administration/platform/editions).
</Callout>

To run models on Snowflake, you need to create a fabric with a Snowflake connection.

## Create a fabric

Fabrics define your Prophecy project execution environment. To create a new fabric:

1. Click on the **Create Entity** button from the left navigation bar.
2. Click on the **Fabric** tile.

## Basic Info

Next, complete the fields in the **Basic Info** page.

1. Provide a fabric title, such as `snowflake-dev`.
2. (Optional) Provide a fabric description.
3. Select a [team](/data-engineering/administration/management/teams/teams) to own this fabric. Open the dropdown to see teams you belong to.
4. Click **Continue**.

<img src="https://mintcdn.com/prophecy-62973bd0/noSvxSYkIPZNsTzk/data-engineering/fabrics/sql-provider/img/SnowflakeFabric1.png?fit=max&auto=format&n=noSvxSYkIPZNsTzk&q=85&s=3ebcaf4b6d86329688a495d3369b8dd9" alt="Snowflake fabric basic info" width="2880" height="1084" data-path="data-engineering/fabrics/sql-provider/img/SnowflakeFabric1.png" />

## Provider

The SQL provider is both the storage warehouse and the execution environment where your SQL code will run. To configure the provider:

1. Under **Provider**, select **Snowflake**.

2. Add the **Snowflake Account URL** (for example, `https://<org>-<account>.snowflakecomputing.com`).

3. Add the **username** that will be used to connect to the Snowflake Warehouse.

4. Add the **password** that will be used to connect to the Snowflake Warehouse.

   <Note>
     Each Prophecy user will provide their own username/password credential upon login. Prophecy
     respects the access scope of the Snowflake credentials, meaning users in Prophecy can read
     tables from each database and schema for which they have access in Snowflake. These
     username/password credentials are encrypted for secure storage.
   </Note>

5. Add the [Snowflake role](https://docs.snowflake.com/en/user-guide/security-access-control-overview#roles) that Prophecy will use to read data and execute queries on the Snowflake Warehouse. The role must be already granted to the username/password provided above.

6. Specify the **Snowflake warehouse** for default writes for this execution environment.

7. Specify the desired **Snowflake database and schema** where tables will be written to by default.

8. Click **Complete** to save the new fabric.