Skip to main content

inputs

Creates, updates, deletes, gets or lists an inputs resource.

Overview

Nameinputs
TypeResource
Idazure.stream_analytics.inputs

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringResource Id.
namestringResource name.
compressionobjectDescribes how input data is compressed.
diagnosticsobjectDescribes conditions applicable to the Input, Output, or the job overall, that warrant customer attention.
etagstringThe current entity tag for the input. This is an opaque string. You can use it to detect whether the resource has changed between requests. You can also use it in the If-Match or If-None-Match headers for write operations for optimistic concurrency.
partitionKeystringpartitionKey Describes a key in the input data which is used for partitioning the input data.
serializationobjectDescribes how data from an input is serialized or how data is serialized when written to an output. Required on PUT (CreateOrReplace) requests.
typestringResource type.
watermarkSettingsobjectSettings which determine whether to read watermark events.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, job_name, input_name, subscription_idGets details about the specified input.
list_by_streaming_jobselectresource_group_name, job_name, subscription_id$selectLists all of the inputs under the specified streaming job.
create_or_replaceinsertresource_group_name, job_name, input_name, subscription_idIf-Match, If-None-MatchCreates an input or replaces an already existing input under an existing streaming job.
updateupdateresource_group_name, job_name, input_name, subscription_idIf-MatchUpdates an existing input under an existing streaming job. This can be used to partially update (ie. update one or two properties) an input without affecting the rest the job or input definition.
create_or_replacereplaceresource_group_name, job_name, input_name, subscription_idIf-Match, If-None-MatchCreates an input or replaces an already existing input under an existing streaming job.
deletedeleteresource_group_name, job_name, input_name, subscription_idDeletes an input from the streaming job.
testexecresource_group_name, job_name, input_name, subscription_idTests whether an input’s datasource is reachable and usable by the Azure Stream Analytics service.

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
input_namestringThe name of the input. Required.
job_namestringThe name of the streaming job. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring
$selectstringThe $select OData query parameter. This is a comma-separated list of structural properties to include in the response, or "\ " to include all properties. By default, all properties are returned except diagnostics. Currently only accepts '\ ' as a valid value. Default value is None.
If-MatchstringThe ETag of the input. Omit this value to always overwrite the current input. Specify the last-seen ETag value to prevent accidentally overwriting concurrent changes. Default value is None.
If-None-MatchstringSet to '*' to allow a new input to be created, but to prevent updating an existing input. Other values will result in a 412 Pre-condition Failed response. Default value is None.

SELECT examples

Gets details about the specified input.

SELECT
id,
name,
compression,
diagnostics,
etag,
partitionKey,
serialization,
type,
watermarkSettings
FROM azure.stream_analytics.inputs
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND job_name = '{{ job_name }}' -- required
AND input_name = '{{ input_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Creates an input or replaces an already existing input under an existing streaming job.

INSERT INTO azure.stream_analytics.inputs (
name,
properties,
resource_group_name,
job_name,
input_name,
subscription_id,
If-Match,
If-None-Match
)
SELECT
'{{ name }}',
'{{ properties }}',
'{{ resource_group_name }}',
'{{ job_name }}',
'{{ input_name }}',
'{{ subscription_id }}',
'{{ If-Match }}',
'{{ If-None-Match }}'
RETURNING
id,
name,
properties,
type
;

UPDATE examples

Updates an existing input under an existing streaming job. This can be used to partially update (ie. update one or two properties) an input without affecting the rest the job or input definition.

UPDATE azure.stream_analytics.inputs
SET
name = '{{ name }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND job_name = '{{ job_name }}' --required
AND input_name = '{{ input_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND If-Match = '{{ If-Match}}'
RETURNING
id,
name,
properties,
type;

REPLACE examples

Creates an input or replaces an already existing input under an existing streaming job.

REPLACE azure.stream_analytics.inputs
SET
name = '{{ name }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND job_name = '{{ job_name }}' --required
AND input_name = '{{ input_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND If-Match = '{{ If-Match}}'
AND If-None-Match = '{{ If-None-Match}}'
RETURNING
id,
name,
properties,
type;

DELETE examples

Deletes an input from the streaming job.

DELETE FROM azure.stream_analytics.inputs
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND job_name = '{{ job_name }}' --required
AND input_name = '{{ input_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

Tests whether an input’s datasource is reachable and usable by the Azure Stream Analytics service.

EXEC azure.stream_analytics.inputs.test 
@resource_group_name='{{ resource_group_name }}' --required,
@job_name='{{ job_name }}' --required,
@input_name='{{ input_name }}' --required,
@subscription_id='{{ subscription_id }}' --required
@@json=
'{
"name": "{{ name }}",
"properties": "{{ properties }}"
}'
;