People who code: we want your input. Take the Survey

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
0answers
14 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 ...
1
vote
0answers
11 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 ...
0
votes
1answer
35 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 ...
0
votes
2answers
58 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 ...
0
votes
0answers
43 views

what kind of locks are applied by Azure Synapse when loading data using COPY INTO

what kind of locks are applied by Azure Synapse when loading data using COPY INTO, if we are running extract from synapse dw (say from table A) and simultaneously loading new data into a some other (...
0
votes
1answer
200 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 ...