Inferring Schema from VARIANT Fields in Snowflake
I get asked about this a lot. Someone lands JSON from a REST API into a VARIANT column, and now they want proper columns without manually writing json_data:field1::VARCHAR, json_data:field2::NUMBER for every single path. And you guessed it - there's ...
anthu.dev5 min read