> For the complete documentation index, see [llms.txt](https://docs.chartbeat.com/datastream/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.chartbeat.com/datastream/destination-setup/snowflake.md).

# Snowflake

**Snowflake Data Sharing for Datastream** is a secure and direct way to route Chartbeat traffic and engagement metrics right into your Snowflake warehouse.

By leveraging Snowflake's architecture, we eliminate any data copying or transferring. Because Chartbeat pre-deduplicates and normalizes the datasets on our end before sharing, your data arrives clean, accurate, and ready to analyze.

#### **Data Availability** <a href="#h_01kwcnmked15736g2mknhqtgd0" id="h_01kwcnmked15736g2mknhqtgd0"></a>

* **Update Frequency**: Hourly. Please note that data is delayed by 4 hours i.e you wouldn't see yesterday's data in full until 4 AM next day.
* **Historical Data**: Available from November 2021 to present.

#### **Performance Optimization**  <a href="#h_01kwcnmt6kawqy2p5t0468hnbz" id="h_01kwcnmt6kawqy2p5t0468hnbz"></a>

The view is clustered by the DT and HOST columns. **Always include DT in your WHERE clause** when querying to ensure optimal query execution time.

**Technical Notes**

* DT: Timestamp field with hourly granularity
* DEPARTURE\_TIMESTAMP: Provides second-level precision for more granular analysis
* **Row Definition**: Each row represents one pageview

#### **What we need from you** <a href="#h_01kwcnn3hdgw9drrffqp3thb0g" id="h_01kwcnn3hdgw9drrffqp3thb0g"></a>

* Your Snowflake account email address
* Your Snowflake region

Please reach out to your Customer Success representative with this information to get started.