Q3 CData Driver Tip of the Quarter

Tip:  Build and Deploy a multidimensional model of Snowflake data

If you need to create cubes from Snowflake data for more efficient and comprehensive data analysis and you use SQL Server Analysis Services (SSAS) for building enterprise-grade semantic data models, this tip is for you!

In a few achievable steps, use CData’s ADO.NET Provider for Snowflake to:

1. Create a data source for Snowflake.
2. Create a data source view.
3. Create a cube for Snowflake.
4. Process the project – deploy the cube to SSAS.

Read this article for the detailed steps. Although this example references Snowflake data, CData has hundreds of other low-code ADO.NET Providers, check out this page.

NOTE: For SSAS tabular models, please use the ODBC driver instead.