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:

Successfully retrieved the specified input.

NameDatatypeDescription
idstringResource Id
namestringResource name
propertiesobjectThe properties that are associated with an input. Required on PUT (CreateOrReplace) requests.
typestringResource type

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, jobName, inputNameGets details about the specified input.
list_by_streaming_jobselectsubscriptionId, resourceGroupName, jobName$selectLists all of the inputs under the specified streaming job.
create_or_replaceinsertsubscriptionId, resourceGroupName, jobName, inputNameIf-Match, If-None-MatchCreates an input or replaces an already existing input under an existing streaming job.
updateupdatesubscriptionId, resourceGroupName, jobName, inputNameIf-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.
deletedeletesubscriptionId, resourceGroupName, jobName, inputNameDeletes an input from the streaming job.
testexecsubscriptionId, resourceGroupName, jobName, inputNameTests 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
inputNamestringThe name of the input.
jobNamestringThe name of the streaming job.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.
$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.
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.
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.

SELECT examples

Gets details about the specified input.

SELECT
id,
name,
properties,
type
FROM azure.stream_analytics.inputs
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND jobName = '{{ jobName }}' -- required
AND inputName = '{{ inputName }}' -- required
;

INSERT examples

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

INSERT INTO azure.stream_analytics.inputs (
data__name,
data__properties,
subscriptionId,
resourceGroupName,
jobName,
inputName,
If-Match,
If-None-Match
)
SELECT
'{{ name }}',
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ jobName }}',
'{{ inputName }}',
'{{ 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
data__name = '{{ name }}',
data__properties = '{{ properties }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND jobName = '{{ jobName }}' --required
AND inputName = '{{ inputName }}' --required
AND If-Match = '{{ If-Match}}'
RETURNING
id,
name,
properties,
type;

DELETE examples

Deletes an input from the streaming job.

DELETE FROM azure.stream_analytics.inputs
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND jobName = '{{ jobName }}' --required
AND inputName = '{{ inputName }}' --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 
@subscriptionId='{{ subscriptionId }}' --required,
@resourceGroupName='{{ resourceGroupName }}' --required,
@jobName='{{ jobName }}' --required,
@inputName='{{ inputName }}' --required
@@json=
'{
"name": "{{ name }}",
"properties": "{{ properties }}"
}'
;