az synapse sql-script
Manage SQL scripts in a synapse workspace.
Commands
Name | Description | Type | Status |
---|---|---|---|
az synapse sql-script create |
Create or update a SQL script. |
Core | GA |
az synapse sql-script delete |
Delete a SQL script. |
Core | GA |
az synapse sql-script export |
Export a SQL script. |
Core | GA |
az synapse sql-script import |
Import a SQL script. |
Core | GA |
az synapse sql-script list |
List SQL scripts in a synapse workspace. |
Core | GA |
az synapse sql-script show |
Get a SQL script. |
Core | GA |
az synapse sql-script wait |
Place the CLI in a waiting state until a condition of a sql script is met. |
Core | GA |
az synapse sql-script create
Create or update a SQL script.
az synapse sql-script create --file
--name
--workspace-name
[--additional-properties]
[--description]
[--folder-name]
[--no-wait]
[--result-limit {-1, 5000}]
[--sql-database-name]
[--sql-pool-name]
Examples
Create a SQL script.
az synapse sql-script create --workspace-name testsynapseworkspace \
--name testsqlscriptname \
--file 'path/test.sql'
Required Parameters
The SQL query file path.
The SQL script name.
The workspace name.
Optional Parameters
The following parameters are optional, but depending on the context, one or more might become required for the command to execute successfully.
The SQL script additional properties.
The SQL script description.
The folder that this SQL script is in. If not specified, this SQL script will appear at the root level. Eg: folder/subfolder1.
Do not wait for the long-running operation to finish.
Property | Value |
---|---|
Default value: | False |
The SQL query results limit. Default is 5000. '-1' is no limit.
Property | Value |
---|---|
Default value: | 5000 |
Accepted values: | -1, 5000 |
The SQL database name.
The SQL pool name.
Global Parameters
Increase logging verbosity to show all debug logs.
Property | Value |
---|---|
Default value: | False |
Show this help message and exit.
Only show errors, suppressing warnings.
Property | Value |
---|---|
Default value: | False |
Output format.
Property | Value |
---|---|
Default value: | json |
Accepted values: | json, jsonc, none, table, tsv, yaml, yamlc |
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
Property | Value |
---|---|
Default value: | False |
az synapse sql-script delete
Delete a SQL script.
az synapse sql-script delete --name
--workspace-name
[--no-wait]
Examples
Delete a SQL script.
az synapse sql-script delete --workspace-name testsynapseworkspace \
--name testsqlscriptname
Required Parameters
The SQL script name.
The workspace name.
Optional Parameters
The following parameters are optional, but depending on the context, one or more might become required for the command to execute successfully.
Do not wait for the long-running operation to finish.
Property | Value |
---|---|
Default value: | False |
Global Parameters
Increase logging verbosity to show all debug logs.
Property | Value |
---|---|
Default value: | False |
Show this help message and exit.
Only show errors, suppressing warnings.
Property | Value |
---|---|
Default value: | False |
Output format.
Property | Value |
---|---|
Default value: | json |
Accepted values: | json, jsonc, none, table, tsv, yaml, yamlc |
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
Property | Value |
---|---|
Default value: | False |
az synapse sql-script export
Export a SQL script.
az synapse sql-script export --output-folder
--workspace-name
[--name]
Examples
Export a SQL script.
az synapse sql-script export --workspace-name testsynapseworkspace \
--name testsqlscriptname \
--output-folder 'path/folder'
Required Parameters
The SQL script export path.
The workspace name.
Optional Parameters
The following parameters are optional, but depending on the context, one or more might become required for the command to execute successfully.
The SQL script name.
Global Parameters
Increase logging verbosity to show all debug logs.
Property | Value |
---|---|
Default value: | False |
Show this help message and exit.
Only show errors, suppressing warnings.
Property | Value |
---|---|
Default value: | False |
Output format.
Property | Value |
---|---|
Default value: | json |
Accepted values: | json, jsonc, none, table, tsv, yaml, yamlc |
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
Property | Value |
---|---|
Default value: | False |
az synapse sql-script import
Import a SQL script.
az synapse sql-script import --file
--name
--workspace-name
[--additional-properties]
[--description]
[--folder-name]
[--no-wait]
[--result-limit {-1, 5000}]
[--sql-database-name]
[--sql-pool-name]
Examples
Import a SQL script.
az synapse sql-script import --workspace-name testsynapseworkspace \
--name testsqlscriptname \
--file 'path/test.sql'
Required Parameters
The SQL query file path.
The SQL script name.
The workspace name.
Optional Parameters
The following parameters are optional, but depending on the context, one or more might become required for the command to execute successfully.
The SQL script additional properties.
The SQL script description.
The folder that this SQL script is in. If not specified, this SQL script will appear at the root level. Eg: folder/subfolder1.
Do not wait for the long-running operation to finish.
Property | Value |
---|---|
Default value: | False |
The SQL query results limit. Default is 5000. '-1' is no limit.
Property | Value |
---|---|
Default value: | 5000 |
Accepted values: | -1, 5000 |
The SQL database name.
The SQL pool name.
Global Parameters
Increase logging verbosity to show all debug logs.
Property | Value |
---|---|
Default value: | False |
Show this help message and exit.
Only show errors, suppressing warnings.
Property | Value |
---|---|
Default value: | False |
Output format.
Property | Value |
---|---|
Default value: | json |
Accepted values: | json, jsonc, none, table, tsv, yaml, yamlc |
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
Property | Value |
---|---|
Default value: | False |
az synapse sql-script list
List SQL scripts in a synapse workspace.
az synapse sql-script list --workspace-name
Examples
List SQL scripts.
az synapse sql-script list --workspace-name testsynapseworkspace
Required Parameters
The workspace name.
Global Parameters
Increase logging verbosity to show all debug logs.
Property | Value |
---|---|
Default value: | False |
Show this help message and exit.
Only show errors, suppressing warnings.
Property | Value |
---|---|
Default value: | False |
Output format.
Property | Value |
---|---|
Default value: | json |
Accepted values: | json, jsonc, none, table, tsv, yaml, yamlc |
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
Property | Value |
---|---|
Default value: | False |
az synapse sql-script show
Get a SQL script.
az synapse sql-script show --name
--workspace-name
Examples
Get a SQL script.
az synapse sql-script show --workspace-name testsynapseworkspace \
--name testsqlscriptname
Required Parameters
The SQL script name.
The workspace name.
Global Parameters
Increase logging verbosity to show all debug logs.
Property | Value |
---|---|
Default value: | False |
Show this help message and exit.
Only show errors, suppressing warnings.
Property | Value |
---|---|
Default value: | False |
Output format.
Property | Value |
---|---|
Default value: | json |
Accepted values: | json, jsonc, none, table, tsv, yaml, yamlc |
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
Property | Value |
---|---|
Default value: | False |
az synapse sql-script wait
Place the CLI in a waiting state until a condition of a sql script is met.
az synapse sql-script wait --name
--workspace-name
[--created]
[--custom]
[--deleted]
[--exists]
[--interval]
[--timeout]
[--updated]
Required Parameters
The SQL script name.
The workspace name.
Optional Parameters
The following parameters are optional, but depending on the context, one or more might become required for the command to execute successfully.
Wait until created with 'provisioningState' at 'Succeeded'.
Property | Value |
---|---|
Parameter group: | Wait Condition Arguments |
Default value: | False |
Wait until the condition satisfies a custom JMESPath query. E.g. provisioningState!='InProgress', instanceView.statuses[?code=='PowerState/running'].
Property | Value |
---|---|
Parameter group: | Wait Condition Arguments |
Wait until deleted.
Property | Value |
---|---|
Parameter group: | Wait Condition Arguments |
Default value: | False |
Wait until the resource exists.
Property | Value |
---|---|
Parameter group: | Wait Condition Arguments |
Default value: | False |
Polling interval in seconds.
Property | Value |
---|---|
Parameter group: | Wait Condition Arguments |
Default value: | 30 |
Maximum wait in seconds.
Property | Value |
---|---|
Parameter group: | Wait Condition Arguments |
Default value: | 3600 |
Wait until updated with provisioningState at 'Succeeded'.
Property | Value |
---|---|
Parameter group: | Wait Condition Arguments |
Default value: | False |
Global Parameters
Increase logging verbosity to show all debug logs.
Property | Value |
---|---|
Default value: | False |
Show this help message and exit.
Only show errors, suppressing warnings.
Property | Value |
---|---|
Default value: | False |
Output format.
Property | Value |
---|---|
Default value: | json |
Accepted values: | json, jsonc, none, table, tsv, yaml, yamlc |
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
Property | Value |
---|---|
Default value: | False |