Azure Data Factory Dataset SQL Server Table
This page shows how to write Terraform and Azure Resource Manager for Data Factory Dataset SQL Server Table and write them securely.
azurerm_data_factory_dataset_sql_server_table (Terraform)
The Dataset SQL Server Table in Data Factory can be configured in Terraform with the resource name azurerm_data_factory_dataset_sql_server_table
. The following sections describe 9 examples of how to use the resource and its parameters.
Example Usage from GitHub
resource "azurerm_data_factory_dataset_sql_server_table" "adf_ds_sql" {
name = var.data_factory_dataset_sql_server_table_name
resource_group_name = var.resource_group_name
data_factory_name = var.data_factory_name
linked_service_name = var.linked_service_name
resource "azurerm_data_factory_dataset_sql_server_table" "dataset" {
name = var.name
resource_group_name = var.resource_group_name
data_factory_name = var.data_factory_name
linked_service_name = var.linked_service_name
table_name = try(var.table_name, null)
resource "azurerm_data_factory_dataset_sql_server_table" "main" {
name = var.data_factory_dataset_sql_name
resource_group_name = data.azurerm_resource_group.main.name
data_factory_name = azurerm_data_factory.main.name
linked_service_name = azurerm_data_factory_linked_service_sql_server.main.name
table_name = var.data_factory_dataset_sql_table_name
resource "azurerm_data_factory_dataset_sql_server_table" "this" {
additional_properties = var.additional_properties
annotations = var.annotations
data_factory_name = var.data_factory_name
description = var.description
folder = var.folder
resource "azurerm_data_factory_dataset_sql_server_table" "this" {
additional_properties = var.additional_properties
annotations = var.annotations
data_factory_name = var.data_factory_name
description = var.description
folder = var.folder
resource "azurerm_data_factory_dataset_sql_server_table" "example" {
name = var.name
resource_group_name = var.resource_group_name
data_factory_name = var.name
linked_service_name = var.name
}
resource "azurerm_data_factory_dataset_sql_server_table" "dataset" {
name = var.name
resource_group_name = var.resource_group_name
data_factory_name = var.data_factory_name
linked_service_name = var.linked_service_name
table_name = try(var.table_name, null)
resource "azurerm_data_factory_dataset_sql_server_table" "dataset" {
name = var.name
resource_group_name = var.resource_group_name
data_factory_name = var.data_factory_name
linked_service_name = var.linked_service_name
table_name = try(var.table_name, null)
resource "azurerm_data_factory_dataset_sql_server_table" "dataset" {
name = azurecaf_name.dataset.name
resource_group_name = var.resource_group_name
data_factory_name = var.data_factory_name
linked_service_name = var.linked_service_name
table_name = try(var.settings.table_name, null)
Parameters
-
additional_properties
optional - map from string to string -
annotations
optional - list of string -
data_factory_name
required - string -
description
optional - string -
folder
optional - string -
id
optional computed - string -
linked_service_name
required - string -
name
required - string -
parameters
optional - map from string to string -
resource_group_name
required - string -
table_name
optional - string -
schema_column
list block-
description
optional - string -
name
required - string -
type
optional - string
-
-
timeouts
single block
Explanation in Terraform Registry
Manages a SQL Server Table Dataset inside a Azure Data Factory.
Tips: Best Practices for The Other Azure Data Factory Resources
In addition to the azurerm_data_factory, Azure Data Factory has the other resources that should be configured for security reasons. Please check some examples of those resources and precautions.
azurerm_data_factory
Ensure to disable public access
It is better to disable public access for Data Factory, which is enabled as default.
Microsoft.DataFactory/factories/datasets (Azure Resource Manager)
The factories/datasets in Microsoft.DataFactory can be configured in Azure Resource Manager with the resource name Microsoft.DataFactory/factories/datasets
. 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 dataset name.
properties
requiredadditionalProperties
optional - objectUnmatched properties from the message are deserialized this collection
annotations
optional - arrayList of tags that can be used for describing the Dataset.
description
optional - stringDataset description.
folder
optionalname
optional - stringThe name of the folder that this Dataset is in.
linkedServiceName
requiredparameters
optional - objectAn object mapping parameter names to argument values.
referenceName
required - stringReference LinkedService name.
type
required - stringLinked service reference type.
parameters
optional - undefinedDefinition of all parameters for an entity.
schema
optional - objectColumns that define the physical type schema of the dataset. Type: array (or Expression with resultType array), itemType: DatasetSchemaDataElement.
structure
optional - objectColumns that define the structure of the dataset. Type: array (or Expression with resultType array), itemType: DatasetDataElement.
type
required - string
Frequently asked questions
What is Azure Data Factory Dataset SQL Server Table?
Azure Data Factory Dataset SQL Server Table is a resource for Data Factory of Microsoft Azure. Settings can be wrote in Terraform.
Where can I find the example code for the Azure Data Factory Dataset SQL Server Table?
For Terraform, the FabLabGent/InfrastructureFabLabGent, anmoltoppo/Terraform and microsoft/cobalt source code examples are useful. See the Terraform Example section for further details.