Snowflake API for Python release notes for 2024¶

Behavior changes¶

• Removed the deep parameter from fetch() on TableResource objects. fetch() always returns detailed columns and constraints information of a TableResource.

• create_or_update() currently no longer works for Schema, Warehouse, Database, and ComputePool resources. create() does work for these resources.

• Creating tables using as_select no longer carries over information from any source tables used in the as_select query.

• The data_retention_time_in_days and max_data_extension_time_in_days properties of a table are inherited from schema or database settings when not explicitly set in a create_or_update statement that alters an existing table.

New features and updates¶

• Added support for the Cortex Search API endpoint.

• Added support for large results.

• Added support for long-running queries.

• Added the ServiceSpec helper function to infer the specification type from a provided string in Service resources.

• Updated to use the Snowflake API REST platform for all resources.

• pip install snowflake[ml] installs snowflake-ml-python v1.4.0.

Bug fixes¶

• Various bug fixes.

New features and updates¶

snowflake package updates:

• You can now run pip install snowflake[ml] to install the Snowpark ML library as an extra package dependency.

snowflake.core package updates:

• Task predecessors now return their fully qualified name.

• Added the __str__() and __repr_html__() methods to DAGRun to make it notebook compatible.

• Replaced “DAGs” with “task graphs” in the API reference documentation to better align with Snowflake documentation.

Bug fixes¶

snowflake.core package fixes:

• Fixed code generator and updated OpenAPI-spec driven models.

• Fixed Pydantic compatibility issues.

• Fixed a bug in the Task.error_integration property.

• Fixed a bug in the Task.config property when the REST property was missing.

New features and updates¶

• The >> and << operators of DAGTask now accept a function directly.

• DAGTask now uses the DAG’s warehouse by default.

• DAGTask accepts a new parameter session_parameters.

• Updated TaskContext:

  • The method get_predecessor_return_value now works for both long and short names of a DAGTask.

  • Added the methods get_current_task_short_name and get_task_graph_config_property.

• Added support for pydantic 2.x.

• Added support for Python 3.11.

Bug fixes¶

• Fixed a bug where DAGOperation.run() raised an exception if the DAG doesn’t have a schedule.

• Fixed a bug where deleting a DAG didn’t delete all of its sub-tasks.

• Fixed a bug that raised an error when a DAG’s config is set.