Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Categories data sources
Created by Guest
Created on Jun 29, 2020

Snowflake adapter - ability to override Snowflake session configuration

Snowflake allows various overrides to be done at the session level, including:

  • USE_CACHED_RESULT - https://docs.snowflake.com/en/sql-reference/parameters.html#use-cached-result

  • QUERY_TAG - https://docs.snowflake.com/en/sql-reference/parameters.html#query-tag

  • Prevent TDV from bringing back query results from Snowflake (to avoid query data transfer overhead) - equivalent to https://docs.snowflake.com/en/user-guide/snowsql-config.html#execution-only in Snowsql

etc.

These features are extremely useful both for development, and cost management.

Please add support to override these settings at:

  • Data Source level

  • Query level (e.g. SELECT {OPTION ...})

  • Attach files