open_ais

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

Overview

Name	open_ais
Type	Resource
Id	azure_isv.elastic.open_ais

Fields

vw_open_ais

Name	Datatype	Description
id	text	The id of the integration.
name	text	Name of the integration.
integrationName	text	field from the properties object
key	text	field from the properties object
last_refresh_at	text	field from the properties object
monitorName	text	field from the properties object
open_ai_connector_id	text	field from the properties object
open_ai_resource_endpoint	text	field from the properties object
open_ai_resource_id	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	The type of the integration.

open_ais

Name	Datatype	Description
id	string	The id of the integration.
name	string	Name of the integration.
properties	object	Open AI Integration details.
type	string	The type of the integration.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	integrationName, monitorName, resourceGroupName, subscriptionId
list	SELECT	monitorName, resourceGroupName, subscriptionId
create_or_update	INSERT	integrationName, monitorName, resourceGroupName, subscriptionId
delete	DELETE	integrationName, monitorName, resourceGroupName, subscriptionId

SELECT examples

vw_open_ais

SELECT
id,
name,
integrationName,
key,
last_refresh_at,
monitorName,
open_ai_connector_id,
open_ai_resource_endpoint,
open_ai_resource_id,
resourceGroupName,
subscriptionId,
type
FROM azure_isv.elastic.vw_open_ais
WHERE monitorName = '{{ monitorName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

open_ais

SELECT
id,
name,
properties,
type
FROM azure_isv.elastic.open_ais
WHERE monitorName = '{{ monitorName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_isv.elastic.open_ais (
integrationName,
monitorName,
resourceGroupName,
subscriptionId,
properties
)
SELECT 
'{{ integrationName }}',
'{{ monitorName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: name
      value: string
    - name: id
      value: string
    - name: type
      value: string
    - name: properties
      value:
        - name: openAIResourceId
          value: string
        - name: openAIResourceEndpoint
          value: string
        - name: openAIConnectorId
          value: string
        - name: key
          value: string
        - name: lastRefreshAt
          value: string

DELETE example

Deletes the specified open_ais resource.

/*+ delete */
DELETE FROM azure_isv.elastic.open_ais
WHERE integrationName = '{{ integrationName }}'
AND monitorName = '{{ monitorName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';