az horizondb

Note

This reference is part of the horizondb extension for the Azure CLI (version 2.17.1 or higher). The extension will automatically install the first time you run an az horizondb command. Learn more about extensions.

Manage Azure HorizonDB.

Commands

Name Description Type Status
az horizondb create

Create a new Azure HorizonDB cluster.

Extension GA
az horizondb delete

Delete an Azure HorizonDB cluster.

Extension GA
az horizondb firewall-rule

Manage firewall rules for an Azure HorizonDB cluster.

Extension GA
az horizondb firewall-rule create

Create a firewall rule for an Azure HorizonDB cluster.

Extension GA
az horizondb firewall-rule delete

Delete a firewall rule for an Azure HorizonDB cluster.

Extension GA
az horizondb firewall-rule list

List the firewall rules for an Azure HorizonDB cluster.

Extension GA
az horizondb firewall-rule show

Show the details of a firewall rule for an Azure HorizonDB cluster.

Extension GA
az horizondb firewall-rule update

Update a firewall rule for an Azure HorizonDB cluster.

Extension GA
az horizondb list

List Azure HorizonDB clusters.

Extension GA
az horizondb parameter-group

Manage Azure HorizonDB parameter groups.

Extension GA
az horizondb parameter-group create

Create a new Azure HorizonDB parameter group.

Extension GA
az horizondb parameter-group delete

Delete an Azure HorizonDB parameter group.

Extension GA
az horizondb parameter-group list

List Azure HorizonDB parameter groups.

Extension GA
az horizondb parameter-group list-connections

List Azure HorizonDB clusters connected to a parameter group.

Extension GA
az horizondb parameter-group show

Show details of an Azure HorizonDB parameter group.

Extension GA
az horizondb private-endpoint-connection

Manage HorizonDB private endpoint connections.

Extension GA
az horizondb private-endpoint-connection approve

Approve a HorizonDB private endpoint connection.

Extension GA
az horizondb private-endpoint-connection delete

Delete a HorizonDB private endpoint connection.

Extension GA
az horizondb private-endpoint-connection list

List private endpoint connections for a HorizonDB cluster.

Extension GA
az horizondb private-endpoint-connection reject

Reject a HorizonDB private endpoint connection.

Extension GA
az horizondb private-endpoint-connection show

Show details of a HorizonDB private endpoint connection.

Extension GA
az horizondb private-link-resource

Manage HorizonDB private link resources.

Extension GA
az horizondb private-link-resource list

List private link resources for a HorizonDB cluster.

Extension GA
az horizondb private-link-resource show

Show details of a HorizonDB private link resource.

Extension GA
az horizondb show

Show details of an Azure HorizonDB cluster.

Extension GA
az horizondb update

Update an existing Azure HorizonDB cluster.

Extension GA

az horizondb create

Create a new Azure HorizonDB cluster.

az horizondb create --administrator-login
                    --administrator-login-password
                    [--acquire-policy-token]
                    [--change-reference]
                    [--location]
                    [--name]
                    [--public-access]
                    [--replica-count]
                    [--resource-group]
                    [--tags]
                    [--v-cores]
                    [--version]
                    [--yes]
                    [--zone-placement-policy {BestEffort, Strict}]

Examples

Create a new HorizonDB cluster.

az horizondb create --name examplecluster --resource-group exampleresourcegroup --location centralus --administrator-login myadmin --administrator-login-password examplepassword --version 17 --v-cores 4 --replica-count 3

Create a HorizonDB cluster with zone placement policy.

az horizondb create --name examplecluster --resource-group exampleresourcegroup --location centralus --administrator-login myadmin --administrator-login-password examplepassword --version 17 --v-cores 4 --replica-count 3 --zone-placement-policy Strict

Create a HorizonDB cluster and allow public access from a single IP address (creates a firewall rule).

az horizondb create --name examplecluster --resource-group exampleresourcegroup --location centralus --administrator-login myadmin --administrator-login-password examplepassword --version 17 --v-cores 4 --public-access 12.12.12.12

Create a HorizonDB cluster and allow public access from a range of IP addresses.

az horizondb create --name examplecluster --resource-group exampleresourcegroup --location centralus --administrator-login myadmin --administrator-login-password examplepassword --version 17 --v-cores 4 --public-access 12.12.12.0-12.12.12.255

Create a HorizonDB cluster and allow public access from all IP addresses.

