Changelog
Changelog for the latest releases of the LocalStack for Snowflake
0.3.0
- Add support for multi-account setups
- Add initial support for Java UDFs
- Add initial support for native apps and
APPLICATION PACKAGEs
- Add support for row access policies
- Add support for AVRO file format
- Add support for
ALTER STAGE
andALTER STREAM
statements - Enhance
SHOW COLUMNS/SCHEMAS
feature parity - Add support for
EQUAL_NULL
and variant type check functions - Add support for
ARRAY_REVERSE
function - Add support for
DESCRIBE/SHOW SEQUENCES
- Enhance timestamp handling and timezone support
- Add support for metadata columns in JSON
- Add support for
INSERT OVERWRITE
queries - Support ZTSD compression
- Enhance
TO_CHAR
with date and number formatting - Support dropping multiple columns in single
ALTER
statement - Add support for TIMEZONE session parameter
- Make default user and password configurable
- Fix various timestamp and timezone-related issues
- Improve query performance by re-using PG connections per session
- Enhance parity for comparison of VARIANTs and JSON objects
- Enhance column aliasing for joins
- Fix type mapping for rowtype metadata to enhance compatibility with .NET clients
- Cast
INSERT INTO
arguments to target type - Add support for
REGEXP_SUBSTR
function - Prohibit Postgres specific data types
- Add
HEADER
andFIELD_OPTIONALLY_ENCLOSED_BY
support for COPY INTO - Support subquery in copy into location
- Support not equal operator
- Enhance parity for $N references in WHERE clauses
- Increase identifiers length to 255 char
- Improve JDBC driver compatibility
- Support LS alias to LIST files from stages
0.2.5
- Change storage integration to not be associated with DB/schema
- Add enhanced support for SHOW ROLES and USE ROLE
- Enhance parity for COUNT(..) with NULL values
- Add multiple statements support
- Fix staging issues with parsing
- Enhance logic for timestamp assignments in MERGE INTO queries
- Add proper passing of stage parameters and validations
- Add support for
SYSTEM$CLIENT_VERSION_INFO
/OBJECT_CONSTRUCT_KEEP_NULL
/TIMESTAMPADD
/DATEADD
/TIMEADD
functions - Fix timestamp_ltz comparison operators issue
- Fix INSERT result count type
- Show tables metadata/information for dynamic tables
- Include Snowflake emulator version in the logs
- Update web app layout
- Enhance parity for NUMBER/FIXED data types in JDBC results
- Add support for querying from
INFORMATION_SCHEMA.TABLES
- Fix Arrow encoding for large decimal numeric values
- Fix session for /api/v2/statements endpoint
- Improve file formats handling in COPY INTO
- Enhance parity for COPY INTO with multiple stage files
- Update metadata for integer
- Enhance parity around selecting NULL values for DATE columns
- Add initial support for materialized views
- Add format parameter for
TO_TIMESTAMP
function - Add support for async execution of multi-statement queries
- Add support for patterns in select from stages
- Allow table column projections for COPY INTO queries from stage files
- Add support for numeric operators with mixed/variant types
- Add initial support for
MAP
data type and util functions - Create
INFORMATION_SCHEMA.FUNCTIONS
table - Add support for querying metadata filename in select from stage statements
- Enhance parity for primary/foreign keys
- Add support for IF EXISTS clauses in ALTER COLUMN queries
- Add initial support for user-defined transaction management
0.2.4
- Support
POWER
/POW
/DIV0NULL
/IFNULL
functions - Add support for COPY INTO location
- Add initial support for table/database clones
- Establish parity with snowflake when csv imports
- Allow binding multiple values
- Fix database and schema names in copy into table
- Fix
executeUpdate
in JDBC - Support
ORDER
andNOORDER
from AUTOINCREMENT column def - Add initial logic and tests for replicating resources between accounts
- Convert empty csv values to null
- Add support and tests for
LATERAL
queries - Add initial support for EXECUTE IMMEDIATE
- Add initial support for tags
- Add identifier support to SELECT queries
- Fix inserting timestamp values correctly
- Fix timestamps in insert for current_timestamp
- Add support for init scripts
- Fix handling timestamp values on update
- Add support for
DESCRIBE STAG
- Add initial support for storage integrations
- Enhance parity of
TIMESTAMP_LTZ
- Create clone db using identifiers
- Add mock support for replication databases to fix TF issues
- Fix logic for setting session parameters
- Add support for some extended GRANT statements
- Support
ALTER SEQUENCE
- Support creating stages with storage integrations
- Terraform create database fixes
- Improve general error handling
- Add initial support for
SHOW GRANTS TO/OF
0.2.3
- Add initial support for
OBJECT_KEYS
/PARSE_IP
/DESCRIBE FUNCTION
functions - Add support for various functions including
DATE_TRUNC
,NVL2
,LEAST
,GREATEST
, and more - Enhance parity for creation/deletion of schemas with fully qualified names
- Enhance parity for inserting timestamps with subsecond precision
- Enhance parity for CTAS with nested subqueries
- Enhance parity for id placeholders in JDBC prepared statements
- Enhance parity for metadata queries and schema lookup
- Adjust
MIN_BY
/MAX_BY
aggregate functions - Properly extract db/schema parameters for JDBC connections
- Implement trigonometric and hyperbolic functions
- Add support for GET stage files
0.2.2
- Add initial support for hybrid tables and dynamic tables
- Add support for
OBJECT_CONSTRUCT_KEEP_NULL
/AS_DOUBLE
/AS_INTEGER
/AS_NUMBER
/AS_CHAR
- Add
/result
API endpoint to retrieve query results - Track original types in internal VARIANTs
- Enhance parity for
SHOW WAREHOUSES
queries - Support for
SHOW TASKS
- Enhance parsing of stage params
- Fix selection of columns when querying stage files
- Automatically adjust PG JIT support if LLVM libs are missing
- Enhance custom JSON parsing to allow escaped characters
- Enhance parity of
TIMESTAMP_LTZ
for Flyway compatibility
0.2.1
- Add initial support for Iceberg tables
- Add initial support for external volumes and Snowflake pipes
- Support
LIST
/REMOVE
queries for staged files - Support
SHOW PIPES
queries - Support
COPY GRANTS
inCREATE TABLE
queries - Add multiple new SQL functions
- Implement
RANK
/DENSE_RANK
- Implement various conversion functions
- Enhance logic for
TO_CHAR
- Support window queries with
QUALIFY
- Support
COUNT_IF
aggregate functions - Make
CREATE SERVER
queries idempotent - Fix compatibility issues
- Add MUI data-grid for results table in UI
- Add squashing of Docker image to reduce size
0.2.0
- Support various SQL functions (
BITAND
,FLATTEN
,RANDOM
, etc.) - Add Snowflake proxy request handler
- Add initial version of simple UI view
- Fix execution of CTAS queries with UNION selects
- Fix logic for PUT file uploads
- Support parsing incomplete JSON
- Enhance support for TABLESAMPLE queries
- Add initial support for temporary and transient tables
- Add Snowflake v2 SQL APIs
- Fix
describeOnly
INSERT
queries
0.1.26
- Support
CONVERT_TIMEZONE
,IFF
SQL functions - Implement
ALTER WAREHOUSE
as no-op - Implement time functions
- Enhance JDBC driver compatibility
- Fix Arrow encoding
- Support SQL queries from within JS UDFs
- Add various performance improvements
- Implement additional date functions
- Add support for loading data from public S3 buckets
0.1.25
- Enhance support for various SHOW queries
- Add initial persistence support for Snowflake store
- Enhance parity for timestamp types
- Fix SHOW PARAMETERS for Terraform compatibility
- Set up CI build for Docker image
0.1.24
- Enhance parity around user-defined PROCEDUREs
- Fix upper-casing for various functions
- Enhance support for UNIQUE column constraints
- Add initial support for cross-DB resource sharing
0.1.23
- Add initial simple scheduler to periodically run tasks
0.1.22
- Fix query transforms for
ADD COLUMN
queries - Fix wrapping of
VALUES
subquery in braces - Add initial CRUD support for
TASK
s - Support
DROP PRIMARY KEY
queries - Migrate use of
localstack.http
torolo
0.1.21
- Add support for consuming table stream records via DML statements
0.1.20
- Initial simple support for table streams
- Add support for
SHOW DATABASES
,SHOW VIEWS
- Enhance parity for Arrow results
- Fix various identifier and query issues
0.1.19
- Return
SELECT
results in arrow format for pandas compatibility - Add
add_months
function - Fix UDFs with raw expressions
- Upgrade to Postgres v15
- Various parity and performance improvements
0.1.18
- Add support for various array and aggregation functions
- Enhance
FILE FORMAT
operations - Fix
CTAS
queries - Support
INFER_SCHEMA(..)
for parquet files - Improve identifier handling
0.1.17
- Support creation/deletion of stages
- Add
IS_ARRAY
function - Remove
DuckDB
basedDB
engine - Refactor codebase to use
QueryProcessor
interface - Enhance column name handling
0.1.16
- Add support for
SHOW PROCEDURES
andSHOW IMPORTED KEYS
- Add basic support for session parameters
0.1.15
- Fix result type conversation for
GET_PATH(..)
util function
0.1.14
- Enhance parity around
SHOW
queries - Add more array util functions
- Fix
STRING_AGG
functionality
0.1.13
- Support
CURRENT_*
functions - Enhance
LISTAGG
for distinct values - Add test for
JS
UDFs with exports
0.1.12
- Cast params for
string_agg
/listagg
- Fix parity for upper/lowercase names
0.1.11
- Enhance parity for array aggregation functions
- Improve timestamp timezone handling
- Add case-sensitive identifier tracking
0.1.10
- Add query transforms for
CLUSTER BY
- Add
SF_S3_ENDPOINT
config - Various parity fixes
0.1.9
- Add support for
Python
UDFs - Enhance function creation parity
- Add analytics setup
0.1.8
- Add
SF_LOG
config for request/response trace logging
0.1.7
- Add initial support for
JavaScript
UDFs - Enhance DB/table creation responses
- Improve streaming logic
0.1.6
- Introduce session state for DB/schema retention
- Support async queries and
result_scan(..)
0.1.5
- Enhance
DESCRIBE TABLE
results - Support
MIN_BY
/MAX_BY
aggregate functions
0.1.4
- Add logic to parse and replace
DB
references in queries
0.1.3
- Add
DBEngine
abstraction - Add experimental support for
duckdb
- Enhance
JSON
query support
0.1.2
- Add CSV file ingestion from Snowflake stage to table
0.1.1
- Initial support for
Kafka
connector - Add
snowpipe
/streaming APIs
0.1.0
- Initial release of the extension