Analytics Engineer Toolkit
Analytics engineers transform raw data into clean, well-modeled datasets that business teams can trust. The work involves writing SQL transformations, managing dbt models, validating pipeline outputs, and debugging data quality issues. These free, browser-based tools handle the supporting micro-tasks so you can focus on building reliable data models.
JSON Formatter & Validator
Pretty-print JSON from data warehouse API responses, dbt manifest files, and metadata catalog exports. The formatted view helps you understand complex nested structures in source system data.
RegExp Tester
Build regex patterns for SQL REGEXP_LIKE filters, dbt model naming conventions, and data validation rules. Test patterns against sample data before embedding them in transformations.
Code Diff Tool
Compare SQL model versions, dbt schema YAML changes, and transformation logic side by side. Essential during code review to ensure data model changes do not introduce regressions.
JSON to YAML Converter
Convert JSON to YAML for dbt schema.yml files, source definitions, and CI/CD pipeline configurations. Keeps your dbt project structure clean and consistent.
Timestamp Converter
Convert Unix epoch timestamps to readable dates when debugging time-based transformations, partitioning logic, and incremental model runs. Essential for understanding data warehouse scheduling.
Duplicate Line Remover
Clean up column lists, table names, and metric definitions. Remove duplicates from exported query results or data catalog entries before analysis or documentation.
Crontab Calculator
Validate cron expressions for dbt Cloud scheduled runs, Airflow DAGs, and data pipeline orchestration. Preview execution times to align transformation schedules with source data availability.
Base64 Encoder / Decoder
Decode Base64-encoded values from warehouse API tokens, CI/CD secrets, and data platform authentication. Inspect encoded metadata without writing a utility script.
Character Counter
Verify SQL column alias lengths, metric descriptions, and documentation strings against warehouse and catalog character limits.
MD5 / Hash Generator
Generate surrogate keys using hash functions — a common pattern in dimensional modeling. Test hash output to verify your MD5() or SHA2() SQL expressions produce the expected results.
URL Encoder / Decoder
Encode query parameters for data platform API calls or decode URLs from web analytics data. Prevents encoding issues when working with UTM parameters and referral data.
Code to Image
Turn SQL snippets into clean images for documentation, Confluence pages, and data team presentations. Better than pasting raw SQL into a slide deck.