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
Nesta página do site você pode assistir ao vídeo on-line Using the JSON Data Type in Google BigQuery duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Ternary Data 26 Agosto 2022, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 3,779 vezes e gostou 33 espectadores. Boa visualização!
