Anonymous
My feedback
-
7 votes
An error occurred while saving the comment Anonymous supported this idea ·
-
10 votes
-
121 votes
This feature is currently in preview and will be available to all users in coming months.
An error occurred while saving the comment Anonymous commented
I agree that what is being requested doesn't work with MPP architecture. It sounds like MSFT is working on the feature to have a multi column HASH distribution which will not actually solve what is being requested. If you have a multi column HASH, data from other tables will only co-locate when their hash key is the same set of columns,
-
705 votes
We are very excited to announce the public preview of Azure Data Factory Managed Virtual Network.
With this new feature, you can provision the Azure Integration Runtime in Managed Virtual Network and leverage Private Endpoints to securely connect to supported data stores. Your data traffic between Azure Data Factory Managed Virtual Network and data stores goes through Azure Private Link which provides secured connectivity and eliminate your data exposure to the public internet. With the Managed Virtual Network along with Private Endpoints, you can also offload the burden of managing virtual network to Azure Data Factory and protect against the data exfiltration.
To learn more about Azure Data Factory Managed Virtual Network, see https://azure.microsoft.com/blog/azure-data-factory-managed-virtual-network/
-
66 votesunder review · 5 comments · Azure Synapse Analytics » SQL/Table Structure · Flag idea as inappropriate… · Admin →
Anonymous supported this idea ·
-
108 votesunder review · 6 comments · Azure Synapse Analytics » SQL/T-SQL · Flag idea as inappropriate… · Admin →
Anonymous supported this idea ·
-
505 votes
This feature is in private preview and will be available to all users in coming months.
Anonymous supported this idea ·
-
725 votes
Thank you for your feedback! We will evaluate this as part of our product roadmap.
An error occurred while saving the comment Anonymous commented
although the workaround may work for ms sql, the lookup task does not work with Oracle if you want to add a something like an ALTER USER. I want to
Anonymous supported this idea ·
-
3 votes
Anonymous shared this idea ·
-
175 votesunder review · 9 comments · Azure Synapse Analytics » SQL/Table Structure · Flag idea as inappropriate… · Admin →
Anonymous supported this idea ·
-
5 votes
Anonymous shared this idea ·
-
172 votes
This feature is in Preview for columns in user tables.
Anonymous supported this idea ·
-
134 votesunder review · 6 comments · Azure Synapse Analytics » SQL/T-SQL · Flag idea as inappropriate… · Admin →
Anonymous supported this idea ·
An error occurred while saving the comment Anonymous commented
this is a problem... need @@ROWCOUNT
-
6 votes
Anonymous shared this idea ·
-
378 votes
Anonymous supported this idea ·
-
272 votes
Anonymous supported this idea ·
-
1 vote
Anonymous shared this idea ·
-
1 vote
Anonymous shared this idea ·
-
161 votes
Anonymous supported this idea ·
-
400 votes
Anonymous supported this idea ·
This is a big opportunity to design more efficiently in Synapse, if you are designing a traditional data warehouse with surrogate keys (via Identity columns) you are extremely limited in design. Ideally you would distribute on something like a PRODUCT_SKEY but if this is an identity you can’t so this only works with natural keys or composite keys.