time_series_database_connections

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

Overview

Name	time_series_database_connections
Type	Resource
Id	azure.digital_twins.time_series_database_connections

Fields

vw_time_series_database_connections

Name	Datatype	Description
id	text	The resource identifier.
name	text	Extension resource name.
connection_type	text	field from the properties object
identity	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
resourceName	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
timeSeriesDatabaseConnectionName	text	field from the properties object
type	text	The resource type.

time_series_database_connections

Name	Datatype	Description
id	string	The resource identifier.
name	string	Extension resource name.
properties	object	Properties of a time series database connection resource.
systemData	object	Metadata pertaining to creation and last modification of the resource.
type	string	The resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, resourceName, subscriptionId, timeSeriesDatabaseConnectionName	Get the description of an existing time series database connection.
list	SELECT	resourceGroupName, resourceName, subscriptionId	Get all existing time series database connections for this DigitalTwins instance.
create_or_update	INSERT	resourceGroupName, resourceName, subscriptionId, timeSeriesDatabaseConnectionName	Create or update a time series database connection.
delete	DELETE	resourceGroupName, resourceName, subscriptionId, timeSeriesDatabaseConnectionName	Delete a time series database connection.

SELECT examples

Get all existing time series database connections for this DigitalTwins instance.

vw_time_series_database_connections

SELECT
id,
name,
connection_type,
identity,
provisioning_state,
resourceGroupName,
resourceName,
subscriptionId,
system_data,
timeSeriesDatabaseConnectionName,
type
FROM azure.digital_twins.vw_time_series_database_connections
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND subscriptionId = '{{ subscriptionId }}';

time_series_database_connections

SELECT
id,
name,
properties,
systemData,
type
FROM azure.digital_twins.time_series_database_connections
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.digital_twins.time_series_database_connections (
resourceGroupName,
resourceName,
subscriptionId,
timeSeriesDatabaseConnectionName,
properties
)
SELECT 
'{{ resourceGroupName }}',
'{{ resourceName }}',
'{{ subscriptionId }}',
'{{ timeSeriesDatabaseConnectionName }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - 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: connectionType
          value: string
        - name: provisioningState
          value: string
        - name: identity
          value:
            - name: type
              value: string
            - name: userAssignedIdentity
              value: string

DELETE example

Deletes the specified time_series_database_connections resource.

/*+ delete */
DELETE FROM azure.digital_twins.time_series_database_connections
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND timeSeriesDatabaseConnectionName = '{{ timeSeriesDatabaseConnectionName }}';