az dla catalog procedure

Command group 'dla' is in preview and under development. Reference and support levels: https://aka.ms/CLI_refstatus

Manage Data Lake Analytics catalog stored procedures.

Commands

Name Description Type Status
az dla catalog procedure list

Retrieves the list of procedures from the Data Lake Analytics catalog.

Core Preview
az dla catalog procedure show

Retrieves the specified procedure from the Data Lake Analytics catalog.

Core Preview

az dla catalog procedure list

Preview

Command group 'dla' is in preview and under development. Reference and support levels: https://aka.ms/CLI_refstatus

Retrieves the list of procedures from the Data Lake Analytics catalog.

az dla catalog procedure list --database-name
                              --schema-name
                              [--account]
                              [--count]
                              [--filter]
                              [--ids]
                              [--orderby]
                              [--select]
                              [--skip]
                              [--subscription]
                              [--top]

Required Parameters

--database-name

The name of the database containing the procedures.

--schema-name

The name of the schema containing the procedures.

Optional Parameters

--account -n

Name of the Data Lake Analytics account.

--count

The Boolean value of true or false to request a count of the matching resources included with the resources in the response, e.g. Categories?$count=true.

--filter

OData filter. Optional.

--ids

One or more resource IDs (space-delimited). It should be a complete resource ID containing all information of 'Resource Id' arguments. You should provide either --ids or other 'Resource Id' arguments.

--orderby

OrderBy clause. One or more comma-separated expressions with an optional "asc" (the default) or "desc" depending on the order you'd like the values sorted, e.g. Categories?$orderby=CategoryName desc. Optional.

--select

OData Select statement. Limits the properties on each entry to just those requested, e.g. Categories?$select=CategoryName,Description. Optional.

--skip

The number of items to skip over before returning elements.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

--top

Maximum number of items to return.

Global Parameters
--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Only show errors, suppressing warnings.

--output -o

Output format.

accepted values: json, jsonc, none, table, tsv, yaml, yamlc
default value: json
--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az dla catalog procedure show

Preview

Command group 'dla' is in preview and under development. Reference and support levels: https://aka.ms/CLI_refstatus

Retrieves the specified procedure from the Data Lake Analytics catalog.

az dla catalog procedure show --database-name
                              --procedure-name
                              --schema-name
                              [--account]
                              [--ids]
                              [--subscription]

Required Parameters

--database-name

The name of the database containing the procedure.

--procedure-name

The name of the procedure.

--schema-name

The name of the schema containing the procedure.

Optional Parameters

--account -n

Name of the Data Lake Analytics account.

--ids

One or more resource IDs (space-delimited). It should be a complete resource ID containing all information of 'Resource Id' arguments. You should provide either --ids or other 'Resource Id' arguments.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

Global Parameters
--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Only show errors, suppressing warnings.

--output -o

Output format.

accepted values: json, jsonc, none, table, tsv, yaml, yamlc
default value: json
--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.