Microsoft Fabric: JSON Deserialization to Ingest Census Data in Microsoft Fabric!

Published: 24 July 2024
on channel: Tales From The Field

297

Need to consume US Census Data? Trying to understand how to Deserialize JSON Data? Trying to understand how to ingest malformed or irregularly formed JSON Data? Well Bradley Ball, aka ‪@SQLBalls‬ , has got you covered! We walk through how to get access to Census Data, how to select an API, then how to take JSON in a nonstandard version of JSON and ingest it into Microsoft Fabric!

Chapters
00:00 Errors we are facing
02:27 Demo Review US Census Data JSON Structure
03:41 Demo Ingesting Census Data in PYSpark
06:25 Demo Validate Data in SSMS
07:26 Demo Transform Data in Spark SQL part 1
08:11 Demo Validate Data in SSMS
08:29 Demo Transform Data in Spark SQL part 1
08:45 Demo Validate Final Data in SSMS
09:41 Demo Review Fabric Code

How to use Microsoft Fabric notebooks
https://learn.microsoft.com/en-us/fab...

United States Census Bureau
https://www.census.gov/en.html

Census Data API User Guide
https://www.census.gov/content/dam/Ce...

/*******************
/CONNECT WITH US!!
/*******************

Tales from the Field
Twitter/X: https://x.com/TalesftField
Linkedin:   / 100091910

Bradley Ball
Twitter/X: https://x.com/SQLBalls
Linkedin:   / sqlballs

Daniel Taylor
Twitter/X: https://x.com/dbabulldog
Linkedin:   / danieltaylor3

Neeraj Jhaveri
Twitter/X: https://x.com/neeraj_jhaveri
Linkedin:   / neerajjhaveri

Josh Luedeman
Twitter/X: https://x.com/joshluedeman
Linkedin:   / joshluedeman

Andrés Padilla
Twitter/X: https://x.com/nodestreamio
Linkedin:   / andrespadillaandrade

Bradley Schacht
Twitter/X: https://x.com/BradleySchacht
LinkedIn:   / bradleyschacht

Marco Aurelio Cardoso
Twitter/X: https://x.com/macardoso95
LinkedIn:   / marco-cardoso

Watch video Microsoft Fabric: JSON Deserialization to Ingest Census Data in Microsoft Fabric! online without registration, duration hours minute second in high quality. This video was added by user Tales From The Field 24 July 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 297 once and liked it 17 people.