Skip to content

Parity changelog

How the feature-parity map changed across releases — generated by diffing the parity tables between consecutive v* tags.

Current (latest-189b16c): 85 🟢 Real · 7 🔴 Not implemented.

No parity changes.

No parity changes.

No parity changes.

  • Session context functions: added 🟢
  • SELECT, CTE, window: added 🟢
  • QUALIFY: added 🟢
  • TRY_CAST: added 🟢
  • IFF / NVL / NVL2 / ZEROIFNULL: added 🟢
  • TO_DATE / TO_VARCHAR / TO_TIMESTAMP: added 🟢
  • DATEDIFF: added 🟢
  • DATEADD: added 🟢
  • GENERATOR / SEQ4: added 🟢
  • A date series, the way core’s silver builds one: added 🟢
  • DATEADD(month, …) is refused: added 🟢
  • LISTAGG / ARRAY_AGG: added 🟢
  • MERGE: added 🔴
  • Decimal keeps its scale: added 🟢
  • NULL is null, not a word: added 🟢
  • Unparseable SQL is refused: added 🟢
  • VARIANT columns: added 🟢
  • Colon path: added 🟢
  • Colon path with a cast: added 🟢
  • LATERAL FLATTEN over VARIANT: added 🟢
  • LATERAL FLATTEN over an array: added 🟢
  • ARRAY_GENERATE_RANGE: added 🟢
  • PARSE_JSON: added 🟢
  • OBJECT_CONSTRUCT: added 🔴
  • CREATE STAGE: added 🟢
  • LIST: added 🟢
  • CREATE FILE FORMAT: added 🟢
  • COPY INTO from an internal stage: added 🟢
  • COPY INTO with a named format: added 🟢
  • COPY INTO JSON: added 🟢
  • External stages are refused: added 🟢
  • An unsupported format option is refused: added 🟢
  • PUT: added 🔴
  • REMOVE: added 🔴
  • INFER_SCHEMA: added 🔴
  • SHOW TABLES: added 🟢
  • DESCRIBE TABLE: added 🟢
  • information_schema.columns: added 🟢
  • SHOW FUNCTIONS: added 🟢
  • CREATE SCHEMA: added 🟢
  • CLONE: added 🔴
  • GRANT / roles: added 🔴
  • CREATE TASK: added 🟢
  • Task graphs (AFTER): added 🟢
  • ALTER TASK RESUME / SUSPEND: added 🟢
  • SHOW TASKS: added 🟢
  • EXECUTE TASK: added 🟢
  • DROP TASK: added 🟢
  • USING CRON is refused: added 🟢
  • A task with neither SCHEDULE nor AFTER is refused: added 🟢
  • CREATE STREAM: added 🟢
  • Reading a stream: added 🟢
  • SYSTEM$STREAM_HAS_DATA: added 🟢
  • SHOW STREAMS: added 🟢
  • DROP STREAM: added 🟢
  • Stored procedures: added 🔴
  • CREATE / SHOW / SUSPEND: added 🟢
  • Any-password-accepted: removed
  • SQL warehouses: removed
  • Snowflake SQL compatibility: removed
  • Streams / Tasks: removed
  • Cortex: removed
  • Internal stage COPY INTO: removed
  • External cloud stages: removed
  • Iceberg REST list: removed
  • Horizon / Time Travel catalog: removed
  • snowflake-connector-python / gosnowflake: removed
  • dbt-snowflake warehouse run: removed
  • snowflake-target toggle: removed

No parity changes.

No parity changes.

  • PUT: 🔴 → 🟢
  • A prefix is refused: added 🟢
  • TASK_HISTORY: added 🟢
  • A manual task (no SCHEDULE, no AFTER): added 🟢
  • EXECUTE TASK on a manual task: added 🟢
  • A task with neither SCHEDULE nor AFTER is refused: removed
  • INFER_SCHEMA: 🔴 → 🟢
  • Snowflake scalar type names in DDL: added 🟢
  • INFER_SCHEMA composes (WHERE over the result): added 🟢
  • INFER_SCHEMA without FILE_FORMAT is refused: added 🟢
  • A manual task with a CTAS body: added 🟢
  • EXECUTE TASK runs the CTAS: added 🟢
  • The CTAS body actually ran: added 🟢
  • A task body loads from a stage: added 🟢
  • EXECUTE TASK runs the COPY INTO: added 🟢
  • The task’s COPY INTO actually loaded: added 🟢
  • A task body reads a stream: added 🟢
  • EXECUTE TASK runs the stream read: added 🟢
  • CREATE DBT PROJECT: added 🟢
  • SHOW DBT PROJECTS: added 🟢
  • EXECUTE DBT PROJECT: added 🟢
  • dbt really built the models: added 🟢
  • A dbt failure fails the QUERY: added 🟢
  • A dbt task with no warehouse is refused: added 🟢
  • A task body runs EXECUTE DBT PROJECT: added 🟢
  • EXECUTE TASK runs the dbt project: added 🟢
  • DROP DBT PROJECT: added 🟢
  • The task’s stream read actually inserted: added 🟢
  • A prefix loads every file under it: added 🟢
  • The prefix really loaded both parts: added 🟢
  • A prefix is refused: removed
  • An ENV_VARS key dbt would never see is refused: added 🟢
  • ENV_VARS reached the dbt process: added 🟢
  • GET: added 🟢
  • ENV_VARS on CREATE is refused, and says where it belongs: added 🟢
  • dbt’s run_results is in the stage, at the path it named: added 🟢

No parity changes.

No parity changes.

  • A three-part name in a schema this family does not use: added 🟢
  • Two-part and three-part name the same table: added 🟢
  • A qualified name inside a string literal is data: added 🟢