trusted_id_providers

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

Overview

Name	trusted_id_providers
Type	Resource
Id	azure.data_lake_store.trusted_id_providers

Fields

vw_trusted_id_providers

Name	Datatype	Description
id	text	The resource identifier.
name	text	The resource name.
accountName	text	field from the properties object
id_provider	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
trustedIdProviderName	text	field from the properties object
type	text	The resource type.

trusted_id_providers

Name	Datatype	Description
id	string	The resource identifier.
name	string	The resource name.
properties	object	The trusted identity provider properties.
type	string	The resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, resourceGroupName, subscriptionId, trustedIdProviderName	Gets the specified Data Lake Store trusted identity provider.
list_by_account	SELECT	accountName, resourceGroupName, subscriptionId	Lists the Data Lake Store trusted identity providers within the specified Data Lake Store account.
create_or_update	INSERT	accountName, resourceGroupName, subscriptionId, trustedIdProviderName, data__properties	Creates or updates the specified trusted identity provider. During update, the trusted identity provider with the specified name will be replaced with this new provider
delete	DELETE	accountName, resourceGroupName, subscriptionId, trustedIdProviderName	Deletes the specified trusted identity provider from the specified Data Lake Store account
update	UPDATE	accountName, resourceGroupName, subscriptionId, trustedIdProviderName	Updates the specified trusted identity provider.

SELECT examples

Lists the Data Lake Store trusted identity providers within the specified Data Lake Store account.

vw_trusted_id_providers

SELECT
id,
name,
accountName,
id_provider,
resourceGroupName,
subscriptionId,
trustedIdProviderName,
type
FROM azure.data_lake_store.vw_trusted_id_providers
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

trusted_id_providers

SELECT
id,
name,
properties,
type
FROM azure.data_lake_store.trusted_id_providers
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.data_lake_store.trusted_id_providers (
accountName,
resourceGroupName,
subscriptionId,
trustedIdProviderName,
data__properties,
properties
)
SELECT 
'{{ accountName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ trustedIdProviderName }}',
'{{ data__properties }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: idProvider
          value: string

UPDATE example

Updates a trusted_id_providers resource.

/*+ update */
UPDATE azure.data_lake_store.trusted_id_providers
SET 
properties = '{{ properties }}'
WHERE 
accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND trustedIdProviderName = '{{ trustedIdProviderName }}';

DELETE example

Deletes the specified trusted_id_providers resource.

/*+ delete */
DELETE FROM azure.data_lake_store.trusted_id_providers
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND trustedIdProviderName = '{{ trustedIdProviderName }}';