Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,825 questions
0 answers
Auzure Synapse - REST Linked Service doesn't save Auth headers parameters after publish
Hello, I have a Synapse workspace and last Monday I have discovered this bug: 1.Synapse is in Synapse Live mode 2.Open Manage - Linked Services - New - select REST 3.Fill all required fields and select Authorization type "Anonymous" as shown…
asked 2024-09-04T07:30:25.59+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 39%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIK%3C/text%3E%3C/svg%3E)
Ilya Kutsenko
0
Reputation points
asked 2024-09-04T07:30:25.59+00:00
Ilya Kutsenko
0
Reputation points
0 answers
'Token Authentication failed - MISE12034' Error while connecting to Serverless SQL pool created in Synapse Analytics workspace from psotman
Hi Team, I have created azure cosmos database with analytical store enabled (through azure synapse link). I am using built in sererless sql pool, I have created couple of views to access the data from analytical store. I want to access these view through…
asked 2024-09-04T06:08:47.28+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 77%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jaydeep Suryawanshi
26
Reputation points
edited the question 2024-09-04T06:09:46.2633333+00:00
Jaydeep Suryawanshi
26
Reputation points
1 answer
Medallion in Synapse or Fabric?
I'm evaluating the Medallion architecture for a data lakehouse setup, and I am trying to decide whether Azure Synapse Analytics or Microsoft Fabric is better suited for implementing this architecture. I would appreciate insights into which platform…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 53%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
1 answer
Medallion Architecture
Hi Our company is trying to migrate to Synapse. Could you explain how the Medallion architecture can be implemented in Azure Synapse Analytics? Specifically, I'm interested in understanding the best practices for organizing data layers, leveraging…
2 answers
SQL Server query fails in newer version with "VIEW DATABASE PERFORMANCE STATE permission denied" error, despite only requiring "VIEW DEFINITION" permission
I'm running a query in Synapse using the following tables: sys.query_store_plan, sys.query_store_query, and sys.query_store_query_text. This query executes successfully on SQL Server version 12.00.2531 with only the VIEW DEFINITION permission granted to…
asked 2024-09-02T05:47:17.2866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 20%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Hamza Mohammad
0
Reputation points
commented 2024-09-03T21:55:11.0833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
14,140
Reputation points Microsoft Vendor
1 answer
SQL Query to calculate size of each schemas in Azure data warehouse and to find last access time?
Hi, Is there any SQL query that could help me get the size of each schemas present in our Azure Data Warehouse service and also to find when was it last accessed? I checked and found one query below which can help me find the size of each table in…
asked 2024-08-29T11:37:15.3733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 1%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Suraj Pardeshi
0
Reputation points
edited the question 2024-09-03T21:41:14.7666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bhargava-MSFT
30,406
Reputation points Microsoft Employee
1 answer
Azure Synapse support end
Hello- I have heard that Microsoft is going to end support for synapse.Is that true ? What if customers don't want to move to Microsoft Fabric? I believe it works on data mesh so that may not be suitable for all organisation. Thanks, Sourav
asked 2024-09-03T13:18:19.65+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 35%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Sourav
100
Reputation points
edited an answer 2024-09-03T20:46:55.8266667+00:00
Bhargava-MSFT
30,406
Reputation points Microsoft Employee
0 answers
Missing and duplicate columns when fetching data from DynamicsCRM i azure synapse copy activity
Hi. When fetching data from Dynamics CRM and copying it to a DW, one of the columns appears in the preview data in the source of the copy activity, but it is not created in the DW ("LeadId"). Moreover, it doe not appear when importing schema…
asked 2024-09-02T15:15:44.0533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 94%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECL%3C/text%3E%3C/svg%3E)
Catarina Leiria
0
Reputation points
commented 2024-09-03T18:45:01.5166667+00:00
Smaran Thoomu
14,140
Reputation points Microsoft Vendor
0 answers
Apache slf4j error when setting up spark pool
I am getting the following errors when my apache spark pool job is running. The main issue seems to be the slf4j error. How do I fix this: Picked up _JAVA_OPTIONS: -Djava.io.tmpdir=/mnt/tmp Picked up _JAVA_OPTIONS: -Djava.io.tmpdir=/mnt/tmp SLF4J:…
asked 2024-09-02T09:32:31.5366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 21%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Daniel Pearson
20
Reputation points
commented 2024-09-03T16:11:07.9733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
NIKHILANETHIKUNTA
1,425
Reputation points Microsoft Vendor
1 answer
Primary file system container not visible for a Synapse Analytics workspace
Hi, I'm working with a Synapse workspace and I've noticed that in Synapse Studio, Data --> Linked --> Azure Data Lake Storage Gen2, isn't visible the primary file system container. This container is also not visible in the related ADLS Gen2. My…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 41%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Optimizing Azure Synapse Analytics for Spark Pool and Mapping Data Flows
I am encountering errors involving Livy sessions when running multiple pipelines in Synapse Notebook and mapping data flows. The errors are as follows: For notebooks: Operation on target forecast_constrained failed: Exception: Failed to create Livy…
asked 2024-08-29T08:21:28.3033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 69%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Aditya Singh
130
Reputation points
accepted 2024-09-03T14:35:59.04+00:00
Aditya Singh
130
Reputation points
1 answer
Flatten a JSON Nested Array in Azure Synapse pipeline
I am trying to flatten a JSON which has nested array objects with 1:M mapping. Please refer below JSON response. { "result": [ { "data": [ { "dimensions": [ …
asked 2024-08-29T18:01:41.31+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 0%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
sachin gupta
376
Reputation points
edited a comment 2024-09-03T14:10:20.1+00:00
Smaran Thoomu
14,140
Reputation points Microsoft Vendor
0 answers
Apache Spark 3.3 will retire but Azure Synapse Link use spark pool for delta conversion only support Apache Spark 3.3
Received email from MS mentioned that Apache Spark 3.3 will retire soon but Azure Synapse Link use spark pool for delta conversion only support Apache Spark 3.3 Any advises on this ?
asked 2024-08-13T00:46:23.4633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 0%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Chan Zhen Seng - EYSI
0
Reputation points
commented 2024-09-03T14:05:28.7+00:00
Smaran Thoomu
14,140
Reputation points Microsoft Vendor
2 answers
Always got same 'OutputDataConversionError.TypeConversionError' , even I remove the datetime column in output in the Synapse DW sql pool, and got same error after delete and recreated stream analystic.
Always got same 'OutputDataConversionError.TypeConversionError' , even I remove the datetime column in output in Synapse DW sql pool, and got same error after delete and recreated stream analystic. Stream Input is event hub, get dignostic log from azure…
asked 2021-11-12T10:31:09.177+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 52%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
woodymoo
261
Reputation points
commented 2024-09-03T13:54:27.8766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 25%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFR%3C/text%3E%3C/svg%3E)
Frank Rasche
0
Reputation points
3 answers
One of the answers was accepted by the question author.
Azure Synapse Link - Not creating tables in Synapse Analytics
Hi, I am changing from Export to Datalake via Dynamics to Azure Synapse Link as recommended by Microsoft since Export to Datalake is expiring this year. I can successfully select the FnO tables through the Azure Synpase Link which creates the data in…
asked 2024-08-05T11:05:23.24+00:00
Daniel Pearson
20
Reputation points
accepted 2024-09-03T11:36:48.43+00:00
Daniel Pearson
20
Reputation points
1 answer
One of the answers was accepted by the question author.
How to improve synapse notebook performance while storing data to blob
I have created multiple cell in notebook and executing. Taking to much time to fetching data from particular path and store data into DB as well as blob. So how can I reduce the execution time??
asked 2024-08-21T13:16:50.36+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 35%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Shrimathi M
40
Reputation points
commented 2024-09-03T09:54:34.8966667+00:00
Vinodh247
16,436
Reputation points
1 answer
One of the answers was accepted by the question author.
Data is missing from management API using service principle. ex: Advisor Recommendations
I have a requirement to load datasets from management.Azure.com (Management API), for example: Advisor Recommendations, Resources I have created a service principal in app registration and have been able to obtain the access token. However, when loading…
asked 2024-09-02T13:26:14.2+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 35%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Mahesh Reddy
20
Reputation points
commented 2024-09-03T09:54:06.36+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 31%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vinod Kumar Reddy Chilupuri
0
Reputation points Microsoft Vendor
1 answer
Open row source
nsnapshot.txt Hi, how to run json file on synapse workspace.. Tried with open row set but not working.. Pls share screenshot if sny
asked 2024-09-02T15:47:54.2266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vineet S
710
Reputation points
answered 2024-09-03T07:22:17.34+00:00
Amira Bedhiafi
22,311
Reputation points
2 answers
One of the answers was accepted by the question author.
Migrate and move pipelines created in azure data factory into synapse pipelines
Can we migrate and move pipelines created in azure data factory into synapse pipelines because we want everything to be in the same environment (synapse workspace environment) . Can we do it or not
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 11%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
0 answers
How accessing to a serverless SQL pool with a Microsoft Entra user without the related login
Hi, I need to access to a serverless SQL pool with my Microsoft Entra user (with MFA). My user is a Synapse Administrator for the related Synapse workspace. In the pool I haven't any login built with my Microsoft Entra user. Using SSMS I cannot access to…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)