Skip to main content

devices_signed

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

Overview

Namedevices_signed
TypeResource
Idgoogle.prod_tt_sasportal.devices_signed

Fields

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

Methods

NameAccessible byRequired ParamsDescription
customers_deployments_devices_create_signedINSERTcustomersId, deploymentsIdCreates a signed device under a node or customer.
customers_devices_create_signedINSERTcustomersIdCreates a signed device under a node or customer.
customers_nodes_devices_create_signedINSERTcustomersId, nodesIdCreates a signed device under a node or customer.
nodes_deployments_devices_create_signedINSERTdeploymentsId, nodesIdCreates a signed device under a node or customer.
nodes_devices_create_signedINSERTnodesIdCreates a signed device under a node or customer.
nodes_nodes_devices_create_signedINSERTnodesId, nodesId1Creates a signed device under a node or customer.
customers_devices_update_signedUPDATEcustomersId, devicesIdUpdates a signed device.
deployments_devices_update_signedUPDATEdeploymentsId, devicesIdUpdates a signed device.
nodes_devices_update_signedUPDATEdevicesId, nodesIdUpdates a signed device.

INSERT example

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

/*+ create */
INSERT INTO google.prod_tt_sasportal.devices_signed (
nodesId,
encodedDevice,
installerId
)
SELECT
'{{ nodesId }}',
'{{ encodedDevice }}',
'{{ installerId }}'
;

UPDATE example

Updates a devices_signed resource.

/*+ update */
UPDATE google.prod_tt_sasportal.devices_signed
SET
installerId = '{{ installerId }}',
encodedDevice = '{{ encodedDevice }}'
WHERE
devicesId = '{{ devicesId }}'
AND nodesId = '{{ nodesId }}';