Questions tagged [azure-synapse-analytics]

For questions about Azure Synapse (formerly Azure SQL Data Warehouse). It is an analytics service that brings together enterprise data warehousing and Big Data analytics.

Filter by
Sorted by
Tagged with
1 vote
0 answers
29 views

Synapse Dedicated SQL Pool: temporary CREATE TABLE failed despite number of columns are well below the maximum limit

I am performing an UPSERT operation in a Synapse Dedicated SQL Pool. The TARGET table has 394 column and I am trying to update the TARGET with 5 Unique Keys. MERGE table_A AS TARGET using (SELECT &...
user avatar
1 vote
0 answers
55 views

Azure Synapse SQL Pool: Issue in MERGE INSERT UPDATE statement

I have a table in Azure Synapse Dedicated SQL POOL. CREATE TABLE table_A ( ID int IDENTITY(1,1), ClientID varchar(10), fitrstname varchar(20), lastname varchar(30), phone ...
user avatar
1 vote
2 answers
169 views

What are the limitations in Synapse Analytics compared to normal SQL Server?

I'm keen to get a list of the feature limitations or suprises when using Synapse Analytics (a.k.a. Dedicated SQL Pool, used to be known as SQL DW / SQL Data Warehouse) compared to using normal SQL ...
user avatar
  • 468
1 vote
1 answer
26 views

How to retain same FLOAT value after converting it to a VARCHAR in Azure Synapse

Consider the following example: DROP TABLE dbo.TEST_FLOAT; CREATE TABLE dbo.TEST_FLOAT ( AMOUNT FLOAT ); INSERT INTO dbo.TEST_FLOAT (AMOUNT) VALUES (11546.25); SELECT AMOUNT, CAST(AMOUNT AS ...
user avatar
0 votes
2 answers
452 views

How to get queries executed in Synapse SQL?

I need to find all the query executed on my DB in last 1Hr in Synapse workspace with SQL pool. Will apply my logic on top of the result set. What's the right table/view to look for? sys....
user avatar
0 votes
0 answers
166 views

Azure Synapse - Need to have table access to View?

I've been trying to find information on this for quite some time but I couldn't find any confirmed results. I know that we can grant access to view without granting explicit access to the base table ...
user avatar
  • 1
0 votes
0 answers
40 views

sys.dm_pdw_request_steps command truncated

I'm new to azure synapse and have an issue where the command in sys.dm_pdw_request_steps is being truncated because it's over 4000 characters. Does anyone know where I can pull the full query text ...
user avatar
0 votes
0 answers
58 views

how to manage concurrency in Microsoft azure dedicated SQL pool?

system configuration- user count- 1200 Data warehouse Units- 1000dWU current maximum concurrency- 128 resource class used most- staticrc20(90%) , staticrc30(8%), smallrc(2%) DB size- 500 TB Problem ...
user avatar
0 votes
0 answers
44 views

Alter an existing partition in a table

The table definition of existing table is: CREATE TABLE [TEST].[TEST1] ( [ProductId] [nvarchar](256) NULL, [Date] [date] NULL, ) WITH ( DISTRIBUTION = HASH ( [ProductId] ), CLUSTERED ...
user avatar
3 votes
1 answer
467 views

How are deadlocks detected by Synapse

I'm trying to produce a deadlock in Azure Synapse. I would have expected it to work much as on-prem SQL Server does given the documentation says it "applies to" Synapse. I've waited an ...
user avatar
2 votes
0 answers
84 views

Exactly-once FIFO queue in Synapse

Creating a queue table in SQL Server is a much-studied problem. However, I would like to implement one in Azure Synapse where many of the building blocks do not exists. Specifically no table hints (...
user avatar
2 votes
3 answers
794 views

How to run legacy SSIS packages with Azure Synapse

I would like to know how to run an SSIS package from Azure Synapse Studio or whether it's at all possible. Apparently there is no support for SSIS runtime in Synapse but I suppose there should be a ...
user avatar
  • 121
1 vote
0 answers
19 views

Getting insight into partitions of a table in Azure Synapse (similar to SQL Server) [duplicate]

I'm using Dedicated SQL-Pools AKA Azure Synapse (which is different from serverless/on-demand Synapse that comes with Azure Synapse Analytics). And According to Azure: While the syntax of ...
user avatar
  • 119
1 vote
0 answers
14 views

Resource overlap between Synapse databases

I have an Azure Synapse dedicated pool with a single database. It is scaled to DW500c which the documentation says means it has a single compute node. If I add a second database how does work against ...
user avatar
0 votes
1 answer
1k views

Create an Azure Synapse temp table from a SELECT with ORDER BY

I have the following statement that works when I omit the ORDER BY clause, or if I run it as a select and omit the create table part, but I need both to ensure my generated key is sequenced correctly ...
user avatar
0 votes
3 answers
235 views

Split intervals

I have two tables. Each holds some attributes for a business entity and the date range for which those attributes were valid. I want to combine these tables into one, matching rows on the common ...
user avatar
0 votes
1 answer
1k views

Getting error USE statement is not supported to switch between databases with Azure Synapse formerly SQLDW

Whenever I attempt to submit a query to Azure Synapse SQLDB (or try to do anything with the database from my application called DBForge) I get the following error message: USE statement is not ...
user avatar
  • 101