When to Use CRM Analytics Direct Data for Snowflake

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.