To run analysis on your Snowflake data, you can use CRM Analytics Direct Data for Snowflake or Snowflake input connectors or a combination of the two.
Refer to these guidelines to determine whether Direct Data for Snowflake meets your business needs.
With Direct Data for Snowflake, you can:
- Save time on setup and eliminate the need for data syncs, dataflows, or recipes to keep queries based on Snowflake data up to date.
- Eliminate the need to load and prepare large volumes of Snowflake data into CRM Analytics and manage its dataflows.
- Free up data pipelines for the resources and processes that require them.
- Get real-time metrics in dashboards and lenses with queries based on Snowflake data.
- Meet data residency requirements on Snowflake data but still analyze it to make business decisions.
- Maintain on-demand access to less frequently used data, such as order details, without having to load it into CRM Analytics.
- Incorporate data from Snowflake Data Marketplace for deeper insights on your Snowflake data.
- Take advantage of Snowflake’s native support for analytics on data in semi-structured data formats, such as JSON, Parquet, or XML.
- Quickly create and test which data models to use with your Snowflake data before connecting it to CRM Analytics. You can even collaborate easily with other users during this process.