Share via

SHOW PROCEDURES

Important

This feature is in Public Preview.

Applies to: check marked yes Databricks Runtime 17.0 and above

Returns the list of procedures after applying an optional regex pattern. You can use SHOW PROCEDURES in conjunction with describe procedure to quickly find a function and learn how to use it. The LIKE clause is optional, and ensures compatibility with other systems.

Syntax

SHOW PROCEDURES [ { FROM | IN } schema_name ]
    [ [ LIKE ] { procedure_name | regex_pattern } ]

Parameters

  • schema_name

    Specifies the schema in which procedures are to be listed.

  • procedure_name

    A name of an existing procedure in the system. If schema_name is not provided the procedure name may be qualified with a schema name instead. If procedure_name is not qualified and schema_name has not been specified the procedure is resolved from the current schema.

  • regex_pattern

    A regular expression pattern that is used to filter the results of the statement.

    • Except for * and | character, the pattern works like a regular expression.
    • * alone matches 0 or more characters and | is used to separate multiple different regular expressions, any of which can match.
    • The leading and trailing blanks are trimmed in the input pattern before processing. The pattern match is case-insensitive.

Returns

A result set with the following columns:

  • catalog STRING NOT NULL: The catalog name of the procedure.
  • namespace ARRAY[STRING] NOT NULL: The namespace of the procedure.
  • schema STRING NOT NULL: The schema name of the procedure.
  • procedure_name STRING NOT NULL: The name of the procedure.

In Databricks, schema and namespace hold the same information.

Examples

> SHOW PROCEDURES;
   main [default] default greeting

> SHOW PROCEDURES LIKE 'g*';
   main [default] default greeting