# Create a Snowflake File Federation Data Stream

Create a file federation data stream to start the flow of data from your Snowflake source to Data 360.

| User Permissions Needed            |                      |
| ---------------------------------- | -------------------- |
| To create a Snowflake data stream: | Data Cloud Architect |

Before you begin:

- Make sure that the Snowflake file federation connection is set up.
- Review the [IP addresses](https://help.salesforce.com/s/articleView?id=data.c360\_a_data_cloud_ip_address_allowlist.htm\&type=5) to make sure the Snowflake connection has the necessary access.

1. In Data Cloud, on the Data Streams tab, click **New**.

2. Select Snowflake File Federation as the source of the data stream, and click **Next**.

3. From the dropdown menus, select the connection and the database to use.

4. Under **Schemas**, select the schema to use.

5. From the **Available Objects**, select the objects you want to include.

6. Click **Next**.

:::note
You can’t choose objects listed under **In Use Objects**.
:::

7. Enter the object name and object API name. For more information, see [Data Lake Object Naming Standards](https://help.salesforce.com/s/articleView?id=data.c360\_a_data_lake_object_naming.htm\&type=5).

8. Select the category to specify the type of data to ingest. For more information, see [Category](https://help.salesforce.com/s/articleView?id=data.c360\_a_category.htm\&type=5).

9. Select a primary key to uniquely identify the incoming records. For more information see, [Primary Key](https://help.salesforce.com/s/articleView?id=data.c360\_a_primary_key.htm\&type=5).

10. Select the source fields you want to ingest and click **Next**. Fields with convertible data types are listed under Supported Fields. See the Data Type Compatibility table for more information on data type mapping between Snowflake and Data Cloud.

:::note
Fields whose data types are not supported in Data 360 get listed under Unsupported Fields. It's recommended to map all fields of supported types from the table during datastream creation.
:::

11. Select the relevant data space. Choose **Default** for data space if you don’t have any other data space provisioned in your org. For more information, see [Data Spaces](https://help.salesforce.com/s/articleView?id=data.c360\_a_data_spaces.htm\&type=5).

12. Click **Deploy**.

## Data Type Compatibility

This table lists the mapping of Snowflake data types with Data 360 data types.

| Snowflake Data Type                                   | Is Auto-mapped to Data 360 Data Type |
| ----------------------------------------------------- | ------------------------------------ |
| NUMBER, DECIMAL, NUMERIC                              | Number                               |
| INT, INTEGER, SMALLINT, TINYINT, BYTEINT              | Number                               |
| BIGINT                                                | Number                               |
| FLOAT, FLOAT4, FLOAT8, DOUBLE, DOUBLE PRECISION, REAL | Number                               |
| VARCHAR, CHAR, CHARACTER, STRING, TEXT                | Text                                 |
| TIMESTAMP_LTZ                                         | DateTime                             |
| DATE                                                  | Date                                 |
| BOOLEAN                                               | Boolean                              |
| TIME                                                  | Not Suported                         |
| VARIANT, OBJECT, ARRAY, GEOGRAPHY, GEOMETRY           | Not Supported                        |
| BINARY, VARBINARY                                     | Not Supported                        |

## See Also

- [Salesforce Help: Zero Copy Data Federation](https://help.salesforce.com/s/articleView?id=data.c360\_a_byol_data_federation.htm\&type=5)
- [Salesforce Help: Billing Considerations for Data Federation](https://help.salesforce.com/s/articleView?id=data.c360\_a_billing_considerations_for_data_federation.htm\&type=5)
- [Salesforce Help: Caching in Data Federation](https://help.salesforce.com/s/articleView?id=data.c360\_a_accelerated_data_lake_objects.htm\&type=5)
- [Salesforce Help: Data Stream Settings and Refresh Modes](https://help.salesforce.com/s/articleView?id=data.c360\_a_data_stream_edit_settings.htm\&type=5)