servers

Creates, updates, deletes, gets or lists a servers resource.

Overview

Name	servers
Type	Resource
Id	azure.analysis_services.servers

Fields

Name	Datatype	Description
id	string	An identifier that represents the Analysis Services resource.
name	string	The name of the Analysis Services resource.
location	string	Location of the Analysis Services resource.
properties	object	Properties of Analysis Services resource.
sku	object	Represents the SKU name and Azure pricing tier for Analysis Services resource.
tags	object	Key-value pairs of additional resource provisioning properties.
type	string	The type of the Analysis Services resource.

Methods

Name	Accessible by	Required Params	Description
list	SELECT	subscriptionId	Lists all the Analysis Services servers for the given subscription.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Gets all the Analysis Services servers for the given resource group.
create	INSERT	resourceGroupName, serverName, subscriptionId	Provisions the specified Analysis Services server based on the configuration specified in the request.
delete	DELETE	resourceGroupName, serverName, subscriptionId	Deletes the specified Analysis Services server.
update	UPDATE	resourceGroupName, serverName, subscriptionId	Updates the current state of the specified Analysis Services server.
check_name_availability	EXEC	location, subscriptionId	Check the name availability in the target location.
dissociate_gateway	EXEC	resourceGroupName, serverName, subscriptionId	Dissociates a Unified Gateway associated with the server.
resume	EXEC	resourceGroupName, serverName, subscriptionId	Resumes operation of the specified Analysis Services server instance.
suspend	EXEC	resourceGroupName, serverName, subscriptionId	Suspends operation of the specified Analysis Services server instance.

SELECT examples

Lists all the Analysis Services servers for the given subscription.

SELECT
id,
name,
location,
properties,
sku,
tags,
type
FROM azure.analysis_services.servers
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new servers resource.

All Properties

/*+ create */
INSERT INTO azure.analysis_services.servers (
resourceGroupName,
serverName,
subscriptionId,
properties,
location,
sku,
tags
)
SELECT 
'{{ resourceGroupName }}',
'{{ serverName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ location }}',
'{{ sku }}',
'{{ tags }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: state
          value: string
        - name: provisioningState
          value: string
        - name: serverFullName
          value: string
        - name: sku
          value:
            - name: name
              value: string
            - name: tier
              value: string
            - name: capacity
              value: integer
        - name: asAdministrators
          value:
            - name: members
              value:
                - string
        - name: backupBlobContainerUri
          value: string
        - name: gatewayDetails
          value:
            - name: gatewayResourceId
              value: string
            - name: gatewayObjectId
              value: string
            - name: dmtsClusterUri
              value: string
        - name: ipV4FirewallSettings
          value:
            - name: firewallRules
              value:
                - - name: firewallRuleName
                    value: string
                  - name: rangeStart
                    value: string
                  - name: rangeEnd
                    value: string
            - name: enablePowerBIService
              value: boolean
        - name: querypoolConnectionMode
          value: string
        - name: managedMode
          value: integer
        - name: serverMonitorMode
          value: integer
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: location
      value: string
    - name: tags
      value: object

UPDATE example

Updates a servers resource.

/*+ update */
UPDATE azure.analysis_services.servers
SET 
sku = '{{ sku }}',
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified servers resource.

/*+ delete */
DELETE FROM azure.analysis_services.servers
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';