Announcing the LocalStack for Snowflake 2026.04.0 Release
LocalStack for Snowflake 2026.04.0 adds support for Glue Iceberg REST catalog integrations, improves the Snowflake UI, expands date/time SQL function coverage, and delivers targeted metadata and Snowpipe parity improvements.
LocalStack for Snowflake 2026.04.0 adds support for Glue Iceberg REST catalog integrations, improves the Snowflake web app, expands date/time SQL function coverage, and delivers targeted metadata and Snowpipe parity improvements.
This release focuses on practical compatibility updates for local Snowflake workflows. Iceberg tables can now reference tables through the AWS Glue Iceberg REST endpoint, the web app can run multi-statement SQL and inspect query history more directly, and metadata views now return more Snowflake-compatible information for procedures, tables, and common introspection queries.
Get a free LocalStack trial to access the latest features in LocalStack for Snowflake 2026.04.0.
How to upgrade?
To upgrade to LocalStack for Snowflake 2026.04.0 using the LocalStack CLI, run:
docker pull localstack/snowflake:2026.04.0localstack start --stack snowflakeIf you’re using LocalStack for Snowflake with Docker CLI or Docker Compose, you can pin the image version in your docker run command or Docker Compose file to 2026.04.0.
What’s new in LocalStack for Snowflake 2026.04.0?
- Glue Iceberg REST catalog integration
- Web App UI improvements
- Support for new SQL date/time functions
- Improved parity with Snowflake
- Conclusion
Glue Iceberg REST catalog integration
The Snowflake emulator now supports catalog integrations that use the AWS Glue Iceberg REST endpoint. This enables local testing of Snowflake Iceberg tables backed by Glue and S3 Tables through the REST catalog flow.
CREATE CATALOG INTEGRATION now supports Glue-specific REST catalog options including CATALOG_API_TYPE = AWS_GLUE, WAREHOUSE, and REST_AUTHENTICATION with TYPE = AWS_SIGV4. The emulator configures the PyIceberg REST catalog with SigV4 signing and the configured warehouse identifier when connecting to Glue.
You can create a catalog integration that points to the Glue Iceberg REST endpoint and then create an Iceberg table that references an existing table in the remote catalog:
CREATE CATALOG INTEGRATION my_glue_catalog CATALOG_SOURCE = ICEBERG_REST TABLE_FORMAT = ICEBERG CATALOG_NAMESPACE = 'my_namespace' REST_CONFIG = ( CATALOG_URI = 'http://glue.localhost.localstack.cloud:4566/iceberg' CATALOG_API_TYPE = AWS_GLUE WAREHOUSE = ':s3tablescatalog/' ACCESS_DELEGATION_MODE = VENDED_CREDENTIALS ) REST_AUTHENTICATION = ( TYPE = AWS_SIGV4 AWS_ACCESS_KEY_ID = '' AWS_SECRET_ACCESS_KEY = 'test' AWS_REGION = 'us-east-1' AWS_SERVICE = 'glue' ) ENABLED = TRUE;
CREATE ICEBERG TABLE my_table CATALOG = 'my_glue_catalog' CATALOG_TABLE_NAME = 'my_namespace.my_remote_table' AUTO_REFRESH = TRUE;
SELECT * FROM my_table;Refer to the Glue Iceberg REST catalog integration documentation for more details.
Web App UI improvements
We’ve made several improvements to the web app for LocalStack for Snowflake:
- Multi-statement query support: The SQL worksheet now supports running multi-statement SQL from the editor, with progress shown while statements execute.
- Result and history layout: Query results and Query History are now displayed side-by-side. Query History rows can be selected to fetch and display previous query results.
- Result tabs: Query results are shown in tabs, with failed query results highlighted and query errors displayed inline.
- Truncated result notice: The result grid now shows an info banner when only the first 100 rows are displayed.
- Resource browser updates: Views are now displayed as a distinct resource type alongside tables, with dedicated icons for databases, schemas, tables, views, columns, and resource groups.
- SQL autocomplete improvements: The SQL editor now includes autocomplete for Snowflake keywords, built-in functions, and schema objects such as databases, tables, and columns.
- Date/time display fixes: DATE, TIME, and TIMESTAMP values are now formatted more clearly in result grids.
Refer to the Web App User Interface documentation for more details.
Support for new SQL date/time functions
We have added support for several new SQL date/time functions in LocalStack for Snowflake. The new functions include:
| Function | Notes |
|---|---|
| DAY | Extracts the day of month from a date or timestamp. |
| DAYOFMONTH | Extracts the day of month from a date or timestamp. |
| DAYOFYEAR | Extracts the ordinal day of year from a date or timestamp, including leap-year handling. |
| QUARTER | Returns the quarter number for a date or timestamp. |
| WEEK | Returns the week number for a date or timestamp. |
| YEAROFWEEK | Returns the year that the week belongs to for a date or timestamp. |
| TIMESTAMP_LTZ_FROM_PARTS | Now supports the six-argument form TIMESTAMP_LTZ_FROM_PARTS(year, month, day, hour, minute, second), with nanoseconds defaulting to 0. |
In addition, DATE_PART and EXTRACT now correctly handle unquoted date/time parts such as DATE_PART(year, date_col) and EXTRACT(year FROM date_col).
Improved parity with Snowflake
We have made several enhancements to LocalStack for Snowflake to improve compatibility with the Snowflake service. These include:
- Added support for
INFORMATION_SCHEMA.PROCEDURESusing the metadata FDW mechanism. The view now returns user-created procedures with Snowflake-compatible columns such asARGUMENT_SIGNATURE,DATA_TYPE,PROCEDURE_LANGUAGE,PROCEDURE_DEFINITION, precision fields, timestamps, and package-related metadata columns. - Improved routine tracking for user-defined functions and procedures so that metadata queries can distinguish procedures from functions, handle overloaded routines, and track procedures created through
IDENTIFIER($var). - Added
ROW_COUNTandBYTEStoINFORMATION_SCHEMA.TABLES, withNULLvalues for views to match Snowflake behavior. - Improved
SHOW OBJECTSmetadata by returning row and byte counts for tables, adding theis_interactivecolumn, and supporting scoped filters such asSHOW OBJECTS IN <database>.<schema> STARTS WITH '<prefix>' LIMIT <n>. - Improved Snowpipe notification processing for setups with many pipes or stages pointing to the same S3 bucket. The emulator now precomputes pipe routes per SQS batch and filters object notifications by bucket and pipe path before building
COPY INTOqueries.
Conclusion
LocalStack for Snowflake 2026.04.0 continues to focus on high-signal compatibility improvements for local Snowflake development. Glue Iceberg REST catalog support expands Iceberg workflows, the web app improvements make local query execution easier to inspect, and the metadata and Snowpipe updates close gaps that affect real clients, tools, and pipelines.
Sign up for a free trial or upgrade to LocalStack for Snowflake 2026.04.0 to use these improvements in your local development environment.