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

• 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

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

• Your Snowflake account email address

• Your Snowflake region

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