.sql.azuresynapse.net vs *.database.windows.net

sakuraime 2,316 Reputation points

I have two Azure synapse dedicated pool , one in .sql.azuresynapse.net and another one is in *.database.windows.net

what are the difference ? performance or other difference ?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,118 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,407 Reputation points Microsoft Employee

    Hi @sakuraime ,

    Thanks for your query.

    If the Synapse dedicated pool is created outside of Synapse Workspace [existing DW customers - formerly Azure SQL DW)] then it is - *.database.windows.net

    If it’s created from a Synapse Analytics Workspace then it is - .sql.azuresynapse.net

    Technically it's just a DNS cname record done for branding purposes: foo.sql.azuresynapse.net points to foo.database.windows.net. There should be no performance difference in actual client-server interaction.

    Hope this clarifies.


    Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.

    1 person found this answer helpful.