Top / Microsoft Azure / Azure Stream Analytics / Output SQL Server

Azure Stream Analytics Output SQL Server

This page shows how to write Terraform and Azure Resource Manager for Stream Analytics Output 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_output_mssql (Terraform)

The Output SQL Server in Stream Analytics can be configured in Terraform with the resource name azurerm_stream_analytics_output_mssql. The following sections describe 2 examples of how to use the resource and its parameters.

Example Usage from GitHub

main.tf#L7
resource "azurerm_stream_analytics_output_mssql" "this" {
  database                  = var.database
  name                      = var.name
  password                  = var.password
  resource_group_name       = var.resource_group_name
  server                    = var.server
main.tf#L7
resource "azurerm_stream_analytics_output_mssql" "this" {
  database                  = var.database
  name                      = var.name
  password                  = var.password
  resource_group_name       = var.resource_group_name
  server                    = var.server

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

>> from Terraform Registry

Explanation in Terraform Registry

Manages a Stream Analytics Output to Microsoft SQL Server Database.

>> from Terraform Registry

Microsoft.StreamAnalytics/streamingjobs/outputs (Azure Resource Manager)

The streamingjobs/outputs in Microsoft.StreamAnalytics can be configured in Azure Resource Manager with the resource name Microsoft.StreamAnalytics/streamingjobs/outputs. 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 output.

  • properties required
      • datasource optional
        • serialization optional
          • sizeWindow optional - number

            The size window to constrain a Stream Analytics output to.

          • timeWindow optional - string

            The time frame for filtering Stream Analytics job outputs.

      • type required - string

      >> from Azure Resource Manager Documentation

      The Other Related Azure Stream Analytics Resources

      Frequently asked questions

      What is Azure Stream Analytics Output SQL Server?

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

      Where can I find the example code for the Azure Stream Analytics Output SQL Server?

      For Terraform, the kevinhead/azurerm and niveklabs/azurerm source code examples are useful. See the Terraform Example section for further details.

      security-icon

      Automate config file reviews on your commits

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

      Table of Contents