TLDR Data · MISCELLANEOUS

SNOWFLAKE SAYS THIS 149 GB QUERY SCANNED -1.5 GB

espresso.ai3 min read

Summary from the TLDR Data newsletter

Unloading Snowflake QUERY_HISTORY data to Parquet can corrupt values when large numbers are written as INT32. Casting the nine affected columns before export prevents overflow, bad joins, and incorrect analysis.