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.
2,627 questions
Content
0 answers
Basic information about A1 account
$150 per month For 36 months Total USD 5400 TG：azure5400
0 answers
Synapse user or schema size limit
in Azure Synapse how do I impose storage limit for either a database user or its associated schema (containing all tables)? Related to this, lets say the user has alter/create table access to another schema, is it possible to still impose size limit…
1 answer
One of the answers was accepted by the question author.
Azure Synapse Performance DMV queries
in Synapse Analytics dedicated SQL pool, can you point me to some links/posts, or share a DMV query that shows , execution time, CPU time, logicaleads, physicalreads, MAXDOP of a SQL query. I have seen…
0 answers
Pagination of REST API call with "Link" in Header and rel="next"
Hello, I have a hard time doing pagination in ADF dataflow activity. Tried many of the below, nothing worked. My Link in Header is like below - Any idea how to work on it?
asked 2023-02-02T01:11:52.59+00:00
Kumar, Arun
21
Reputation points
commented 2023-02-04T01:22:22.2+00:00
Kumar, Arun
21
Reputation points
1 answer
Synapse spark pool issue
I have a pipeline to execute the notebook. I am using XXLarge(64V/512 GB). Recently, when multiple pipelines are running, the spark pool takes a very long time to start. How to troubleshoot the performance issues with the spark pool. Is there any…
0 answers
create synapse workspace using arm template
I am following the below document to create my synapse workspace. but this deploys blank workspace. How can I deploy my linked services, pipelines, datasets etc using the ARM template. I know we can use Git. but I want to know how to deploy using the…
0 answers
Synapse showplan_xml error
If I use synapse via SSMS, i get the error "The statement Batch is currently not supported with set showplan_xml on" if I declare variables. This is not happening for hard coded values. Is there any reason for this behavior?
1 answer
Azure Synapse support for federated access
Hello, Is it possible to access SQL views created in one synapse workspace from another one? One potential option is to access it via the sql endpoint from a python code. However, is it possible to access the SQL serverless views of one workspace from…
1 answer
Copy Method in ADF - Polybase / Copy Command / Bulk Insert
Hi, We have data of million rows in delimited files placed in Azure Blob storage. We need to transfer to dedicated sql pool of Azure Synapse via Azure Data Factory So which copy method would be suitable in ADF - Copy command / polybase / Bulk Insert.…
asked 2023-02-02T07:19:52.46+00:00
Murugeswari
441
Reputation points
commented 2023-02-03T22:40:19.0466667+00:00
KranthiPakala-MSFT
33,136
Reputation points Microsoft Employee
0 answers
Is it possible to connect an Apache Spark Pool in an Azure Synapse workspace to an artifacts feed in Azure Devops?
I'm trying to configure an environment that my team are going to use with the Apache Spark pool that we've defined in our Synapse workspace. We have a number of internal packages that we have built and deployed to our own artefacts feed in Azure Devops…
asked 2023-02-02T12:21:09.1533333+00:00
Nick Petzold
0
Reputation points
commented 2023-02-03T18:29:36.4733333+00:00
BhargavaGunnam-MSFT
7,411
Reputation points Microsoft Employee
2 answers
Cannon update Synapse Triger via Rest API
Hi Team I am trying to create and update a synapse trigger via the REST API as described in this documentation link Creating a trigger works just perfectly, but updating an existing trigger does not happen. The request is received with status 203, but as…
asked 2023-02-02T13:00:31.1433333+00:00
Viktor Bakayov
0
Reputation points
commented 2023-02-03T18:10:06.3333333+00:00
MartinJaffer-MSFT
24,091
Reputation points Microsoft Employee
1 answer
How to Encrypt WEB API request and response using PyCryptodome
Recently I come up a scenario where I need to encrypt a WEB API request and response using PyCryptodome inside Synapse notebook activity. I am trying to make a call to LinkedIn API, but the request should be encrypted and similarly response should be…
asked 2023-02-03T02:08:26.36+00:00
sachin gupta
341
Reputation points
edited a comment 2023-02-03T18:05:13.62+00:00
sachin gupta
341
Reputation points
0 answers
Synapse database permissions issue
I created a SQL user and granted control privileges to the user and was able to perform the DML operations via SSMS. but when I use the linked service with that user, I am not able to perform any DML operations. I am getting this error.
0 answers
Dealing with Throttling in Copy activity with source restapi
Hi Guys - i have a copy activity that has source as a restapi and sink as a synapse DB table that fails with { "errorCode": "2200", "message": "Failure happened on 'Source' side.…
asked 2023-02-03T13:42:42.6566667+00:00
Vamsi Madhav
11
Reputation points
asked 2023-02-03T13:42:42.6566667+00:00
Vamsi Madhav
11
Reputation points
2 answers
Get the list of names via Get Metadata activity
Hi All, Below is the output of Get Metadata activity which contains name and type values for child items: Is it possible to just get the name values and stored within an array variable without using any iteration. Output =…
asked 2023-02-02T12:20:22.89+00:00
Priya Jha
721
Reputation points
answered 2023-02-03T13:30:43.1066667+00:00
Nandan Hegde
21,626
Reputation points
1 answer
Install Python pycryptodome libraries for Apache Spark in Azure Synapse
Hi All, I am tying to install pycryptodome to azure synapse notebook. PFB details. scenario - I have created a notebook and Apache spark pool in azure synapse. I used the Below command to list the packages installed on pool. I don't see my required…
asked 2023-02-01T00:59:23.05+00:00
sachin gupta
341
Reputation points
edited a comment 2023-02-03T12:36:36.4433333+00:00
sachin gupta
341
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Synapse RESTAPI - Audience validation failed
Hi, I am trying to run a Azure synapse pipeline using RESTAPI. I have generated the bearer token in the first request and using the bearer token in the second request to run the pipeline. I am facing the below error: { …
asked 2021-04-10T13:00:33.287+00:00
Sangilimurugan S
46
Reputation points
commented 2023-02-03T11:08:31.5766667+00:00
Nisha Singh
1
Reputation point
2 answers
One of the answers was accepted by the question author.
Can't Create Database Scoped Credentials in Serverless synapse Database
When I run the below script, I am getting an error saying Incorrect syntax near IDENTITY
asked 2022-08-15T22:57:56.153+00:00
Teja.Gudipati
31
Reputation points
answered 2023-02-03T10:59:54.74+00:00
Agneum
21
Reputation points
1 answer
Database scope credential Not getting created in Azure Synapse studio for SQL Serverless Db pool
CREATE DATABASE SCOPED CREDENTIAL MyCosmosDbAccountCredential WITH IDENTITY = 'SHARED ACCESS SIGNATURE', SECRET = 's5zarR2pT0JWH9k8roipnWxUYBegOuFGjJpSjGlR36y86cW0GQ6RaaG8kGjsRAQoWMw1QKTkkX8HQtFpJjC8Hg=='; The above statement is not working…
asked 2021-11-09T13:23:25.63+00:00
Sahil Bansal
1
Reputation point
commented 2023-02-03T10:51:40.2633333+00:00
Agneum
21
Reputation points
3 answers
Azure_Synapses_parent-child-hierarchies
The need is to get the company hierarchy from employee and supervisors. Currently I'm able to do this directly in powerbi by using DAX functions: HierarchyPath = PATH(workforce[employee_number],workforce[supervisor_number]) The result is this: …
asked 2023-01-06T15:04:32.02+00:00
Daniel Moreira
1
Reputation point
commented 2023-02-03T09:04:18.8766667+00:00
Daniel Moreira
1
Reputation point