The Hidden Trap in Snowflake's INFER_SCHEMA

Jan 13 · 4 min read · I've always been a fan of Snowflake's INFER_SCHEMA() function. Not only because it saves you from manually typing out column definitions but the whole idea of letting Snowflake figure out your schema from actual data feels like the right level of aut...