az horizondb create --name examplecluster --resource-group exampleresourcegroup --location centralus --administrator-login myadmin --administrator-login-password examplepassword --version 17 --v-cores 4 --public-access All

Required Parameters

--administrator-login -u

The administrator login name for the cluster.

--administrator-login-password -p

The administrator login password.

Optional Parameters

The following parameters are optional, but depending on the context, one or more might become required for the command to execute successfully.

--acquire-policy-token

Acquiring an Azure Policy token automatically for this resource operation.

Property Value
Parameter group: Global Policy Arguments
--change-reference

The related change reference ID for this resource operation.

Property Value
Parameter group: Global Policy Arguments
--location -l

Location. Values from: az account list-locations. You can configure the default location using az configure --defaults location=<location>.

--name -n

Name of the cluster. The name can contain only lowercase letters, numbers, and the hyphen (-) character. Minimum 3 characters and maximum 63 characters.

--public-access

Determines the public access for the cluster by creating a firewall rule on the default pool. Enter a single IP address or a range of IP addresses (dash-separated, no spaces) to be included in the allowed list of IPs. Specifying 'All' allows public access from any IP (0.0.0.0-255.255.255.255). 'Enabled' detects your current client IP and prompts to allow it. 'None' and 'Disabled' do not create a firewall rule. Acceptable values: 'Enabled', 'Disabled', 'All', 'None', '{startIP}' and '{startIP}-{endIP}' where each IP ranges from 0.0.0.0 to 255.255.255.255.

--replica-count -r

Number of replicas. Must be between 1 and 16, inclusive.

--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=<name>.

--tags

Space-separated tags: key[=value] [key[=value] ...]. Use "" to clear existing tags.

--v-cores

Number of vCores.

--version -v

Specifies the PostgreSQL major version.

--yes -y

Do not prompt for confirmation.

Property Value
Default value: False
--zone-placement-policy -z

Defines how replicas are placed across availability zones.

Property Value
Accepted values: BestEffort, Strict
Global Parameters
--debug

Increase logging verbosity to show all debug logs.

Property Value
Default value: False
--help -h

Show this help message and exit.

--only-show-errors

Only show errors, suppressing warnings.

Property Value
Default value: False
--output -o

Output format.

Property Value
Default value: json
Accepted values: json, jsonc, none, table, tsv, yaml, yamlc
--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.

Property Value
Default value: False

az horizondb delete

Delete an Azure HorizonDB cluster.

az horizondb delete [--acquire-policy-token]
                    [--change-reference]
                    [--ids]
                    [--name]
                    [--resource-group]
                    [--subscription]
                    [--yes]

Examples

Delete an Azure HorizonDB cluster.

az horizondb delete --name examplecluster --resource-group exampleresourcegroup

Optional Parameters

The following parameters are optional, but depending on the context, one or more might become required for the command to execute successfully.

--acquire-policy-token

Acquiring an Azure Policy token automatically for this resource operation.

Property Value
Parameter group: Global Policy Arguments
--change-reference

The related change reference ID for this resource operation.

Property Value
Parameter group: Global Policy Arguments
--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.

Property Value
Parameter group: Resource Id Arguments
--name -n

Name of the cluster. The name can contain only lowercase letters, numbers, and the hyphen (-) character. Minimum 3 characters and maximum 63 characters.

Property Value
Parameter group: Resource Id Arguments
--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=<name>.

Property Value
Parameter group: Resource Id Arguments
--subscription

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

Property Value
Parameter group: Resource Id Arguments
--yes -y

Do not prompt for confirmation.

Property Value
Default value: False
Global Parameters
--debug

Increase logging verbosity to show all debug logs.

Property Value
Default value: False
--help -h

Show this help message and exit.

--only-show-errors

Only show errors, suppressing warnings.

Property Value
Default value: False
--output -o

Output format.

Property Value
Default value: json
Accepted values: json, jsonc, none, table, tsv, yaml, yamlc
--query

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

--verbose

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

Property Value
Default value: False

az horizondb list

List Azure HorizonDB clusters.

az horizondb list [--resource-group]

Examples

List all Azure HorizonDB clusters in the current subscription.

az horizondb list

List Azure HorizonDB clusters in a resource group.

az horizondb list --resource-group exampleresourcegroup

Optional Parameters

The following parameters are optional, but depending on the context, one or more might become required for the command to execute successfully.

--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=<name>.

Global Parameters
--debug

Increase logging verbosity to show all debug logs.

