workbook_templates

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

Overview

Name	workbook_templates
Type	Resource
Id	azure.application_insights.workbook_templates

Fields

vw_workbook_templates

Name	Datatype	Description
id	text	Azure resource Id
name	text	Azure resource name.
author	text	field from the properties object
galleries	text	field from the properties object
localized	text	field from the properties object
location	text	Resource location
priority	text	field from the properties object
resourceGroupName	text	field from the properties object
resourceName	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags
template_data	text	field from the properties object
type	text	Azure resource type

workbook_templates

Name	Datatype	Description
id	string	Azure resource Id
name	string	Azure resource name.
location	string	Resource location
properties	object	Properties that contain a workbook template.
tags	object	Resource tags
type	string	Azure resource type

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, resourceName, subscriptionId	Get a single workbook template by its resourceName.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Get all Workbook templates defined within a specified resource group.
create_or_update	INSERT	resourceGroupName, resourceName, subscriptionId	Create a new workbook template.
delete	DELETE	resourceGroupName, resourceName, subscriptionId	Delete a workbook template.
update	UPDATE	resourceGroupName, resourceName, subscriptionId	Updates a workbook template that has already been added.

SELECT examples

Get all Workbook templates defined within a specified resource group.

vw_workbook_templates

SELECT
id,
name,
author,
galleries,
localized,
location,
priority,
resourceGroupName,
resourceName,
subscriptionId,
tags,
template_data,
type
FROM azure.application_insights.vw_workbook_templates
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

workbook_templates

SELECT
id,
name,
location,
properties,
tags,
type
FROM azure.application_insights.workbook_templates
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.application_insights.workbook_templates (
resourceGroupName,
resourceName,
subscriptionId,
location,
tags,
properties
)
SELECT 
'{{ resourceGroupName }}',
'{{ resourceName }}',
'{{ subscriptionId }}',
'{{ location }}',
'{{ tags }}',
'{{ 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: properties
      value:
        - name: priority
          value: integer
        - name: author
          value: string
        - name: templateData
          value: object
        - name: galleries
          value:
            - - name: name
                value: string
              - name: category
                value: string
              - name: type
                value: string
              - name: order
                value: integer
              - name: resourceType
                value: string
        - name: localized
          value: object

UPDATE example

Updates a workbook_templates resource.

/*+ update */
UPDATE azure.application_insights.workbook_templates
SET 
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified workbook_templates resource.

/*+ delete */
DELETE FROM azure.application_insights.workbook_templates
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND subscriptionId = '{{ subscriptionId }}';