Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Snowflake - disable cache (USE_CACHED_RESULT = FALSE)?

Hi!   I'm trying to test true performance of a report and wondering it it's possible to disable Snowflake cache in Power BI connection -> USE_CACHED_RESULT = FALSE?   https://docs.snowflake.net/m...
Tutorial Requests
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Mika,

 

It seems we can't do that within a connection. 

1. As we can see from your link, it's a server-side parameter. "Can be set for Account » User » Session".

2. The Snowflake connector is based on Snowflake ODBC Driver. As we can see from #connection-parameters, no such connection string can be sent through ODBC connection.

 

 

Best Regards,
Dale

jersey417's avatar
jersey417
Icon for Helper I rankHelper I
4 years ago

v-jiascu-msft 

 

Is this still a limitation with the new connector that was release for Snowflake? We would like to use the Query_tag option with the Line 

ALTER SESSION SET QUERY_TAG = 'Workspace name - Report name';

However, we've been unable to get this to work. Leveraging the query_tag option within the query would allow us to allocate Snowflake costs to the workspace/report level.