PROCEDURES view (Account Usage and Information Schema): New columns (Pending)¶
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.
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