Property Value
Default value: False
--help -h

Show this help message and exit.

--only-show-errors

Only show errors, suppressing warnings.

Property Value
Default value: False
--output -o

Output format.

Property Value
Default value: json
Accepted values: json, jsonc, none, table, tsv, yaml, yamlc
--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.

Property Value
Default value: False

az horizondb show

Show details of an Azure HorizonDB cluster.

az horizondb show [--ids]
                  [--name]
                  [--resource-group]
                  [--subscription]

Examples

Show details of an Azure HorizonDB cluster.

az horizondb show --name examplecluster --resource-group exampleresourcegroup

Optional Parameters

The following parameters are optional, but depending on the context, one or more might become required for the command to execute successfully.

--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.

Property Value
Parameter group: Resource Id Arguments
--name -n

Name of the cluster. The name can contain only lowercase letters, numbers, and the hyphen (-) character. Minimum 3 characters and maximum 63 characters.

Property Value
Parameter group: Resource Id Arguments
--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=<name>.

Property Value
Parameter group: Resource Id Arguments
--subscription

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

Property Value
Parameter group: Resource Id Arguments
Global Parameters
--debug

Increase logging verbosity to show all debug logs.

Property Value
Default value: False
--help -h

Show this help message and exit.

--only-show-errors

Only show errors, suppressing warnings.

Property Value
Default value: False
--output -o

Output format.

Property Value
Default value: json
Accepted values: json, jsonc, none, table, tsv, yaml, yamlc
--query

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

--verbose

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

Property Value
Default value: False

az horizondb update

Update an existing Azure HorizonDB cluster.

az horizondb update [--acquire-policy-token]
                    [--administrator-login-password]
                    [--change-reference]
                    [--ids]
                    [--name]
                    [--no-wait]
                    [--parameter-group]
                    [--public-access {Disabled, Enabled}]
                    [--resource-group]
                    [--subscription]
                    [--tags]
                    [--v-cores]
                    [--yes]

Examples

Update an existing HorizonDB cluster to have 6 vCores.

az horizondb update --name examplecluster --resource-group exampleresourcegroup --v-cores 6

Assign a parameter group to an existing HorizonDB cluster.

az horizondb update --name examplecluster --resource-group exampleresourcegroup --parameter-group /subscriptions/{subscriptionId}/resourceGroups/{resourceGroup}/providers/Microsoft.HorizonDb/parameterGroups/{parameterGroup}

Enable public access on an existing HorizonDB cluster (detects your client IP and prompts to create a firewall rule).

az horizondb update --name examplecluster --resource-group exampleresourcegroup --public-access Enabled

Optional Parameters

The following parameters are optional, but depending on the context, one or more might become required for the command to execute successfully.

--acquire-policy-token

Acquiring an Azure Policy token automatically for this resource operation.

Property Value
Parameter group: Global Policy Arguments
--administrator-login-password -p

The administrator login password.

--change-reference

The related change reference ID for this resource operation.

Property Value
Parameter group: Global Policy Arguments
--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.

Property Value
Parameter group: Resource Id Arguments
--name -n

Name of the cluster. The name can contain only lowercase letters, numbers, and the hyphen (-) character. Minimum 3 characters and maximum 63 characters.

Property Value
Parameter group: Resource Id Arguments
--no-wait

Do not wait for the long-running operation to finish.

Property Value
Default value: False
--parameter-group

The resource identifier of the parameter group.

--public-access

Enable or disable public access on the cluster. 'Enabled' detects your current client IP and prompts to create a firewall rule on the default pool. 'Disabled' points you to the 'az horizondb firewall-rule' commands to remove public access.

Property Value
Accepted values: Disabled, Enabled
--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=<name>.

Property Value
Parameter group: Resource Id Arguments
--subscription

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

Property Value
Parameter group: Resource Id Arguments
--tags

Space-separated tags: key[=value] [key[=value] ...]. Use "" to clear existing tags.

--v-cores

Number of vCores.

--yes -y

Do not prompt for confirmation.

Property Value
Default value: False
Global Parameters
--debug

Increase logging verbosity to show all debug logs.

Property Value
Default value: False
--help -h

Show this help message and exit.

--only-show-errors

Only show errors, suppressing warnings.

Property Value
Default value: False
--output -o

Output format.

Property Value
Default value: json
Accepted values: json, jsonc, none, table, tsv, yaml, yamlc
--query

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

--verbose

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

Property Value
Default value: False