Top / Microsoft Azure / Azure Stream Analytics / Reference Input SQL Server

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.

terraform-logo

Review your .tf file for Azure best practices

Shisho Cloud, our free checker to make sure your Terraform configuration follows best practices, is available (beta).

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.

Review your Terraform file for Azure best practices

Shisho Cloud, our free checker to make sure your Terraform configuration follows best practices, is available (beta).

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 are Static, RefreshPeriodicallyWithFull and RefreshPeriodicallyWithDelta.

  • refresh_interval_duration - (Optional) The frequency in hh: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 when refresh_type is RefreshPeriodicallyWithFull or RefreshPeriodicallyWithDelta.

  • 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 when refresh_type is Static.

In addition to the Arguments listed above - the following Attributes are exported:

  • id - The ID of the Stream Analytics.

>> from Terraform Registry

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.

>> from Terraform Registry

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 - string
  • name required - string

    The name of the input.

  • properties required
      • compression optional
          • type required - string

            Indicates the type of compression that the input uses. Required on PUT (CreateOrReplace) requests.

      • partitionKey optional - string

        partitionKey Describes a key in the input data which is used for partitioning the input data

      • serialization optional
    • type required - string

    >> from Azure Resource Manager Documentation

    The Other Related Azure Stream Analytics Resources

    Frequently asked questions

    What is Azure Stream Analytics Reference Input SQL Server?

    Azure Stream Analytics Reference Input SQL Server is a resource for Stream Analytics of Microsoft Azure. Settings can be wrote in Terraform.

    security-icon

    Automate config file reviews on your commits

    Fix issues in your infrastructure as code with auto-generated patches.

    Table of Contents