outputs

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

Overview

Name	outputs
Type	Resource
Id	azure.stream_analytics.outputs

Fields

vw_outputs

Name	Datatype	Description
id	text	Resource Id
name	text	Resource name
datasource	text	field from the properties object
diagnostics	text	field from the properties object
etag	text	field from the properties object
jobName	text	field from the properties object
outputName	text	field from the properties object
resourceGroupName	text	field from the properties object
serialization	text	field from the properties object
size_window	text	field from the properties object
subscriptionId	text	field from the properties object
time_window	text	field from the properties object
type	text	Resource type

outputs

Name	Datatype	Description
id	string	Resource Id
name	string	Resource name
properties	object	The properties that are associated with an output.
type	string	Resource type

Methods

Name	Accessible by	Required Params	Description
get	SELECT	jobName, outputName, resourceGroupName, subscriptionId	Gets details about the specified output.
list_by_streaming_job	SELECT	jobName, resourceGroupName, subscriptionId	Lists all of the outputs under the specified streaming job.
create_or_replace	INSERT	jobName, outputName, resourceGroupName, subscriptionId	Creates an output or replaces an already existing output under an existing streaming job.
delete	DELETE	jobName, outputName, resourceGroupName, subscriptionId	Deletes an output from the streaming job.
update	UPDATE	jobName, outputName, resourceGroupName, subscriptionId	Updates an existing output under an existing streaming job. This can be used to partially update (ie. update one or two properties) an output without affecting the rest the job or output definition.
test	EXEC	jobName, outputName, resourceGroupName, subscriptionId	Tests whether an output’s datasource is reachable and usable by the Azure Stream Analytics service.

SELECT examples

Lists all of the outputs under the specified streaming job.

vw_outputs

SELECT
id,
name,
datasource,
diagnostics,
etag,
jobName,
outputName,
resourceGroupName,
serialization,
size_window,
subscriptionId,
time_window,
type
FROM azure.stream_analytics.vw_outputs
WHERE jobName = '{{ jobName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

outputs

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.stream_analytics.outputs (
jobName,
outputName,
resourceGroupName,
subscriptionId,
name,
properties
)
SELECT 
'{{ jobName }}',
'{{ outputName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ name }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: properties
      value:
        - name: datasource
          value:
            - name: type
              value: string
        - name: timeWindow
          value: string
        - name: sizeWindow
          value: integer
        - name: serialization
          value:
            - name: type
              value: []
        - name: diagnostics
          value:
            - name: conditions
              value:
                - - name: since
                    value: string
                  - name: code
                    value: string
                  - name: message
                    value: string
        - name: etag
          value: string

UPDATE example

Updates a outputs resource.

/*+ update */
UPDATE azure.stream_analytics.outputs
SET 
name = '{{ name }}',
properties = '{{ properties }}'
WHERE 
jobName = '{{ jobName }}'
AND outputName = '{{ outputName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified outputs resource.

/*+ delete */
DELETE FROM azure.stream_analytics.outputs
WHERE jobName = '{{ jobName }}'
AND outputName = '{{ outputName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';