DataEngBytes 2023 - MEL-T1-04 - Michael Hyatt
summary
Demonstrates schema-on-read by immediately storing API payloads (two JSON endpoints and one XML) as raw strings/JSON plus a timestamp, then parsing later with transformations in Ascend.io pipelines into a structured table; uses Python and Spark to ingest and shows Snowflake JSON extraction via pass_json functions. Claims this removes network-failure loss, lets multiple schema versions be tried, and the demo produces reproducible structured datasets from the parked payloads so recovery and schema evolution succeed.
AI-written summary · about
chapters (6)
- 0:00Schema on read intro
- 1:46API failures and handling
- 6:53What schema on read means
- 9:03Deferring schema validation
- 12:14Demo: schema on read
- 18:23Summary
related talks
29mDataEngBytes 2023 - SYD-T1-08 - Rishu Saxena & John Cosgrove
17mDataEngBytes 2023 - SYD-T1-05 - Patrick Cuba
32mDataEngBytes 2023 - BRI-T1-10 Rishu Saxena & John Cosgrove
28mDataEngBytes 2023 - PER-T1-04 - Nathan Glover
13mLightning Talk: Highlights of the Snowflake Elastic Data Warehouse
23mDelivering Retail Analytics & Data Projects With Data Created For Purpose
01h 17mData Engineering in the AI Era: Building a Robust Foundation for AI Applications
21mDataEngBytes 2023 - SYD-T2-02 - Vinny Vijekumaar & Zak Sheikh
