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,768 questions
2 answers
One of the answers was accepted by the question author.
ADF in Azure Synapse Analytics Workspace: Trigger Now gives error message "Sync and publish your changes before clicking "Trigger now"."
We have a simple ADF developed in Azure Synapse Analytics Workspace. Running it via "Debug" works fine. Running it via "Trigger Now" gives the error message Sync and publish your changes before clicking "Trigger now". …
asked 2021-01-26T13:00:22.25+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, 81%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Herven Stefan (SEIT)
41
Reputation points
commented 2021-02-03T17:39:42.33+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(67.2, 50%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Marcos Germano
1
Reputation point
1 answer
One of the answers was accepted by the question author.
Synapse spark logs
Hello, Is there a possibility to get access to Spark logs in Synapse other than through Spark UI? I've tried specifying "properties.defaultSparkLogFolder" when creating spark pools but it does not seem to have any effect - what is it used…
![](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(262.40000000000003, 19%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
0 answers
Synapse query failed after 6 minutes from Data factory
Hi, I'm using the copy activity to extract data from Synapse analytics (SQL DWH). After exactly 6:38 minutes the query fails and the error is a Timeout Error. If a run the query from ssms, works. I set up the max time for query timeout: …
asked 2021-01-25T12:31:30.273+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(307.2, 17%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
Jhonatan Reyes
61
Reputation points
commented 2021-02-02T17:27:22.957+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(192, 26%, 28%)' 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)
HimanshuSinha-msft
19,466
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Synapse workspace - Error code: ClientIpAddressNotAuthorized Inner error code: ClientIpAddressNotAuthorized
Getting this error when trying to save a notebook in Synapse workspace Error code: ClientIpAddressNotAuthorized Inner error code: ClientIpAddressNotAuthorized I can access synapse DB from SSMS and from browser based - Query editor. Any…
asked 2021-02-02T08:40:16.013+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(73.60000000000001, 62%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXK%3C/text%3E%3C/svg%3E)
xRajeev Karn
21
Reputation points
accepted 2021-02-02T11:59:41.55+00:00
xRajeev Karn
21
Reputation points
1 answer
One of the answers was accepted by the question author.
Synapse Studio Access control - "Add" button disables
Hello, I'm trying to add a service principal as a Synapse Contributor, but when I go to Manage -> Access Control in Synapse Studio "Add" button is disabled. The user I'm logged in with is Synapse Administrator. Are there any additional…
![](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, 50%, 23%)' 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)
1 answer
query to specific partition in synapse?
In oracle, to query the particular partition we use following partition keyword i.e SELECT * FROM employees PARTITION (p1); is there any similar command in azure synapse, to query the particular partition in partition table? Also how to identify in…
asked 2021-01-18T17:15:43.817+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(115.19999999999999, 4%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
ash b
1
Reputation point
commented 2021-01-29T07:02:43.993+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(108.80000000000001, 9%, 20%)' 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)
HarithaMaddi-MSFT
10,136
Reputation points
1 answer
One of the answers was accepted by the question author.
Update-AzSynapseSqlPool suspend or resume not working
Hi, I have installed the Az.Synapse module Install-Module -Name Az.Synapse I have connection to the Synapse Workspace and sqlpool Test-AzSynapseSqlPool -WorkspaceName "synws-futurefdw-devtest" -Name sqlpool True Now I want to…
asked 2021-01-28T06:52:46.853+00:00
Herven Stefan (SEIT)
41
Reputation points
accepted 2021-01-28T10:00:32.08+00:00
Herven Stefan (SEIT)
41
Reputation points
1 answer
One of the answers was accepted by the question author.
Solutioning without ADLS
I am planning to ingest source tables without using ADLS. I do not have any file analytics requirement, just intend to load the source to Synapse and top of that to build dimensional model. Do you see any disadvantage/risk here as I am planning to…
asked 2021-01-22T12:24:29.163+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, 64%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EX%3C/text%3E%3C/svg%3E)
xyz_chatter
211
Reputation points
commented 2021-01-27T09:47:50.293+00:00
xyz_chatter
211
Reputation points
1 answer
One of the answers was accepted by the question author.
Error Code "6001"
I am running a Synapse Notebook through a synapse pipeline and am getting an error code 6001 "Creating new Synapse Notebook Statement Failed" and haven't been able to find anything explaining why. When running the code manually, it runs…
![](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(182.40000000000003, 34%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAW%3C/text%3E%3C/svg%3E)
1 answer
Does TR support between On-premise SQL Server and Azure Synapse #5925
Does Microsoft support Transactional Replication between On-premise SQL Server and Azure Synapse?
asked 2021-01-19T12:18:39.553+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(160, 57.00000000000001%, 25%)' 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)
Sarvesh Pandey
141
Reputation points
commented 2021-01-26T18:11:28.927+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, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Saurabh Sharma
23,796
Reputation points Microsoft Employee
0 answers
urgent - synapse partition table no performance difference?
one of synapse table we've 300 million rows and keep increasing. Every row as status column i.e active_row either 0 or 1. Active_row is int datatype. Users only query based active_row = 1 which has only 28 million row and rest of data i.e 270 million is…
asked 2021-01-18T17:00:28.667+00:00
ash b
1
Reputation point
commented 2021-01-25T09:22:03.707+00:00
HarithaMaddi-MSFT
10,136
Reputation points
1 answer
ADF load empty strings as null using Polybase
{ "name": " ", "properties": { "activities": [ { "name": " ", "type": "Copy", "dependsOn": [], "policy": { "timeout":…
asked 2021-01-19T08:33:42.207+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(51.2, 60%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
FionaHu
1
Reputation point
commented 2021-01-22T18:02:30.04+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(172.8, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
MartinJaffer-MSFT
26,071
Reputation points
1 answer
One of the answers was accepted by the question author.
Is it possible to replicate data from an Azure SQL Managed Instance database to an Azure Synapse database?
We are considering using Azure SQL managed instance for our OLTP applications and Azure Synapse for analytical applications. For some operational reporting use cases, we need copy of data from OLTP databases inside Azure Synapse. For these scenarios, …
asked 2021-01-13T16:18:30.437+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(259.20000000000005, 50%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Prashanth Padebettu
21
Reputation points
accepted 2021-01-21T14:41:24.287+00:00
Prashanth Padebettu
21
Reputation points
1 answer
One of the answers was accepted by the question author.
User with contributor role on Resource group can't query on Synapse Studio
Hello, ...and thanks in advance. I've just joined some users to a resource group that includes a Synapse workspace. I've added them as contributors in the whole resource group and they can access to the Synapse Studio but they has no 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(16, 52%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
1 answer
How to convert LOTS and LOTS of log data stored in JSON format in Azure Data Lake (Gen2) to parquet files?
I have tens of thousands of devices in the field that store their logs to a centralized Azure Data Lake Gen 2 BLOB storage. The data is JSON format. The data is actually very flat, not a lot of nested arrays, etc. It could almost be a CSV format just…
asked 2021-01-16T05:06:51.797+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(147.20000000000002, 56.00000000000001%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ5%3C/text%3E%3C/svg%3E)
JasonW-5564
161
Reputation points
commented 2021-01-20T07:07:54.887+00:00
HarithaMaddi-MSFT
10,136
Reputation points
1 answer
Fastest way to load data from SQL server to Azure synapse
what's the fastest way to load data from SQL Server to Azure synapse .... suppose the SQL Server is on-prem... Data factory , using SQL Server as Source and Azure synapse as sink will give a best performance ?? or need to SQL Server -> to a…
asked 2021-01-18T02:14:26.54+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, 40%, 23%)' 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)
sakuraime
2,321
Reputation points
commented 2021-01-20T06:59:53.237+00:00
HarithaMaddi-MSFT
10,136
Reputation points
1 answer
How to add .so file to a sys.path directory?
Hi, I would like to add a .so file to one of the sys.path directories. I have attempted to use shutil to copy over from adls, but shutil doesn't recognise this path. Any ideas? Thanks
asked 2021-01-11T11:47:54.697+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(108.80000000000001, 40%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBH%3C/text%3E%3C/svg%3E)
Ben Holden
1
Reputation point
answered 2021-01-20T06:10:20.647+00:00
MartinJaffer-MSFT
26,071
Reputation points
0 answers
Access Azure Storage account via Synapse through Managed Identity
I am trying to connect to Azure Blob storage via Azure synapse through Managed Identity based on the below set of steps: 1) Assigned an Identity to the Server 2) Gave access to the Server on Blob storage as contributor 3) Executed the below queries …
asked 2020-12-31T09:36:57.91+00:00
Nandan Hegde
31,771
Reputation points MVP
commented 2021-01-19T23:51:57.773+00:00
Saurabh Sharma
23,796
Reputation points Microsoft Employee
2 answers
How to migrate Dedicatel SQL Pool (DW) to Serveless Synapse?
I have Azure Datawarehouse which has fixed pricing tier DW100. Usage is small and assuming that Serverless can be cheaper. A) How do get information how much data processing have been occururing in last month? B) How to do migration to Serverless?
asked 2021-01-04T10:18:44.87+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(12.8, 0%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Kenny
1
Reputation point
commented 2021-01-19T19:34:21+00:00
HimanshuSinha-msft
19,466
Reputation points Microsoft Employee
asked 2021-01-11T16:34:32.613+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(48, 2%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERL%3C/text%3E%3C/svg%3E)
Richard Luis Díaz
21
Reputation points
answered 2021-01-16T09:43:02.74+00:00
Richard Luis Díaz
21
Reputation points