Month: February 2023

Sometimes you have to work with different kinds of data in Snowflake – just like in most databases. Today I want to work with some JSON – the same basic premise works for XML, Arrays, and other variants. SELECT * FROM TABLE(FLATTEN(input => parse_json(‘[3089, NULL, 217]’))); So, first, let’s go thru the parse_json portion. Notice…… Continue reading Flattening out data in SnowFlake

Sometimes, you need to work with tables that have a predefined list of values. You can have these automatically uploaded and refreshed to Snowflake via several means inherent to Snowflake (or any of a variety of methods from PowerShell, R, Python, etc..) But, sometimes, you want a small list of data inherent to a query…… Continue reading Making Baby Tables In SnowFlake