dbt-examples

Blog with Demo Instructions

• dbt Snowflake
• dbt Postgres
• dbt Materialize with Kafka
• dbt Materialize with Redpanda

Notes

Time sync issue fix

• See here to read more about this error

• To fix either manually set the time by running either of below commands

docker run --privileged --rm entechlog/dbt date -s "$(date -u "+%Y-%m-%d %H:%M:%S")"
docker run --privileged --rm entechlog/dbt date -s "$("2021-04-27 19:34:12")"

Airflow Integration

• Download and run Docker

• Download the Astro CLI

• cd into \docker\astro

• Start astro by running astro dev start

  Set environment setx DOCKER_BUILDKIT 0 to fix buildkit not supported by daemon Error

• Stop astro by running astro dev stop

  May need libicu-dev in packages.txt

References

https://www.astronomer.io/blog/airflow-dbt-1