CODEWITHSUNDEEP
odbcssassnowflake-cloud-data-platform
Eric Mamet
Eric Mamet

Reputation: 3681

Using Snowflake database as a SSAS (SQL Server Analysis Services) datasource?

We "need" to feed our SSAS Tabular models with Snowflake data (through ODBC because we have no Snowflake connector).

We tried with SQL Server 2016 and SQL Server 2017 and get atrocious performance (few rows a second...).

Under PowerBI, there is a Snowflake connector and it's fast.

I came across a thread from someone having an apparently similar speed problem when trying to feed Snowflake data to SAS.

He seems to have solved his problem by specifying some (ODBC?) parameters:

Are these parameters specific to Snowflake? Or just ODBC?

Thanks

Eric

Upvotes: 1

Views: 3272

Answers (2)

GregGalloway
GregGalloway

Reputation: 11625

Instructions for SSAS Tabular models in Azure Analysis Services are here. Everything except the On Premises Data Gateway should apply to you.

Make sure you check whether tracing=0 in your ODBC data source as tracing=6 killed performance for me.

Upvotes: 1

JB512
JB512

Reputation: 73

These are SAS options, not ODBC or Snowflake.

For the load issue, ODBC row by row inserts is typically a slow approach.

Is there an option for you to export the data to S3 or Blob and then bulk load in SSAS before running your models - or alternatively could you push down the queries to Snowflake itself?

Upvotes: 2

Related Questions