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.

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 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:

Terminal window
docker pull localstack/snowflake:2026.04.0
localstack start --stack snowflake

If 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

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:

FunctionNotes
DAYExtracts the day of month from a date or timestamp.
DAYOFMONTHExtracts the day of month from a date or timestamp.
DAYOFYEARExtracts the ordinal day of year from a date or timestamp, including leap-year handling.
QUARTERReturns the quarter number for a date or timestamp.
WEEKReturns the week number for a date or timestamp.
YEAROFWEEKReturns the year that the week belongs to for a date or timestamp.
TIMESTAMP_LTZ_FROM_PARTSNow 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.PROCEDURES using the metadata FDW mechanism. The view now returns user-created procedures with Snowflake-compatible columns such as ARGUMENT_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_COUNT and BYTES to INFORMATION_SCHEMA.TABLES, with NULL values for views to match Snowflake behavior.
  • Improved SHOW OBJECTS metadata by returning row and byte counts for tables, adding the is_interactive column, and supporting scoped filters such as SHOW 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 INTO queries.

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.


Harsh Mishra
Harsh Mishra
Engineer at LocalStack
Harsh Mishra is an Engineer at LocalStack and AWS Community Builder. Harsh has previously worked at HackerRank, Red Hat, and Quansight, and specialized in DevOps, Platform Engineering, and CI/CD pipelines.