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 ...})