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,527 questions
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
![](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
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,486
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,486
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
2 answers
One of the answers was accepted by the question author.
Getting SSL certificate error while connecting to Synapse SQL pool from Databricks in Azure using JDBC
--------------------------------------------------------------------------- Py4JJavaError Traceback (most recent call last) <command-3031308706598466> in <module> 6 .option("tempDir",…
asked 2020-10-06T17:17:39.827+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(150.4, 91%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Ajay Verma
21
Reputation points
commented 2020-10-15T05:11:29.787+00:00
PRADEEPCHEEKATLA-MSFT
81,486
Reputation points Microsoft Employee
2 answers
There are no adventureworks tables in datawarehouse
Trying to create an azure datawarehouse using powershell and want to import sample adventureworks data in it using powershell. Passing samplename parameter as "AdventureworksLT". But when the Dataware house is created,there are no…
asked 2020-10-06T10:12:26.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(262.40000000000003, 44%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Suneetha Devibusi
1
Reputation point
commented 2020-10-09T16:57:11.477+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
0 answers
ADW : Any changes to HEAP in Gen3
Hi All, We are using HEAP for transient data and want to check with experts if there are any upcoming changes to HEAP in Gen3.
asked 2020-10-02T18:11:11.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(291.2, 84%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFP%3C/text%3E%3C/svg%3E)
Faiaz Pasha Shaik
21
Reputation points Microsoft Employee
commented 2020-10-06T08:39:59.183+00:00
PRADEEPCHEEKATLA-MSFT
81,486
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Azure Synapse Analytics - Resource Class assignment to Active Directory Group
I've assigned resource_class to a specific Active Directory group, but the user within that group gets the default resource_class assigned when executing queries. User X is assigned to AD group Y. Y is assigned to 'mediumrc' but the execution…
asked 2020-09-30T12:41:26.59+00:00
XchangeVisions
301
Reputation points
commented 2020-10-05T19:36:44.087+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(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT
46,427
Reputation points Microsoft Employee
0 answers
Synapse not supporting pagination JPA
When trying pagination with spring data jpa; getting duplicate records from other page and some records are being skipped.
asked 2020-09-29T09:37:00.053+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(230.39999999999998, 15%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPT%3C/text%3E%3C/svg%3E)
pankaj tiwari
1
Reputation point
commented 2020-10-05T19:05:05.223+00:00
KranthiPakala-MSFT
46,427
Reputation points Microsoft Employee
1 answer
How to read a CSV file with Line break and Quotes through PolyBase in Synapse
Hi All, I have an automated source that generates Excel file with data that can contain line breaks or double quotes or some delimiter values. I am converting this Excel file to CSV using ADF Copy activity and to handle column delimiter in data i have…
asked 2020-09-11T06:51:43.757+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, 27%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPJ%3C/text%3E%3C/svg%3E)
Priya Jha
871
Reputation points
commented 2020-09-29T21:17:44.08+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,041
Reputation points
2 answers
SYNAPSE STUDIO- SQL POOL -(NEW)OPTIONS DISABLED
Hello Community, I have been facing error related to creation of new sql pool via synapse stuido. The (New) options is disabled over synapse studio. Please could anyone let me know why is the reason behind it. THanks, Deepak
asked 2020-09-10T12:54:54.187+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(278.4, 89%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
demo case
1
Reputation point
commented 2020-09-28T07:28:27.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(294.40000000000003, 37%, 38%)' 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)
Monalv-MSFT
5,896
Reputation points
2 answers
ADF Copy activity using PolyBase fails to load "Date" type to Synapse
When loading Date type from a parquet file to Synapse with "Date" type via ADF Copy with PolyBase, the ADF throws the following error: { "errorCode": "2200", "message":…
asked 2020-09-24T14:46:46.05+00:00
Robert Kostecki
6
Reputation points
answered 2020-09-25T17:15:07.9+00:00
Robert Kostecki
6
Reputation points
2 answers
One of the answers was accepted by the question author.
Spark pool does not reflect the contents of requirements.txt
I have checked the Microsoft Learn description below and am trying to add the Python libraries to the Spark pool. https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-azure-portal-add-libraries I created…
asked 2020-09-23T19:51:02.64+00:00
Yuji Masaoka
56
Reputation points
answered 2020-09-25T11:45:56.717+00:00
Yang Jiayi
1
Reputation point
1 answer
One of the answers was accepted by the question author.
Performance, Pros and Cons of using Logic Apps or Azure Data Factory for Orchestration of huge ADW and Performance, Pros and Cons of using ADFV2 Mapping Data Flows
Please share Performance, Pros and Cons of using Logic Apps or Azure Data Factory for Orchestration for huge ADW and Performance, Pros and Cons of using ADFV2 Mapping Data Flows
asked 2020-09-11T07:30:47.203+00:00
Faiaz Pasha Shaik
21
Reputation points Microsoft Employee
accepted 2020-09-25T08:21:21.553+00:00
Faiaz Pasha Shaik
21
Reputation points Microsoft Employee
0 answers
Data Disposal/Retirement in Azure Synapse
Can someone please let me know how to achieve data disposal/retirement in Azure Synapse Analytics (SQL DW) and how to ensure it is happening safely in Azure.
asked 2020-09-22T20:50:56.17+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, 61%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Akash Verma
21
Reputation points
commented 2020-09-25T00:31:03.757+00:00
KranthiPakala-MSFT
46,427
Reputation points Microsoft Employee
2 answers
Setting password for contained users mapped to Azure AD identities
Hi, I'm implementing Azure Active Directory Authentication for users to get in and use Synapse Analytics (SQL DW). I have 2 questions they are as follows: The Azure AD method that I used was Azure Active Directory Password. Through…
asked 2020-09-17T19:52:11.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(172.8, 21%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENP%3C/text%3E%3C/svg%3E)
Neil Pereira
81
Reputation points
commented 2020-09-24T06:42:34.207+00:00
KranthiPakala-MSFT
46,427
Reputation points Microsoft Employee
0 answers
Pause/Resume SQL Synapse using SSIS
Hello, We are working on creating an automation script where our SQL Synapse can be paused/resumed during a time window for cost savings. Basically we wanted to do it in SSIS using powershell becase we wanted to check if there are any queries running…
asked 2020-09-11T11:19:59.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(99.2, 99%, 19%)' 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)
DeeMu
1
Reputation point
commented 2020-09-23T23:33:12.523+00:00
HimanshuSinha-msft
19,386
Reputation points Microsoft Employee