Snowflake's 149 GB query_history export scanned -1.5 GB: integer overflow in Parquet unloads
Unloading Snowflake ACCOUNT_USAGE query_history to Parquet writes bytes_scanned as INT32, silently overflowing any value past 2^31 and corrupting your cost and scan analysis. A bare NUMBER(38,0) column keeps its narrow on-disk physical type; wrapping it in any expression or an identity CAST fixes the export. Simple cast before you unload or your aggregates lie.