Open source utils
We believe in sharing knowledge. Our dbt and Snowflake utilities are freely available on GitHub, for anyone who finds them useful.
View on GitHubdbt
Macros
dbt run monitoring
Logging
Track when a dbt run starts and finishes. Automatically logged in Snowflake so you can always look back at what ran and when. Essential for production environments.
GDPR data masking
Masking
Apply dynamic data masking to sensitive columns via dbt tags. One macro, and your personal data is automatically shielded from roles that shouldn't have access.
Date & time utilities
Timestamps
A complete set of macros for converting and cleaning date and time values in Snowflake. From raw timestamp strings to clean, consistent dates — including fixes for months and weekdays.
code generator
Generate Sources
Automatically generate sources.yml, staging models and dbt_project.yml configuration from your Snowflake database. No more manual boilerplate when onboarding new data sources.
code generator
Generate Date Dimension
Generate a complete date dimension for Snowflake with calendar and fiscal periods, week numbers and Dutch public holidays, including moveable holidays like Easter.
datatype standardisation
Uniform Datatypes
Automatically cast all columns of a source table to uniform Snowflake data types. Invalid values are converted to NULL via TRY_TO_* functions instead of throwing an error.
Snowflake
Stored Procedures
Anonymizer
Anonymise data directly in Snowflake via a stored procedure. Ideal for creating safe development and test environments without personal data leaving production.
Analyzer
Analyse the structure and content of your Snowflake tables with a single procedure call. Useful as a starting point when onboarding new data sources or tracking down data quality issues.
GDPR Profiler
Automatically scan a Snowflake schema for personal data via configurable regex rules. Combines column name and value detection with a confidence score and recommended action.
Snippets
Apps
Generate Sources
Local Streamlit app that generates dbt sources, staging models and project configuration from Snowflake — with graphical interface and direct write-to-file feature.
Analyze
Graphical frontend for the Analyzer stored procedures. Create point-in-time snapshots, register them and view column statistics with conditional formatting.
Timestamp Tester
Test timestamp strings directly in Snowflake to find the right format pattern. Supports ISO, European, US, compact and database-specific formats.
Views
Admin Views
A collection of SQL views for Snowflake platform administrators. The views read from SNOWFLAKE.ACCOUNT_USAGE and provide insight into costs, query behaviour and security events.
Getting started
Clone the repository, run setup.sql once as accountadmin in Snowflake, and the macros and procedures are ready for use in your dbt project.