Skip to main content

Community

Transformations: Add support for SQL SERVER and AZURE destination

Please sign in to leave a comment.

Comments

10 comments

  • Anna User

    @Janie what type of transformations are you using? SQL Server and Azure SQL are supported with dbt Core Transformations today.

    I wanted to use Fivetran Data Model for Facebook Ads, but it seem it only supports BigQuerySnowflakeRedshiftPostgreSQL, or Databricks as the destination.

  • Anna User

    Ah, thank you for the clarification. I will forward this request to the team that manages the open-source data models.

    Upvoting for this. Using NetSuite connector but dbt Core is not supported for SQL Server destination.

    I need to use QuickBooks data model with Sql Server as destination 

  • Elan User

    Hey Janie, Julia, and Mon -- we're glad to hear you are interested in using our data models! We are interested in eventually adding Azure SQL Database as a supported destination for all of our data models and are continuing to collect demand to improve the priority here. Unfortunately I can not provide an exact timeline of when this will be, but I can keep you updated within this ticket when we begin working on it. 

    Additionally, our packages are open source so if you are interested in creating a PR for this change we are more than happy to work with you on the implementation and approval for it. Let me know if contributing to our package interests you and/or you need some guidance here. 

    What is the status of this! I could grow my usage if you add this.

  • Elan User

    Hey Doug, as of now we do still not support Azure SQL Server but our team is welcome to work with you to create a PR if you are interested in opening a PR in our open source packages. 

    We use Azure SQL as our destination and would like to use the pre-built Data Models.  

    Would love to have Azure SQL added as a supported destination. We have several of the quickstart models that would be incredibly helpful to have. Are there any updated plans to add this destination?