Snowflake Now Ships as a Self-Contained Image
LocalStack for Snowflake now ships as its own standalone Docker image instead of loading as an add-on into the shared LocalStack Pro image at startup. This gives you a single image to pull, faster container startup, and fewer issues caused by version mismatches with the shared base image. No migration steps are required.
- Added support for
PERCENTILE_CONTandPERCENTILE_DISC, the standard percentile aggregate functions used for medians, quartiles, and other distribution cutoffs. MEDIANis now fixed to return correct results, since it shares its underlying implementation withPERCENTILE_CONT.UNPIVOTno longer crashes with an unhandledIndexErrorin certain query shapes.GREATESTandLEASTnow preserve the input type, and genericMIN/MAXresolution was fixed alongside them.ROUNDprecision derivation now accommodates an increased scale, fixing incorrect results for some decimal roundings.- Fixed handling of certain boolean comparison expressions that previously produced incorrect results.
CONVERT_TIMESTAMPnow handlesNULLinputs correctly instead of failing.DATEDIFFnow handles an unquoted date part argument used inside a window function ORDER BY.- Fixed a bug affecting character/string conversion.
QUALIFYcolumn resolution is fixed for queries that cross-join a CTE and reference a column via its CTE alias.- Table qualifiers added during alias expansion are now quoted correctly, fixing visibility issues with
UNION ALLover a CTE combined withQUALIFY. IS NULLnow evaluates correctly against a bareNULLvalue projected through a CTE or subquery.- Unaliased derived tables in a
JOINclause will no longer cause the query to fail. - Nested
QUALIFYrewrites no longer create an ambiguous internal column. - Parenthesized queries of the form
(WITH ... SELECT ...)are no longer incorrectly rejected. WITH RECURSIVEwill now enable recursive CTEs to be properly recognized and executed as recursive.- Scripting keywords used as implicit table aliases are no longer misinterpreted during table reference parsing.
- SQL procedure bodies using
DECLAREblocks, includingOBJECTandNUMBER-typed variables and bodies containingUPDATE ... RETURNING, no longer fail to create. CREATE TASKnow supports multi-statementBEGIN ... ENDbodies.DROP STAGE IF EXISTSno longer raises an error when the referenced stage does not exist.- Bumped
jackson-databindto2.18.8, addressing CVE-2026-54512 and CVE-2026-54513. - Bumped
dulwichandkclpy-extto patched versions, addressing three High-severity CVEs. - Bumped the bundled Apache NiFi (OpenFlow) component to version 2.10.0.
