factories

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

Overview

Name	factories
Type	Resource
Id	azure.data_factory.factories

Fields

vw_factories

Name	Datatype	Description
id	text	The resource identifier.
name	text	The resource name.
create_time	text	field from the properties object
e_tag	text	field from the properties object
encryption	text	field from the properties object
factoryName	text	field from the properties object
global_parameters	text	field from the properties object
identity	text	Identity properties of the factory resource.
location	text	The resource location.
provisioning_state	text	field from the properties object
public_network_access	text	field from the properties object
purview_configuration	text	field from the properties object
repo_configuration	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	The resource tags.
type	text	The resource type.
version	text	field from the properties object

factories

Name	Datatype	Description
id	string	The resource identifier.
name	string	The resource name.
eTag	string	Etag identifies change in the resource.
identity	object	Identity properties of the factory resource.
location	string	The resource location.
properties	object	Factory resource properties.
tags	object	The resource tags.
type	string	The resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	factoryName, resourceGroupName, subscriptionId	Gets a factory.
list	SELECT	subscriptionId	Lists factories under the specified subscription.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Lists factories.
create_or_update	INSERT	factoryName, resourceGroupName, subscriptionId	Creates or updates a factory.
delete	DELETE	factoryName, resourceGroupName, subscriptionId	Deletes a factory.
update	UPDATE	factoryName, resourceGroupName, subscriptionId	Updates a factory.
configure_factory_repo	EXEC	locationId, subscriptionId	Updates a factory's repo information.

SELECT examples

Lists factories under the specified subscription.

vw_factories

SELECT
id,
name,
create_time,
e_tag,
encryption,
factoryName,
global_parameters,
identity,
location,
provisioning_state,
public_network_access,
purview_configuration,
repo_configuration,
resourceGroupName,
subscriptionId,
tags,
type,
version
FROM azure.data_factory.vw_factories
WHERE subscriptionId = '{{ subscriptionId }}';

factories

SELECT
id,
name,
eTag,
identity,
location,
properties,
tags,
type
FROM azure.data_factory.factories
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.data_factory.factories (
factoryName,
resourceGroupName,
subscriptionId,
location,
tags,
identity,
properties
)
SELECT 
'{{ factoryName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ location }}',
'{{ tags }}',
'{{ identity }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: location
      value: string
    - name: tags
      value: object
    - name: eTag
      value: string
    - name: identity
      value:
        - name: type
          value: string
        - name: principalId
          value: string
        - name: tenantId
          value: string
        - name: userAssignedIdentities
          value: []
    - name: properties
      value:
        - name: provisioningState
          value: string
        - name: createTime
          value: string
        - name: version
          value: string
        - name: purviewConfiguration
          value:
            - name: purviewResourceId
              value: string
        - name: repoConfiguration
          value:
            - name: type
              value: string
            - name: accountName
              value: string
            - name: repositoryName
              value: string
            - name: collaborationBranch
              value: string
            - name: rootFolder
              value: string
            - name: lastCommitId
              value: string
            - name: disablePublish
              value: boolean
        - name: globalParameters
          value: []
        - name: encryption
          value:
            - name: keyName
              value: string
            - name: vaultBaseUrl
              value: string
            - name: keyVersion
              value: string
            - name: identity
              value:
                - name: userAssignedIdentity
                  value: string
        - name: publicNetworkAccess
          value: string

UPDATE example

Updates a factories resource.

/*+ update */
UPDATE azure.data_factory.factories
SET 
tags = '{{ tags }}',
identity = '{{ identity }}',
properties = '{{ properties }}'
WHERE 
factoryName = '{{ factoryName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified factories resource.

/*+ delete */
DELETE FROM azure.data_factory.factories
WHERE factoryName = '{{ factoryName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';