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.
Questions tagged [azure-synapse-analytics]
12 questions
3
votes
1 answer
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 inordinately long time (over 4 hours) yet deadlock detection has…
Michael Green
- 22,481
- 12
- 46
- 87
2
votes
0 answers
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 (READPAST etc.)
no OUTPUT clause
sp_getapplock is…
Michael Green
- 22,481
- 12
- 46
- 87
2
votes
3 answers
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 way to run legacy packages since there was in Azure…
Jayvee
- 121
- 2
1
vote
0 answers
Getting insight into partitions of a table in Azure Synapse (similar to SQL Server)
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 partitioning may be slightly different from SQL Server, the…
Kashyap
- 119
- 4
1
vote
0 answers
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 it affect the first DB's resources? Will the…
Michael Green
- 22,481
- 12
- 46
- 87
0
votes
0 answers
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 on MS SQL Server but I'm not able to do so in…
zuheir
- 1
- 1
0
votes
0 answers
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 from?
The actual SQL called is a view so the command…
Whispers Loudly
- 13
- 1
- 4
0
votes
0 answers
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 statement- We are integrating data from multiple…
pravin ghavare
- 31
- 5
0
votes
0 answers
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 COLUMNSTORE INDEX,
PARTITION
(
…
Sharad R. Telkar
0
votes
1 answer
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
Any ideas?
Msg 104381, Level 16, State 1, Line…
Lauren_G
- 37
- 3
0
votes
2 answers
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 business key and splitting the time ranges.
The…
Michael Green
- 22,481
- 12
- 46
- 87
0
votes
1 answer
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 supported to switch between databases
Can someone let me…
Carltonp
- 101