Overview
LocalStack for Snowflake provides a local, Snowflake-compatible emulator that runs within a single container on your local machine or CI environment. It lets you develop and test Snowflake data pipelines, SQL, and integrations without a real Snowflake account or consuming Snowflake credits. See the Feature Coverage and SQL Functions pages for what’s supported.
Core Use Cases
Section titled “Core Use Cases”- Accelerate data pipeline development: Run dbt, Airflow, and Snowpark pipelines against a local Snowflake-compatible endpoint instead of waiting on cloud credits or shared environments.
- Automate integration testing: Run SQL and data pipeline tests in CI against a local emulator, without touching a real Snowflake account.
- Validate SQL compatibility: Check queries, UDFs, and stored procedures against LocalStack’s Snowflake SQL support before deploying to production.
- Experimental sandbox: Prototype Snowflake features such as Streams, Tasks, or storage integrations in a risk-free, local environment.
LocalStack for Snowflake also supports state management for persisting data across restarts, and init hooks for bootstrapping schemas and data on startup.
Start with the basics
Section titled “Start with the basics”Installation
Install LocalStack for Snowflake with lstk, Docker, or Docker Compose.
Local Development
New to LocalStack for Snowflake? Start here to connect the Snowflake CLI and run your first query.
CI/CD
Run Snowflake integration tests against LocalStack in GitHub Actions, CircleCI, and other CI systems.
AI & Agent Workflows
Integrate LocalStack for Snowflake with AI coding assistants via MCP, or automate SQL workflows with the Snowflake CLI.
Auth Token
Configure the Auth Token required to activate LocalStack and access licensed features.
FAQ
Frequently asked questions about LocalStack for Snowflake.