| title | azdata bdc sql settings reference |
|---|---|
| titleSuffix | SQL Server Big Data Clusters |
| description | Reference article for azdata bdc sql settings commands. |
| author | MikeRayMSFT |
| ms.author | mikeray |
| ms.reviewer | seanw |
| ms.date | 10/05/2021 |
| ms.prod | sql |
| ms.technology | big-data-cluster |
| ms.topic | reference |
Applies to [!INCLUDE azure-data-cli-azdata]
The following article provides reference for the sql commands in the azdata tool. For more information about other azdata commands, see azdata reference
| Command | Description |
|---|---|
| azdata bdc sql settings set | Set sql service-scope settings. |
| azdata bdc sql settings show | Show sql service-scope settings and optionally sql settings for specified resources |
Provides the ability to set a service-scoped or resource-scoped setting. Specify the full name of the setting and the value. Does not apply the setting to the running BDC. Run apply to do so.
azdata bdc sql settings set [--resources -r]
[--settings -s]Enable SQL agent in the SQL Server Master instance.
azdata bdc sql settings set --settings mssql.sqlagent.enabled=true --resources masterSet the number of CPUs for SQL Server to 10 in the Data Pool.
azdata bdc sql settings set --settings mssql.numberOfCpus=10 --resources data-0 Sets the given setting(s) for the provided resource(s). Resources can be specified as a comma separated list.
Sets the configured value for the provided settings. Multiple settings can be set using a comma separated list.
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Output format. Allowed values: json, jsonc, table, tsv. Default: json.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Increase logging verbosity. Use --debug for full debug logs.
Shows the BDC's sql service-scope (optionally resource-scope) settings. By default, this command shows user-configured service-scope settings. Filters are available to show all settings (system-managed and configurable), configurable settings, or pending settings. To see a specific service-scope or resource-scope setting, you can provide the setting name. Use “recursive” to show settings for all resources as part of the service.
azdata bdc sql settings show [--resources -r]
[--settings -s]
[--filter-option -f]
[--recursive -rec]
[--include-details -i]
[--description -d]Show the user configured SQL service-scope settings.
azdata bdc sql settings showShow the max server memory SQL configuration in the Data Pool.
azdata bdc sql settings show --settings mssql.maxServerMemory --resources data-0Show the pending settings changes for the SQL service-scope and resource-scope settings.
azdata bdc sql settings show --filter-option=pending --recursiveShows the setting(s) information for the given resource(s). Resources can be specified as a comma separated list.
Shows information for the specified setting name(s).
Filter which cluster-scope settings are shown, rather than only 'User Configured' settings. Filters are available to show all settings (system-managed & user-configurable), all configurable settings, or pending settings.
userConfigured
Shows the setting information for the given scope (service or service-resource) and all lower-scoped components (resources).
Includes additional details for the settings chosen to be shown.
Includes a description of the setting.
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Output format. Allowed values: json, jsonc, table, tsv. Default: json.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Increase logging verbosity. Use --debug for full debug logs.
For more information about other azdata commands, see azdata reference.
For more information about how to install the azdata tool, see Install azdata.