• The dot notation for addressing JSON elements
    JSONDoc:Schema:Element::Cast
  • The dot notation for addressing arrays
    JSONDoc:Schema[0]:”Element”::Cast
  • Dot notation for nested JSON elements
    JSONDoc:Schema:NestedSchema:Element::Cast
  • Lateral flattening of unbounded nested arrays
    Lateral Flatten(Input => Parse_JSON(JSONDoc:Schema:Array)
  • Native storage as the Variant file type in a table, as a column
  • Hybrid tables with traditional columns for common query predicates
    https://medium.com/snowflake/hybrid-relational-json-tables-in-snowflake-ec1d7676c67e
  • Storing the JSON in a column in the same table with traditional columns for schema evolution
  • Storing the JSON in a…



Learn how to use the Snowflake Data Marketplace with a real example.

Photo by NASA on Unsplash







David A Spezia

David spends his time working with Web-Scale Data Applications built on Snowflake with the largest tenants on the Snowflake Data Cloud.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store