Support to add an azure sql database as an ADF dataset

[philthynz]

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or "me too" comments, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment

Description

There is no way to create an Azure ADF dataset for an Azure SQL / MSSQL database:

New or Affected Resource(s)

• azurerm_data_factory_dataset_azure_sql_database

Potential Terraform Configuration

resource "azurerm_data_factory_dataset_azure_sql_database" "example" {
  name                = "my_azure_sql_database"
  resource_group_name = "my_resource_group"
  data_factory_name   = "data_factory_name"
  linked_service_name = "linked_service_database_name"
}

Currently the workaround is to link the ADF to git, change all the json files and then re-upload. Or use ARM templates to deploy the datasets.

[aristosvo]

Hi @philthynz!

You can probably use azurerm_data_factory_custom_dataset introduced in version 2.68.0 by https://github.com/terraform-providers/terraform-provider-azurerm/pull/12484. This is a generic resource for all your datasets. It may be a bit more advanced to configure, but it's more flexible and should give you the necessary functionality.

[philthynz]

Thanks @aristosvo, yes I guess that will work. I didn't see it until now. Thanks!