Step-by-step guides for common data engineering tasks. Code included.
How to build a row access policy in Snowflake that filters rows by role, and apply it automatically through dbt with a single post-hook.
How to set up a GitHub Action that flags TODO and WORKAROUND comments on open PRs and creates a Jira ticket automatically when they merge.
Step-by-step guide to set up Snowpipe with S3 auto-ingest so every file landing in your bucket loads automatically into Snowflake.
Step-by-step guide to configure Snowflake to read Iceberg tables stored in S3 using AWS Glue as the catalog, without moving any data.
Read CSV and Excel files from S3, map column names to a common schema, and merge everything into one file. No transformation, just structure.
How to read an Excel file, clean the mess, and load it into Postgres. Two ingestion methods depending on how much data you have.
How to build a tag-driven masking framework in Snowflake so a single policy protects every sensitive column, deployed automatically through dbt.