Microsoft Fabric: JSON Deserialization to Ingest Census Data in Microsoft Fabric!
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
Смотрите видео Microsoft Fabric: JSON Deserialization to Ingest Census Data in Microsoft Fabric! онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Tales From The Field 24 Июль 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 29 раз и оно понравилось 1 людям.