| domain | dumky.net |
| summary | This guide provides a solution for data transformation using SQL, drawing parallels to familiar Excel formulas. It addresses challenges like querying remote CSV files, managing schema changes across multiple files, unnesting nested data, and flattening JSON APIs. The author developed a custom dbt materialization to automatically deploy Streamlit applications directly on Snowflake, eliminating the need to integrate dbt transformations with separate visualization tools. |
| title | Beyond Measure |
| description | Hi! I'm Dumky, author of [The Fundamentals of Analytics Engineering](https://amzn.to/43KxIik). I write about mostly technical topics related to analytics and data. |
| keywords | data, engineering, files, testing, post, snowflake, quality, more, ingestion, model, transformations, unit, engineer, guide, shows, custom, governance |
| upstreams |
3quarksdaily.com |
| downstreams |
github.com, twitter.com, linkedin.com, buymeacoffee.com |
| nslookup | A 104.21.91.23, A 172.67.208.216 |
| created | 2024-10-13 |
| updated | 2026-02-01 |
| summarized | 2026-02-02 |
|
|