by_ids

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

Overview

Name	by_ids
Type	Resource
Id	azure.resources.by_ids

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
create_or_update	insert	resourceId	api-version	Create a resource by ID.

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.

Name	Datatype	Description
resourceId	string	The fully qualified ID of the resource, including the resource name and resource type. Use the format, /subscriptions/{guid}/resourceGroups/{resource-group-name}/{resource-provider-namespace}/{resource-type}/{resource-name}
api-version	string	The API version to use for the operation.

INSERT examples

create_or_update

Create a resource by ID.

INSERT INTO azure.resources.by_ids (
data__plan,
data__properties,
data__kind,
data__managedBy,
data__sku,
data__identity,
resourceId,
api-version
)
SELECT 
'{{ plan }}',
'{{ properties }}',
'{{ kind }}',
'{{ managedBy }}',
'{{ sku }}',
'{{ identity }}',
'{{ resourceId }}',
'{{ api-version }}'
RETURNING
id,
name,
identity,
kind,
managedBy,
plan,
properties,
sku,
systemData,
type
;

Manifest

# Description fields are for documentation purposes
- name: by_ids
  props:
    - name: resourceId
      value: string
      description: Required parameter for the by_ids resource.
    - name: plan
      value: object
      description: |
        Plan for the resource.
    - name: properties
      value: object
      description: |
        The resource properties.
    - name: kind
      value: string
      description: |
        The kind of the resource.
    - name: managedBy
      value: string
      description: |
        ID of the resource that manages this resource.
    - name: sku
      value: object
      description: |
        The resource model definition representing SKU
    - name: identity
      value: object
      description: |
        The identity of the resource.
    - name: api-version
      value: string
      description: The API version to use for the operation.