Azure Stream Analytics Reference Input SQL Server
This page shows how to write Terraform and Azure Resource Manager for Stream Analytics Reference Input SQL Server and write them securely.
azurerm_stream_analytics_reference_input_mssql (Terraform)
The Reference Input SQL Server in Stream Analytics can be configured in Terraform with the resource name azurerm_stream_analytics_reference_input_mssql
. The following sections describe how to use the resource and its parameters.
Example Usage from GitHub
An example could not be found in GitHub.
Parameters
The following arguments are supported:
name
- (Required) The name of the Reference Input MS SQL data. Changing this forces a new resource to be created.resource_group_name
- (Required) The name of the Resource Group where the Stream Analytics Job should exist. Changing this forces a new resource to be created.stream_analytics_job_name
- (Required) The name of the Stream Analytics Job. Changing this forces a new resource to be created.server
- (Required) The fully qualified domain name of the MS SQL server.database
- (Required) The MS SQL database name where the reference data exists.username
- (Required) The username to connect to the MS SQL database.password
- (Required) The username to connect to the MS SQL database.refresh_type
- (Required) Defines whether and how the reference data should be refreshed. Accepted values areStatic
,RefreshPeriodicallyWithFull
andRefreshPeriodicallyWithDelta
.refresh_interval_duration
- (Optional) The frequency inhh:mm:ss
with which the reference data should be retrieved from the MS SQL database e.g.00:20:00
for every 20 minutes. Must be set whenrefresh_type
isRefreshPeriodicallyWithFull
orRefreshPeriodicallyWithDelta
.full_snapshot_query
- (Required) The query used to retrieve the reference data from the MS SQL database.delta_snapshot_query
- (Optional) The query used to retrieve incremental changes in the reference data from the MS SQL database. Cannot be set whenrefresh_type
isStatic
.
In addition to the Arguments listed above - the following Attributes are exported:
id
- The ID of the Stream Analytics.
Explanation in Terraform Registry
Manages a Stream Analytics Reference Input from MS SQL. Reference data (also known as a lookup table) is a finite data set that is static or slowly changing in nature, used to perform a lookup or to correlate with your data stream. Learn more here.
Microsoft.StreamAnalytics/streamingjobs/inputs (Azure Resource Manager)
The streamingjobs/inputs in Microsoft.StreamAnalytics can be configured in Azure Resource Manager with the resource name Microsoft.StreamAnalytics/streamingjobs/inputs
. The following sections describe how to use the resource and its parameters.
Example Usage from GitHub
An example could not be found in GitHub.
Parameters
apiVersion
required - stringname
required - stringThe name of the input.
properties
requiredcompression
optionaltype
required - stringIndicates the type of compression that the input uses. Required on PUT (CreateOrReplace) requests.
partitionKey
optional - stringpartitionKey Describes a key in the input data which is used for partitioning the input data
serialization
optional
type
required - string