Skip to main content

rai_topics

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

Overview

Namerai_topics
TypeResource
Idazure.cognitive_services.rai_topics

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.
createdAtstring (date-time)Creation time of the custom topic.
descriptionstringDescription of the custom topic.
etagstringResource Etag.
failedReasonstringFailed reason if the status is Failed.
lastModifiedAtstring (date-time)Last modified time of the custom topic.
sampleBlobUrlstringSample blob url for the custom topic.
statusstringStatus of the custom topic.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
tagsobjectResource tags.
topicIdstringThe unique identifier of the custom topic.
topicNamestringThe name of the custom topic.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, account_name, rai_topic_name, subscription_idGets the specified custom topic associated with the Azure OpenAI account.
listselectresource_group_name, account_name, subscription_idGets the custom topics associated with the Azure OpenAI account.
create_or_updateinsertresource_group_name, account_name, rai_topic_name, subscription_idCreate the rai topic associated with the Azure OpenAI account.
create_or_updatereplaceresource_group_name, account_name, rai_topic_name, subscription_idCreate the rai topic associated with the Azure OpenAI account.
deletedeleteresource_group_name, account_name, rai_topic_name, subscription_idDeletes the specified custom topic associated with the Azure OpenAI account.

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 Cognitive Services account. Required.
rai_topic_namestringThe name of the Rai Topic associated with the Cognitive Services Account. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring

SELECT examples

Gets the specified custom topic associated with the Azure OpenAI account.

SELECT
id,
name,
createdAt,
description,
etag,
failedReason,
lastModifiedAt,
sampleBlobUrl,
status,
systemData,
tags,
topicId,
topicName,
type
FROM azure.cognitive_services.rai_topics
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND account_name = '{{ account_name }}' -- required
AND rai_topic_name = '{{ rai_topic_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create the rai topic associated with the Azure OpenAI account.

INSERT INTO azure.cognitive_services.rai_topics (
properties,
tags,
resource_group_name,
account_name,
rai_topic_name,
subscription_id
)
SELECT
'{{ properties }}',
'{{ tags }}',
'{{ resource_group_name }}',
'{{ account_name }}',
'{{ rai_topic_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
etag,
properties,
systemData,
tags,
type
;

REPLACE examples

Create the rai topic associated with the Azure OpenAI account.

REPLACE azure.cognitive_services.rai_topics
SET
properties = '{{ properties }}',
tags = '{{ tags }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND account_name = '{{ account_name }}' --required
AND rai_topic_name = '{{ rai_topic_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
etag,
properties,
systemData,
tags,
type;

DELETE examples

Deletes the specified custom topic associated with the Azure OpenAI account.

DELETE FROM azure.cognitive_services.rai_topics
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND account_name = '{{ account_name }}' --required
AND rai_topic_name = '{{ rai_topic_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;