Running dbt workflows locally with LocalStack

dbt (Data Build Tool) helps data engineers manage data transformations using modular SQL and brings version control, testing, and documentation to their transformation logic. However, running dbt against production data warehouses like Snowflake can be slow, expensive, and risky. This session introduces a new way to develop and test dbt workflows locally using the Snowflake emulator in LocalStack. You'll learn how to set up a local dbt environment, configure dbt to connect to the Snowflake emulator, run and validate dbt models locally without using a real Snowflake account, and iterate quickly on transformations before pushing them to production. Through a hands-on factory app example, we’ll walk through how to use the Snowflake emulator to run dbt models on your laptop, helping you test logic, catch issues early, and reduce cloud costs.

Related Talks

Improving Networking in LocalStack

Connecting your applications to LocalStack has not always been easy. In this video, Simon from the LocalStack team discusses how we streamlined the LocalStack networking experience. We discussed the challenges of connecting your applications to LocalStack and how we're simplifying the LocalStack networking experience. Simon also discussed about configurations required for more complex networking setups, and some common networking scenarios, with example configuration for achieving connectivity.

Learn More
Learn More
How to use AWS SDKs with LocalStack

LocalStack integrates with official AWS Software Development Kits (SDKs) so you can connect to LocalStack services using the same application code you use for AWS services. This lets you develop and test your applications locally without connecting to the cloud. In this video, we will talk about how you can connect to LocalStack emulated services using AWS SDKs.

Learn More
Learn More
How to save state in LocalStack?

LocalStack is ephemeral, so when you stop and restart it, all data is lost. You can use certain features to save the state & load it back when you restart LocalStack. This includes saving the local state for S3 buckets, DynamoDB tables, RDS databases and more. In this video, we explore three mechanisms that allow you to save state in LocalStack: persistence, state export and import, and Cloud Pods.

Learn More
Learn More

Launch yourself in the world of local cloud development

Try for free
Try for free
Talk to Sales
Talk to Sales