addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupsimageimagesinstagramlinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1outlookpersonJoin Group on CardStartprice-ribbonShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruseryahoo

Snowflake: using JSON. handling arrays and nested arrays.

  • to
  • This location is shown only to members

  • The November 22nd meeting is being cancelled (too close to Thanksgiving). We will, instead, meet on Tuesday December 6th.

    Our topic will be: "JSON -- and how to handle it within snowflake"


    We will demonstrate:

    • how to pull key/value pairs out of JSON

    • how to flatten simple arrays

    • how to flatten nested arrays

    • how to deal with performance concerns when dealing with tables with many rows and with LARGE JSON objects.  (ETL strategies)





Join or login to comment.

Want to go?

Join us!

10 going

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy