Data Engineering, Data Analytics, Database, Snowflake, Software Engineering.
expressions down into the scan operator so that only the necessary columns are accessed and cast directly into the target SQL type without bringing up the whole VARIANT. The optimizations described above are performed separately for each table data file. However, it causes Snowflake some trouble.