SQL

• Unit Testing dbt Macros: A workaround for dbt's unit testing limitations Ever wished you could catch that broken SQL logic before it wrecks your dashboards? With dbt 1.8's new unit testing capabilities, you can finally sleep at night! However, support for testing macros is still limited. Let's explore how to test both models and macros with a workaround. Continue reading...
  dbt data-engineering data-quality SQL testing

  6 min read
• Create your own API from BigQuery data in minutes with SQL exports and Cloudflare Workers Want to have data from BigQuery publicly available? Create a simple API with BigQuery scheduled queries, JSON exports and a Cloudflare Worker to map the right URL to the right data. Continue reading...
  SQL BigQuery javascript

  4 min read