I am using a stored procedure in synapse to create a view. This stored procedure written inside a ForEach group and I Need to pass view name and column name dynamically as an Array parameter in ForEach group.

I have a number of queries that I would like to optimise to be more efficient for an Azure Synapse Analytics instance.

I have a number of queries that I would like to optimise to be more efficient for an Azure Synapse Analytics instance.

I want to automate the cost tracking of my synapse workspace on a weekly basis.
I plan to use a KQL script in Logs analytics workspace to do this.

How to get the user that created a file in a blob storage, from the trigger that is being triggered from the file creation in azure synapse analytics.
I can get for instance the file name:
@triggerBody().fileName
But I don’t know how to get the user that has created the file

I have a notebook in azure synapse that I am using to read data from a storage account ADLS gen2. The notebook runs fine when I run it directly, but i get this error when I try to call the notebook from a pipeline. Does the pipeline runs use different authorization vs when I run the notebook directly? Thanks

I have got an util that runs a post to start/pause a SQL pool within Azure synapse, however I get the error below.

I have just created a synapse analytics workspace, on opening it I get an error message similar to the below.

I have set up an Azure Synapse Serverless SQL Pool, with the goal of reading data from a Parquet data lake stored in an Azure Data Lake Gen2 container.

I have set up an Azure Synapse Serverless SQL Pool, with the goal of reading data from a Parquet data lake stored in an Azure Data Lake Gen2 container.