Welcome to LocalStack for Snowflake Docs

LocalStack is a cloud service emulator that runs in a single container on your laptop or in your CI environment. LocalStack for Snowflake emulates the functionality of a real Snowflake instance, allowing you to perform operations without an internet connection or a Snowflake account. This is valuable for locally developing and testing Snowflake data pipelines without incurring costs.

The Snowflake emulator supports the following features:

• DDL/DML/DQL operations on warehouses, databases, schemas, and tables
• Basic operations for warehouse, database, schema, and table management
• Transaction management with full ACID compliance support
• Cross-database resource sharing for collaborative data access
• Storing files in Snowflake stages (user, data, and named stages)
• Storage integrations for external cloud storage connectivity
• Zero-copy cloning for efficient data duplication
• Materialized views for pre-computed query results
• Iceberg tables for open table format support
• Hybrid tables combining row and column storage
• Dynamic tables for automatically refreshed derived data
• Snowpark libraries for DataFrame-based data processing
• User-defined functions (UDFs) in JavaScript, Python, and Java
• Snowpipe for continuous data ingestion
• Table streams for change data capture (CDC) and audit logs
• Tasks for scheduled execution and workflow automation
• Row Access Policies for fine-grained data access control
• Running Streamlit apps locally for interactive data apps with Native Apps support
• Infrastructure-as-code with Terraform & Pulumi for automated resource provisioning
• Polaris Catalog integration for open catalog management

Integrating the Snowflake emulator into your existing CI/CD pipeline allows you to run integration tests and identify issues early, reducing surprises during production deployment.

Check our SQL Functions Coverage and Feature Coverage pages for a comprehensive list of supported features.