connection_rai_blocklist_items

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

Overview

Name	connection_rai_blocklist_items
Type	Resource
Id	azure.ml_services.connection_rai_blocklist_items

Fields

vw_connection_rai_blocklist_items

Name	Datatype	Description
id	text	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
name	text	The name of the resource
connectionName	text	field from the properties object
is_regex	text	field from the properties object
pattern	text	field from the properties object
raiBlocklistItemName	text	field from the properties object
raiBlocklistName	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
type	text	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
workspaceName	text	field from the properties object

connection_rai_blocklist_items

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
name	string	The name of the resource
properties	object	RAI Custom Blocklist Item properties.
systemData	object	Metadata pertaining to creation and last modification of the resource.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

Name	Accessible by	Required Params	Description
get	SELECT	connectionName, raiBlocklistItemName, raiBlocklistName, resourceGroupName, subscriptionId, workspaceName
list	SELECT	connectionName, raiBlocklistName, resourceGroupName, subscriptionId, workspaceName
create	INSERT	connectionName, raiBlocklistItemName, raiBlocklistName, resourceGroupName, subscriptionId, workspaceName, data__properties
delete	DELETE	connectionName, raiBlocklistItemName, raiBlocklistName, resourceGroupName, subscriptionId, workspaceName
add_bulk	EXEC	connectionName, raiBlocklistName, resourceGroupName, subscriptionId, workspaceName

SELECT examples

vw_connection_rai_blocklist_items

SELECT
id,
name,
connectionName,
is_regex,
pattern,
raiBlocklistItemName,
raiBlocklistName,
resourceGroupName,
subscriptionId,
system_data,
type,
workspaceName
FROM azure.ml_services.vw_connection_rai_blocklist_items
WHERE connectionName = '{{ connectionName }}'
AND raiBlocklistName = '{{ raiBlocklistName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

connection_rai_blocklist_items

SELECT
id,
name,
properties,
systemData,
type
FROM azure.ml_services.connection_rai_blocklist_items
WHERE connectionName = '{{ connectionName }}'
AND raiBlocklistName = '{{ raiBlocklistName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.ml_services.connection_rai_blocklist_items (
connectionName,
raiBlocklistItemName,
raiBlocklistName,
resourceGroupName,
subscriptionId,
workspaceName,
data__properties,
properties
)
SELECT 
'{{ connectionName }}',
'{{ raiBlocklistItemName }}',
'{{ raiBlocklistName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ workspaceName }}',
'{{ data__properties }}',
'{{ 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: isRegex
          value: boolean
        - name: pattern
          value: string

DELETE example

Deletes the specified connection_rai_blocklist_items resource.

/*+ delete */
DELETE FROM azure.ml_services.connection_rai_blocklist_items
WHERE connectionName = '{{ connectionName }}'
AND raiBlocklistItemName = '{{ raiBlocklistItemName }}'
AND raiBlocklistName = '{{ raiBlocklistName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';