» azurerm_data_factory_dataset_sql_server
Manage a SQL Server Table Dataset inside a Azure Data Factory.
» Example Usage
resource "azurerm_resource_group" "example" {
name = "example"
location = "northeurope"
}
resource "azurerm_data_factory" "example" {
name = "example"
location = "${azurerm_resource_group.example.location}"
resource_group_name = "${azurerm_resource_group.example.name}"
}
resource "azurerm_data_factory_linked_service_sql_server" "example" {
name = "example"
resource_group_name = "${azurerm_resource_group.example.name}"
data_factory_name = "${azurerm_data_factory.example.name}"
connection_string = "Integrated Security=False;Data Source=test;Initial Catalog=test;User ID=test;Password=test"
}
resource "azurerm_data_factory_dataset_sql_server_table" "example" {
name = "example"
resource_group_name = "${azurerm_resource_group.example.name}"
data_factory_name = "${azurerm_data_factory.example.name}"
linked_service_name = "${azurerm_data_factory_linked_service_sql_server.test.name}"
}
» Argument Reference
The following arguments are supported:
-
name
- (Required) Specifies the name of the Data Factory Dataset SQL Server Table. Changing this forces a new resource to be created. Must be globally unique. See the Microsoft documentation for all restrictions. -
resource_group_name
- (Required) The name of the resource group in which to create the Data Factory Dataset SQL Server Table. Changing this forces a new resource -
data_factory_name
- (Required) The Data Factory name in which to associate the Dataset with. Changing this forces a new resource. -
linked_service_name
- (Required) The Data Factory Linked Service name in which to associate the Dataset with. -
table_name
- (Optional) The table name of the Data Factory Dataset SQL Server Table. -
folder
- (Optional) The folder that this Dataset is in. If not specified, the Dataset will appear at the root level. -
schema_column
- (Optional) Aschema_column
block as defined below. -
description
- (Optional) The description for the Data Factory Dataset SQL Server Table. -
annotations
- (Optional) List of tags that can be used for describing the Data Factory Dataset SQL Server Table. -
parameters
- (Optional) A map of parameters to associate with the Data Factory Dataset SQL Server Table. -
additional_properties
- (Optional) A map of additional properties to associate with the Data Factory Dataset SQL Server Table.
A schema_column
block supports the following:
-
name
- (Required) The name of the column. -
type
- (Optional) Type of the column. Valid values areByte
,Byte[]
,Boolean
,Date
,DateTime
,DateTimeOffset
,Decimal
,Double
,Guid
,Int16
,Int32
,Int64
,Single
,String
,TimeSpan
. Please note these values are case sensitive. -
description
- (Optional) The description of the column.
» Attributes Reference
The following attributes are exported:
-
id
- The ID of the Data Factory Dataset.
» Import
Data Factory Dataset SQL Server Table can be imported using the resource id
, e.g.
terraform import azurerm_data_factory_dataset_sql_server_table.example /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/example/providers/Microsoft.DataFactory/factories/example/datasets/example