resources

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

Overview

Name	resources
Type	Resource
Id	azure_extras.saas.resources

Fields

Name	Datatype	Description
id	string	The resource uri
name	string	The name of the resource
properties	object	saas properties
tags	object	the resource tags.
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceId	Gets information about the specified SaaS.
list	SELECT		Get All Resources
create	INSERT		Creates a SaaS resource.
update	UPDATE	resourceId	Updates a SaaS resource.

SELECT examples

Get All Resources

SELECT
id,
name,
properties,
tags,
type
FROM azure_extras.saas.resources
;

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_extras.saas.resources (
name,
tags,
location,
properties
)
SELECT 
'{{ name }}',
'{{ tags }}',
'{{ location }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: tags
      value: []
    - name: location
      value: string
    - name: properties
      value:
        - name: offerId
          value: string
        - name: publisherId
          value: string
        - name: quantity
          value: number
        - name: skuId
          value: string
        - name: paymentChannelType
          value: string
        - name: paymentChannelMetadata
          value: object
        - name: saasResourceName
          value: string
        - name: termId
          value: string
        - name: autoRenew
          value: boolean
        - name: publisherTestEnvironment
          value: string
        - name: saasSubscriptionId
          value: string
        - name: saasSessionId
          value: string

UPDATE example

Updates a resources resource.

/*+ update */
UPDATE azure_extras.saas.resources
SET 
name = '{{ name }}',
tags = '{{ tags }}',
location = '{{ location }}',
properties = '{{ properties }}'
WHERE 
resourceId = '{{ resourceId }}';