Using the JSON Data Type in Google BigQuery

Publié le: 26 août 2022
sur la chaîne: Ternary Data

3,779

Update: the BigQuery JSON type has now graduated to general availability and is ready for production use.

I explain motivations and use cases for the native JSON type in Google BigQuery, then provide a quick start demo.

Intro: 0:00
Demo: 1:40

Book pages are from Fundamentals of Data Engineering (O'Reilly)
(https://learning.oreilly.com/library/...)

Related videos:

Data Driven NYC talk on Fundamentals of Data Engineering (   • Fundamentals of Data Engineering | Jo...  )
How to load a CSV into BigQuery (   • BigQuery - How to load a local csv in...  )
BigQuery Pricing - How It Works and Best Practices (   • BigQuery Pricing - How It Works and B...  )
Becoming a BigQuery Superhero (   • Becoming a BigQuery Superhero, with J...  )
Data Mesh, Data Fabric, and More (   • Data Mesh, Data Fabric, and more w/ B...  )
SQL or NoSQL in 2021? (   • SQL or NoSQL in 2021? - Monday Mornin...  )
Fundamentals of Data Engineering Book Chat (   • Fundamentals of Data Engineering - Bo...  )

Links from the tutorial:

Working with JSON data in Google Standard SQL
https://cloud.google.com/bigquery/doc...

JSON
https://www.json.org/

MongoDB
http://mongodb.com

Amazon DynamoDB
https://aws.amazon.com/dynamodb

Firestore: NoSQL document database
https://cloud.google.com/firestore

Semi-structured Data — Snowflake Documentation
https://docs.snowflake.com/en/user-gu...

Specify nested and repeated columns in table schemas | BigQuery
https://cloud.google.com/bigquery/doc...

Working with JSON data in BigQuery | by Lak Lakshmanan
  / working-with-json-data-in-bigquery

#json #dataengineering #data #cloudnative #nosql #analytics #database #datascience #bigquery #fundamentalsofdataengineering

Sur cette page du site, vous pouvez voir la vidéo en ligne Using the JSON Data Type in Google BigQuery durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Ternary Data 26 août 2022, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 3,779 fois et il a aimé 33 téléspectateurs. Bon visionnage!

4,045