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:
- Create a data source for Snowflake.
- Create a data source view.
- Create a cube for Snowflake.
- Process the project – deploy the cube to SSAS.
NOTE: For SSAS tabular models, please use the ODBC driver instead.