partners

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

Overview

Name	partners
Type	Resource
Id	azure_extras.management_partner.partners

Fields

vw_partners

Name	Datatype	Description
id	text	Identifier of the partner
name	text	Name of the partner
created_time	text	field from the properties object
etag	integer	Type of the partner
object_id	text	field from the properties object
partner_id	text	field from the properties object
partner_name	text	field from the properties object
state	text	field from the properties object
tenant_id	text	field from the properties object
type	text	Type of resource. "Microsoft.ManagementPartner/partners"
updated_time	text	field from the properties object
version	text	field from the properties object

partners

Name	Datatype	Description
id	string	Identifier of the partner
name	string	Name of the partner
etag	integer	Type of the partner
properties	object	this is the management partner properties
type	string	Type of resource. "Microsoft.ManagementPartner/partners"

Methods

Name	Accessible by	Required Params	Description
get	SELECT		Get the management partner using the objectId and tenantId.
create	INSERT	partnerId	Create a management partner for the objectId and tenantId.
delete	DELETE	partnerId	Delete the management partner for the objectId and tenantId.
update	UPDATE	partnerId	Update the management partner for the objectId and tenantId.

SELECT examples

Get the management partner using the objectId and tenantId.

vw_partners

SELECT
id,
name,
created_time,
etag,
object_id,
partner_id,
partner_name,
state,
tenant_id,
type,
updated_time,
version
FROM azure_extras.management_partner.vw_partners
;

partners

SELECT
id,
name,
etag,
properties,
type
FROM azure_extras.management_partner.partners
;

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_extras.management_partner.partners (
partnerId
)
SELECT 
'{{ partnerId }}'
;

Manifest

- name: your_resource_model_name
  props: []

UPDATE example

Updates a partners resource.

/*+ update */
UPDATE azure_extras.management_partner.partners
SET 

WHERE 
partnerId = '{{ partnerId }}';

DELETE example

Deletes the specified partners resource.

/*+ delete */
DELETE FROM azure_extras.management_partner.partners
WHERE partnerId = '{{ partnerId }}';