Content
Copy Data setting "Delete files after completion" leads to errors
So we've been using the copy data activity for some time now, and since last week it starts failing. We're daily copying about 10 million files from blob storage to ADLSGen2. The failure is a bit odd, it says "user error []". While doing some…
serverless SQL pool - Built-in cost
Hello, How can I find out the cost of a select query I run in the serverless sql pool? In the built-in I can see the amount of data used i.e. 10MB but not sure where to see the cost for this very select query I run? Thank you


How many partitions is needed with 90 billions table row count to benefit the CCI?
Hi, Say for example I have a large fact hash-distributed (CCI) table partitioned monthly with 90 billions table row count (current): How many partition is needed to create to benefit from a clustered columnstore index? Based from question 1, is it…




Azure Synapse Studio not loading on Safari
Hi! I am trying to open Synapse Studio in Safari 16.1. I do not have extensions, content blockers or any other configurations on this page that may prevent it from loading. I have already cleared the cache. No error shows up, just the loading logo keeps…


Azure Synapse Spark pool pricing
I have one doubt about cost of spark pool in synapse. I have a spark pool with automatically pauses for 15 minutes idle, but I think it's costing more than expected. For example, If two users runs different notebooks in the same pool during 10…


COPY INTO erroring out because of Polybase size limit
HdfsBridge::recordReaderFillBuffer - Unexpected error encountered filling record reader buffer: HadoopExecutionException: The size of the schema/row at ordinal 44555 is 1408314 bytes. It exceeds the maximum allowed row size of 1000000 bytes for…
Create button for dedicated sql pool is grayed out
Hi, i am taking class that requires creation of dedicated SQL pool in azure synapse, but when I go to create it, Create button is grayed out. I didn't previously create any dedicated SQL pool. Can you help?


Copy activity vs notebook which is more perfromant
I need information around the performance and cost incurred while performing copy of data from one location to another in adlsgen2 using the copy activity vs synapse notebook. Can you please recommend which will be a better approach along with details.


Is it possible to reduce the DW of a sql pool from 1000c to 750c
Is it possible to reduce the DW of a sql pool from 1000c to 750c in a sql server?


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 =…


Netsuite integration with azure
I want to integrate netsuite with azure. There are some saved reports already in netsuite. I just want to get those reports data and load into Synapse sql. I am looking for something similar to domo- netsuite app tba connector in azure. Using this…


Best way to load from Azure SQL DB to dedicated SQL pool
I want to move data from an Azure SQL Database to Synapse. I have created a SQL Dedicated pool with the following conditions: 1) Load all the tables from the database automatically, without the need to be creating for each table a pipeline. 2) Load all…


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…
Stored Procedure called from pieline remains in Queued status
We have few stored procedures which is being run using pipelines. It ran fine till yesterday. However from today morning the stored procedures are in Queued state.


ADF - how to remove the square bracket from json as a source.
My source is json file and target is API. This extra square bracket is failing to post in the target API. Anything to be done in mapping which I am missing ? I have created items collection using dataflow. Please help.


Synapse: saveAsTable non-default database
Hi. In a Synapse notebook I'm trying to write a data frame to the Synapse database with a lake which is not set as the default. I've tried different ways of doing this, specifying the path too, but I get the same error message implying that I'm…


How to download excel file from Cloud and Save it as Excel in Azure Data Lake Store in Azure Synapse?
Anyone here to help me configure the Azure Synapse Copy Activity or any other type of activity to download excel files from a cloud storage such as Dropbox and save it as it is in ADLS? The only option I have seen and tried is to configure the Copy…


Data Factory/Synapse Copy data activity failing with 500 Internal Server Error. Preview data works
I am downloading a file (CSV) from API using Copy data activity and HTTP connector. Source is fine and I am able to 'Preview the data'. Sink is Blob storage using 'Binary' type. The pipeline worked onetime and everytime failing with 500 Internal…


Getting InvalidUserAssignedMiCredential when trying to deloy Synapse Artifacts
Hi, I am trying to deploy synapse artifacts. I am getting error { "ArtifactName": "DevUserAssignedMI", "ArtifactType": "Credentials", "StatusCode":…

