PROCEDURES view (Account Usage and Information Schema): New columns¶

Attention

This behavior change is in the 2025_01 bundle.

For the current status of the bundle, refer to Bundle History.

When this behavior change bundle is enabled, the output of the following views includes new columns:

The Account Usage PROCEDURES view output includes the following new column:

Column name Data type Description
INSTALLED_PACKAGES STRING Lists all packages installed by the procedure. Output for Python procedures only.

Column name	Data type	Description
INSTALLED_PACKAGES	STRING	Lists all packages installed by the procedure. Output for Python procedures only.

The Information Schema PROCEDURES view output includes the following new columns:

Column name	Data type	Description
PACKAGES	STRING	Specifies the packages requested by the procedure.
RUNTIME_VERSION	STRING	Specifies the runtime version of the procedure. NULL if the function is SQL or JavaScript.
INSTALLED_PACKAGES	STRING	Lists all packages installed by the procedure. Output for Python procedures only.

Ref: 1786