Azure Data Factory Dataset Snowflake
This page shows how to write Terraform and Azure Resource Manager for Data Factory Dataset Snowflake and write them securely.
azurerm_data_factory_dataset_snowflake (Terraform)
The Dataset Snowflake in Data Factory can be configured in Terraform with the resource name azurerm_data_factory_dataset_snowflake
. 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) Specifies the name of the Data Factory Dataset Snowflake. 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 Snowflake. Changing this forces a new resourcedata_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.schema_name
- (Optional) The schema name of the Data Factory Dataset Snowflake.table_name
- (Optional) The table name of the Data Factory Dataset Snowflake.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 Snowflake.annotations
- (Optional) List of tags that can be used for describing the Data Factory Dataset Snowflake.parameters
- (Optional) A map of parameters to associate with the Data Factory Dataset Snowflake.additional_properties
- (Optional) A map of additional properties to associate with the Data Factory Dataset Snowflake.
NOTE: This block has been deprecated in favour of the
schema_column
.
A structure_column
block supports the following (Conflicts with schema_column
):
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.
A schema_column
block supports the following (Conflicts with structure_column
):
name
- (Required) The name of the column.type
- (Optional) Type of the column. Valid values areNUMBER
,DECIMAL
,NUMERIC
,INT
,INTEGER
,BIGINT
,SMALLINT
,FLOAT``FLOAT4
,FLOAT8
,DOUBLE
,DOUBLE PRECISION
,REAL
,VARCHAR
,CHAR
,CHARACTER
,STRING
,TEXT
,BINARY
,VARBINARY
,BOOLEAN
,DATE
,DATETIME
,TIME
,TIMESTAMP
,TIMESTAMP_LTZ
,TIMESTAMP_NTZ
,TIMESTAMP_TZ
,VARIANT
,OBJECT
,ARRAY
,GEOGRAPHY
. Please note these values are case sensitive.precision
- (Optional) The total number of digits allowed.scale
- (Optional) The number of digits allowed to the right of the decimal point.
The following attributes are exported:
id
- The ID of the Data Factory Snowflake Dataset.
Explanation in Terraform Registry
Manages a Snowflake Dataset inside an 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