azdata app

Applies to: Azure Data CLI (azdata)

Note

Some scenarios previously handled by the Azure Data CLI (azdata) are now managed through Azure CLI (az) extensions and Azure Arc-based workflows. There is no single 1:1 replacement for all azdata commands. The following table highlights commonly related Azure CLI alternatives where they exist.

azdata command area	Azure CLI extension / command group	Azure CLI reference
azdata arc dc *	az arcdata	Azure Arc data CLI reference
azdata arc sql mi *	az arcdata sql mi	Manage Azure SQL Managed Instance with CLI
azdata arc postgres *	az arcdata postgres	Manage PostgreSQL server with CLI
azdata migrate *	az datamigration	Migrate using CLI
azdata extension *	az extension *	Azure CLI extensions overview
azdata login	az login	az login
azdata sql shell / azdata sql query	No Azure CLI equivalent (use sqlcmd, SSMS, or other SQL tools)	sqlcmd utility SQL Server Management Studio

For new automation and management scenarios, prefer Azure CLI (az), Azure CLI extensions, and Azure Arc portal experiences.

The following article provides reference for the sql commands in the azdata tool. For more information about other azdata commands, see azdata reference

Commands

Command	Description
azdata app template	Templates.
azdata app init	Kickstart new application skeleton.
azdata app create	Create application.
azdata app update	Update application.
azdata app list	List application(s).
azdata app delete	Delete application.
azdata app run	Run application.
azdata app describe	Describe application.

azdata app init

Helps you to kickstart new application skeleton and/or spec files based on runtime environments.

azdata app init [--spec -s] 
                [--name -n]  
                
[--version -v]  
                
[--template -t]  
                
[--destination -d]  
                
[--url -u]

Examples

Scaffold a new application spec.yaml only.

azdata app init --spec

Scaffold a new R application skeleton based on the r template.

azdata app init --name reduce --template r

Scaffold a new Python application skeleton based on the python template.

azdata app init --name reduce --template python

Scaffold a new SSIS application skeleton based on the ssis template.

azdata app init --name reduce --template ssis            

Optional Parameters

--spec -s

Generate just an application spec.yaml.

--name -n

Application name.

--version -v

Application version.

--template -t

Template name. For a full list off supported template names run azdata app template list

--destination -d

Where to place the application skeleton. Default: current working directory.

--url -u

Specify a different template repository location. Default: https://github.com/Microsoft/SQLBDC-AppDeploy.git

Global Arguments

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--output -o

Output format. Allowed values: json, jsonc, table, tsv. Default: json.

--query -q

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

--verbose

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

azdata app create

Create an application.

azdata app create --spec -s 
                  

Examples

Create a new application from a directory containing a valid spec.yaml deployment specification.

azdata app create --spec /path/to/dir/with/spec/yaml

Required Parameters

--spec -s

Path to a directory with a YAML spec file describing the application.

Global Arguments

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--output -o

Output format. Allowed values: json, jsonc, table, tsv. Default: json.

--query -q

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

--verbose

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

azdata app update

Update an application.

azdata app update [--spec -s] 
                  [--yes -y]

Examples

Update an existing application from a directory containing a valid spec.yaml deployment specification.

azdata app update --spec /path/to/dir/with/spec/yaml    

Optional Parameters

--spec -s

Path to a directory with a YAML spec file describing the application.

--yes -y

Do not prompt for confirmation when updating an application from the CWD's spec.yaml file.

Global Arguments

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--output -o

Output format. Allowed values: json, jsonc, table, tsv. Default: json.

--query -q

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

--verbose

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

azdata app list

List an application(s).,

azdata app list [--name -n] 
                [--version -v]

Examples

List application by name and version.

azdata app list --name reduce  --version v1

List all application versions by name.

azdata app list --name reduce

List all application versions by name.

azdata app list

Optional Parameters

--name -n

Application name.

--version -v

Application version.

Global Arguments

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--output -o

Output format. Allowed values: json, jsonc, table, tsv. Default: json.

--query -q

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

--verbose

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

azdata app delete

Delete an application.

azdata app delete --name -n 
                  --version -v

Examples

Delete application by name and version.

azdata app delete --name reduce --version v1    

Required Parameters

--name -n

Application name.

--version -v

Application version.

Global Arguments

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--output -o

Output format. Allowed values: json, jsonc, table, tsv. Default: json.

--query -q

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

--verbose

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

azdata app run

Run an application.

azdata app run --name -n 
               --version -v  
               
[--inputs]

Examples

Run application with no input parameters.

azdata app run --name reduce --version v1

Run application with 1 input parameter.

azdata app run --name reduce --version v1 --inputs x=10

Run application with multiple input parameters.

azdata app run --name reduce --version v1 --inputs x=10,y5.6    

Required Parameters

--name -n

Application name.

--version -v

Application version.

Optional Parameters

--inputs

Application input parameters in a CSV name=value format.

Global Arguments

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--output -o

Output format. Allowed values: json, jsonc, table, tsv. Default: json.

--query -q

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

--verbose

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

azdata app describe

Describe an application.

azdata app describe [--spec -s] 
                    [--name -n]  
                    
[--version -v]

Examples

Describe the application.

azdata app describe --name reduce --version v1    

Optional Parameters

--spec -s

Path to a directory with a YAML spec file describing the application.

--name -n

Application name.

--version -v

Application version.

Global Arguments

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--output -o

Output format. Allowed values: json, jsonc, table, tsv. Default: json.

--query -q

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

--verbose

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

Next steps

For more information about other azdata commands, see azdata reference.

For more information about how to install the azdata tool, see Install azdata.