access_connectors

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

Overview

Name	access_connectors
Type	Resource
Id	azure_isv.databricks.access_connectors

Fields

vw_access_connectors

Name	Datatype	Description
connectorName	text	field from the properties object
identity	text	Managed service identity (system assigned and/or user assigned identities)
location	text	The geo-location where the resource lives
provisioning_state	text	field from the properties object
refered_by	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
tags	text	Resource tags.

access_connectors

Name	Datatype	Description
identity	object	Managed service identity (system assigned and/or user assigned identities)
location	string	The geo-location where the resource lives
properties	object
systemData	object	Metadata pertaining to creation and last modification of the resource.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	connectorName, resourceGroupName, subscriptionId	Gets an Azure Databricks Access Connector.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Gets all the Azure Databricks Access Connectors within a resource group.
list_by_subscription	SELECT	subscriptionId	Gets all the Azure Databricks Access Connectors within a subscription.
create_or_update	INSERT	connectorName, resourceGroupName, subscriptionId	Creates or updates Azure Databricks Access Connector.
delete	DELETE	connectorName, resourceGroupName, subscriptionId	Deletes the Azure Databricks Access Connector.
update	UPDATE	connectorName, resourceGroupName, subscriptionId	Updates an Azure Databricks Access Connector.

SELECT examples

Gets all the Azure Databricks Access Connectors within a subscription.

vw_access_connectors

SELECT
connectorName,
identity,
location,
provisioning_state,
refered_by,
resourceGroupName,
subscriptionId,
system_data,
tags
FROM azure_isv.databricks.vw_access_connectors
WHERE subscriptionId = '{{ subscriptionId }}';

access_connectors

SELECT
identity,
location,
properties,
systemData,
tags
FROM azure_isv.databricks.access_connectors
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_isv.databricks.access_connectors (
connectorName,
resourceGroupName,
subscriptionId,
identity,
systemData,
properties,
tags,
location
)
SELECT 
'{{ connectorName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ identity }}',
'{{ systemData }}',
'{{ properties }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: identity
      value:
        - name: principalId
          value: string
        - name: tenantId
          value: string
        - name: type
          value: []
        - name: userAssignedIdentities
          value: []
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string
    - name: properties
      value:
        - name: provisioningState
          value: string
        - name: referedBy
          value:
            - string
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a access_connectors resource.

/*+ update */
UPDATE azure_isv.databricks.access_connectors
SET 
tags = '{{ tags }}',
identity = '{{ identity }}'
WHERE 
connectorName = '{{ connectorName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified access_connectors resource.

/*+ delete */
DELETE FROM azure_isv.databricks.access_connectors
WHERE connectorName = '{{ connectorName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';