• The dot notation for addressing JSON elements
  • The dot notation for addressing arrays
  • Dot notation for nested JSON elements
  • 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
  • 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