auto table join

Vineet S 185

Hi Team,

once we pull the 2 table to synapse... is there any way it will automatically joined with primary and foreign keys like we see in power BI

Vineet S 185 Reputation points

2024-05-02T01:26:14.9633333+00:00

suggestion pls
Vineet S 185 Reputation points

2024-05-02T08:23:59.0333333+00:00

suggestion pls
Harishga 4,160 Reputation points Microsoft Vendor

2024-05-02T08:46:17.5133333+00:00

Hi @Vineet S
Welcome to Microsoft Q&A platform and thanks for posting your question here.

FOREIGN KEY constraints are not supported in Azure Synapse Analytics dedicated SQL pool. This is because dedicated SQL pool is designed to be a distributed system that can scale out to handle large amounts of data, and enforcing FOREIGN KEY constraints across distributed tables can be complex and resource intensive. Relationships is more of an OLTP concept and not common in big data platforms like Azure Synapse Analytics. You can use PRIMARY KEY and UNIQUE constraints in dedicated SQL pool. PRIMARY KEY is only supported when NONCLUSTERED and NOT ENFORCED are both used. UNIQUE constraint is only supported when NOT ENFORCED is used.

Reference
https://learn.microsoft.com/en-us/answers/questions/1392986/managing-a-table-relationship-in-azure-synapse-ana

I hope this information helps you. Let me know if you have any further questions or concerns.
Vineet S 185 Reputation points

2024-05-02T09:24:59.1433333+00:00

Please refer the question... Is there any auto join in the table in primary key... Automatically join
Harishga 4,160 Reputation points Microsoft Vendor

2024-05-03T02:49:20.6566667+00:00

Hi @Vineet S
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

1 answer

Harishga 4,160 Reputation points Microsoft Vendor

2024-05-02T10:47:44.59+00:00

@Vineet S
Unfortunately, there is no automatic join feature in Azure Synapse Analytics that automatically joins tables based on primary and foreign keys like in Power BI.

In Azure Synapse Analytics, you need to explicitly define the join condition using the JOIN statement in T-SQL. You can use the primary and foreign keys to define the join condition, but you need to specify it in the query.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Share via

auto table join

1 answer