Skip to main content

connectors

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

Overview

Nameconnectors
TypeResource
Idazure.storage.connectors

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
creationTimestringSystem-generated creation time of the Storage Connector in ISO 8601 date-time format (YYYY-MM-DDTHH:mm:ssZ). Not a valid input parameter during creating.
dataSourceTypestringThe type of backing data source for this Storage Connector. Required. "Azure_DataShare" (Azure_DataShare)
descriptionstringArbitrary description of this Storage Connector. Max 250 characters.
locationstringThe geo-location where the resource lives. Required.
provisioningStatestringRepresents the provisioning state of the storage connector. Known values are: "Accepted", "Creating", "Succeeded", "Deleting", "Canceled", and "Failed". (Accepted, Creating, Succeeded, Deleting, Canceled, Failed)
sourceobjectInformation about how to communicate with and authenticate to the backing data store. Required.
statestringState - Active or Inactive. Whether or not the Storage Connector should start as active (default: Active) (While set to false on the Storage Connector, all data plane requests using this Storage Connector fail, and this Storage Connector is not billed if it would be otherwise. Known values are: "Active" and "Inactive". (Active, Inactive)
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
tagsobjectResource tags.
testConnectionbooleanTest connection to backing data source before creating the storage connector.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".
uniqueIdstringSystem-generated GUID identifier for the Storage Connector. Not a valid input parameter when creating.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, account_name, connector_name, subscription_idGet the specified Storage Connector.
list_by_storage_accountselectresource_group_name, account_name, subscription_idList all Storage Connectors in a Storage Account.
createinsertresource_group_name, account_name, connector_name, subscription_id, location, propertiesCreate a Storage Connector if it does not already exist; otherwise, error out. This API will not allow you to replace an already existing resource.
updateupdateresource_group_name, account_name, connector_name, subscription_idUpdate a Storage Connector.
deletedeleteresource_group_name, account_name, connector_name, subscription_idDelete a Storage Connector.
test_existing_connectionexecresource_group_name, account_name, connector_name, subscription_id, uniqueIdThis method is used to verify that the connection to the backing data store works. This API is designed to be used for monitoring and debugging purposes. From the caller’s perspective, this method does the following: Calls List on the backing data store, attempting to list up to one blob/object/etc. If the above succeeds, and if a blob/object/etc is found, calls Get on that object, attempting to download one byte.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
account_namestringThe name of the storage account within the specified resource group. Storage account names must be between 3 and 24 characters in length and use numbers and lower-case letters only. Required.
connector_namestringThe name of the Storage Connector. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring

SELECT examples

Get the specified Storage Connector.

SELECT
id,
name,
creationTime,
dataSourceType,
description,
location,
provisioningState,
source,
state,
systemData,
tags,
testConnection,
type,
uniqueId
FROM azure.storage.connectors
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND account_name = '{{ account_name }}' -- required
AND connector_name = '{{ connector_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create a Storage Connector if it does not already exist; otherwise, error out. This API will not allow you to replace an already existing resource.

INSERT INTO azure.storage.connectors (
tags,
location,
properties,
resource_group_name,
account_name,
connector_name,
subscription_id
)
SELECT
'{{ tags }}',
'{{ location }}' /* required */,
'{{ properties }}' /* required */,
'{{ resource_group_name }}',
'{{ account_name }}',
'{{ connector_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type
;

UPDATE examples

Update a Storage Connector.

UPDATE azure.storage.connectors
SET
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND account_name = '{{ account_name }}' --required
AND connector_name = '{{ connector_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type;

DELETE examples

Delete a Storage Connector.

DELETE FROM azure.storage.connectors
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND account_name = '{{ account_name }}' --required
AND connector_name = '{{ connector_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

This method is used to verify that the connection to the backing data store works. This API is designed to be used for monitoring and debugging purposes. From the caller’s perspective, this method does the following: Calls List on the backing data store, attempting to list up to one blob/object/etc. If the above succeeds, and if a blob/object/etc is found, calls Get on that object, attempting to download one byte.

EXEC azure.storage.connectors.test_existing_connection 
@resource_group_name='{{ resource_group_name }}' --required,
@account_name='{{ account_name }}' --required,
@connector_name='{{ connector_name }}' --required,
@subscription_id='{{ subscription_id }}' --required
@@json=
'{
"uniqueId": "{{ uniqueId }}"
}'
;