Skip to main content

sensor_data_models

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

Overview

Namesensor_data_models
TypeResource
Idazure_extras.agrifood_farming.sensor_data_models

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:

NameAccessible byRequired ParamsOptional ParamsDescription
create_or_updateinsertsensor_partner_id, sensor_data_model_id, endpointCreate a sensor data model entity.
create_or_updatereplacesensor_partner_id, sensor_data_model_id, endpointCreate a sensor data model entity.
deletedeletesensor_partner_id, sensor_data_model_id, endpointDeletes a sensor data model entity.
get_rawexecsensor_partner_id, sensor_data_model_id, endpointGets a sensor data model entity.
list_rawexecsensor_partner_id, endpointminCreatedDateTime, maxCreatedDateTime, minLastModifiedDateTime, maxLastModifiedDateTime, skipTokenReturns a paginated list of sensor data model resources.

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.

NameDatatypeDescription
endpointstringThe service endpoint host (no scheme). (default: )
sensor_data_model_idstringId of the sensor data model resource. Required.
sensor_partner_idstringId of the associated sensor partner. Required.
maxCreatedDateTimestring (date-time)Maximum creation date of resource (inclusive). Default value is None.
maxLastModifiedDateTimestring (date-time)Maximum last modified date of resource (inclusive). Default value is None.
minCreatedDateTimestring (date-time)Minimum creation date of resource (inclusive). Default value is None.
minLastModifiedDateTimestring (date-time)Minimum last modified date of resource (inclusive). Default value is None.
skipTokenstringSkip token for getting next set of results. Default value is None.

INSERT examples

Create a sensor data model entity.

INSERT INTO azure_extras.agrifood_farming.sensor_data_models (
sensor_partner_id,
sensor_data_model_id,
endpoint
)
SELECT
'{{ sensor_partner_id }}',
'{{ sensor_data_model_id }}',
'{{ endpoint }}'
;

REPLACE examples

Create a sensor data model entity.

REPLACE azure_extras.agrifood_farming.sensor_data_models
SET
-- No updatable properties
WHERE
sensor_partner_id = '{{ sensor_partner_id }}' --required
AND sensor_data_model_id = '{{ sensor_data_model_id }}' --required
AND endpoint = '{{ endpoint }}' --required;

DELETE examples

Deletes a sensor data model entity.

DELETE FROM azure_extras.agrifood_farming.sensor_data_models
WHERE sensor_partner_id = '{{ sensor_partner_id }}' --required
AND sensor_data_model_id = '{{ sensor_data_model_id }}' --required
AND endpoint = '{{ endpoint }}' --required
;

Lifecycle Methods

Gets a sensor data model entity.

EXEC azure_extras.agrifood_farming.sensor_data_models.get_raw 
@sensor_partner_id='{{ sensor_partner_id }}' --required,
@sensor_data_model_id='{{ sensor_data_model_id }}' --required,
@endpoint='{{ endpoint }}' --required
;