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,540 questions
1 answer
Azure Synapse Analytics Instance Scaling - Pool separation
When scaling OUT a Synapse Analytics Instance, will this allow multiple pools to sit on-top of a single data warehouse and be online at the same time? Example: So that one is always running at say 200 DWU for simple queries and another that we can…
asked 2020-06-04T13:51:21.713+00:00
Vladimir Nekic
22
Reputation points
commented 2020-11-06T12:15:35.89+00:00
Vladimir Nekic
22
Reputation points
2 answers
One of the answers was accepted by the question author.
Are AAD security groups supported in Synapse Analytics (workspaces preview) SQL On-Demand Databases?
Trying to add a security group user (database level) results in an error: '' is not a valid login or you do not have permission. Are security groups not supported in preview? Will they be supported in GA?
asked 2020-10-28T14:25:26.627+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(220.8, 81%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
Valter Prykäri
126
Reputation points
commented 2020-11-05T17:48:46.773+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,386
Reputation points Microsoft Employee
1 answer
how to calculate historical usage of resources in azure
Hi guys, Hope you all are doing well. I need a help in calculating historical usage of azure resources like increase in data in adls with respect to time, processing time of databricks cluster, adf, syanapse resources for last 30 days in azure…
asked 2020-10-26T04:46:20.047+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(304, 21%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Ashima Gupta
66
Reputation points
commented 2020-11-05T06:52:19.497+00:00
Ashima Gupta
66
Reputation points
1 answer
User configuration issue in azure pipeline in data factory
Hi, one of my users is facing below issue i am not able to find out why he is getting such error .. error code : 2402 Failure type : user configuration issue details : execution failed against sql server with error number 15165 .. could not…
asked 2020-11-02T07:43:01.883+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(35.2, 28.000000000000004%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Rohit Boddu
461
Reputation points
commented 2020-11-04T13:18:29.67+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,771
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Run Pipeline in Azure Synapse workspace(preview) using PowerShell
Hi All, Is there a way to run the pipeline created inside Synapse workspace using Powershell? Thanks, Ashish
asked 2020-11-03T10:53:53.127+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, 96%, 36%)' 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)
Ashish Sinha
41
Reputation points
commented 2020-11-04T11:33:34.197+00:00
Ashish Sinha
41
Reputation points
2 answers
Error while loading data from Azure Data Lake Gen2 to Azure Synapse Analytics using Azure Data Factory
Hi All, I am getting an error while loading data from Azure Data Lake Gen2 to Azure Synapse Analytics using Azure Data Factory. I am unable what exactly the error is? What permission has to be provided? How?. This error occurs when I use Polybase…
asked 2020-08-16T09:00:27.563+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(144, 55.00000000000001%, 23%)' 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)
ImranMaqsood
6
Reputation points
answered 2020-11-04T04:57:11.47+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, 77%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
Rudolph Harms
26
Reputation points
1 answer
Best way to connect two SQL Data Data Warehouses
I'm dealing with a problem where we have 2 different organizations, each with their own data warehouse. Both data warehouses will be migrated from on-prem environments to Azure and use SQL Data Warehouse. Currently, they are just sharing data via SFTP…
asked 2020-10-23T17:10:23.15+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(214.4, 56.00000000000001%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Mike Dean
1
Reputation point
commented 2020-10-30T22:13:41.413+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,046
Reputation points
1 answer
How to Obtain the query Performance Metrics - Azure Synapse
Any best practice available to Demonstrate the Ability to obtain Query Performance metrics for batch and interactive queries
asked 2020-10-27T14:10:54.823+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, 42%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Jaydeep Chakrabarty
1
Reputation point
commented 2020-10-30T11:39:02.75+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.
Azure Synapse as Refrence data
We have an existing in-house SQL server infrastructure, which currently holds both real-time as well as extract (Analytical) data. Both of these reside together because real-time data processing needs access to historical (analytical) data as a reference…
2 answers
Message(s) from 'PREDICT' engine: Input column 1 (1-based) has shape [18446744073709551615,10] which is not supported.
DECLARE @model varbinary(max) = (SELECT Model FROM [aml].[MLModel] WHERE Id = (SELECT Top(1) max(ID) FROM [aml].[MLModel])); SELECT d.*, p.* FROM PREDICT(MODEL = @model, DATA = [aml].[NYC] AS d) WITH (prediction real) AS p; Trying out the Predict…
asked 2020-09-14T20:29:53.98+00:00
Ian Santillan
197
Reputation points
answered 2020-10-29T18:51:19.893+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, 52%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETI%3C/text%3E%3C/svg%3E)
Tero Isoranta
1
Reputation point
1 answer
Synapse Analytics with sharepoint data integration for PowerBI Analytics
I'd like to analyze the data on Synapse imported from excel file on Sharepoint by PowerBI. How can I import the excel file from Sharepoint into Synapse?
asked 2020-10-08T03:41:45.987+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(313.6, 66%, 40%)' 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)
Satoshi
1
Reputation point
commented 2020-10-29T09:14:31.25+00:00
Itch Sun-MSFT
2,556
Reputation points
1 answer
Identity function on column
Hi. I have an Identity column set for one of my columns in the Azure SQL database. However the column values are not shown as expected. I want to have a sequential numbering to be set for this column, however the values are getting set randomly. …
asked 2020-10-21T04:27:26.253+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(291.2, 16%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
venkatesh padmanabhan
181
Reputation points
commented 2020-10-28T19:35:38.467+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(281.6, 93%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
Updating Python Packages in a Synapse Workspace (Preview) Spark Pool
I've followed the steps outlined here exactly: https://techcommunity.microsoft.com/t5/azure-synapse-analytics/add-manage-libraries-in-spark-pool-after-the-deployment/bc-p/1809603#M143 Namely, generate a requirements.txt file using py -m pip freeze…
asked 2020-10-22T18:07:47.343+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(316.8, 17%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJF%3C/text%3E%3C/svg%3E)
Jordan Fox
1
Reputation point
answered 2020-10-22T23:50:25.003+00:00
Jordan Fox
1
Reputation point
1 answer
One of the answers was accepted by the question author.
Using SSMS Import Flat File Wizard with Azure Synapse
I just want to load a simple CSV file into Azure Synapse. Is it possible to use the "Import Flat File Wizard" in SSMS to do that? If not, what is a quick way to import my small CSV?
asked 2020-10-21T15:33:01.703+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, 35%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
James H. Robinson
161
Reputation points
accepted 2020-10-22T19:09:54.29+00:00
James H. Robinson
161
Reputation points
1 answer
SSAS - Data Mining for Business Users
Good day, I have strong push for business users to do data science & dta mining, where they setup their rules and anomolies gets highlited etc I am looking for a tool that i need to demo very soon - Any Ideas, please help Data Mining for…
asked 2020-10-10T10:04:30.137+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, 6%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EII%3C/text%3E%3C/svg%3E)
IC IC
236
Reputation points
commented 2020-10-21T08:24:09.897+00:00
HarithaMaddi-MSFT
10,136
Reputation points
1 answer
BI SQL Data Science & Data Mining tool to do forensic / other analytics
Good day, I have a need to improve the analytics within the company, from olap reporting & powerbi theres a strong need for users to analytically interpret any set of data Looking into data science tool to plug into data warehouse Similar…
asked 2020-10-10T06:25:54.877+00:00
IC IC
236
Reputation points
commented 2020-10-21T08:22:09.697+00:00
HarithaMaddi-MSFT
10,136
Reputation points
1 answer
One of the answers was accepted by the question author.
Temporal table in Azure Synapse
Hi everyone, is it possible to create versioning tables, or Temporal tables in Azure Synapse? I've been researching the internet for a while and can't seem to find anything at all
asked 2020-10-19T05:53:49.29+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(44.800000000000004, 94%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Rock, Danny
51
Reputation points
commented 2020-10-21T05:28:40.547+00:00
PRADEEPCHEEKATLA-MSFT
81,646
Reputation points Microsoft Employee
2 answers
ADF Copy activity with PolyBase column size limit (8000 bytes)
There seems to be an error when loading columns with sizes greater than 8000 bytes via ADF Copy with Polybase and Synapse. Error message: { "errorCode": "2200", "message":…
asked 2020-10-14T12:16:02.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(121.6, 15%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Robert Kostecki
6
Reputation points
answered 2020-10-20T09:15:14.307+00:00
Robert Kostecki
6
Reputation points
0 answers
Exporting Metadate from a View in Synapse to import into ER Studio
Is is possible for me to export the metadata from Synapse view and then import into ER Studio?
asked 2020-10-14T12:07:51.323+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, 57.99999999999999%, 35%)' 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)
Frances Robbertse
1
Reputation point
commented 2020-10-19T04:43:35.17+00:00
PRADEEPCHEEKATLA-MSFT
81,646
Reputation points Microsoft Employee
1 answer
Azure Datawarehouse Performance Tuning
Hi..Am currently working on Azure Sql DB to Azure Datawarehouse migration.. After migration when I tired to run fact load sp am facing severe performance issue.. That sp which has while loop in it and it has to iterate for 7000+ plus times. For each and…
asked 2020-10-13T06:52:25.62+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(243.2, 62%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Bharathiraja
1
Reputation point
commented 2020-10-16T03:50:37.437+00:00
Mike Ubezzi
2,776
Reputation points