Using the JSON Data Type in Google BigQuery
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
On this page of the site you can watch the video online Using the JSON Data Type in Google BigQuery with a duration of hours minute second in good quality, which was uploaded by the user Ternary Data 26 August 2022, share the link with friends and acquaintances, this video has already been watched 3,779 times on youtube and it was liked by 33 viewers. Enjoy your viewing!
