Stack Overflow
Stack Overflow

Questions tagged [azure-synapse-pipeline]

21 questions
0
votes
1 answer

Azure Synapse - Move SQLPool to another workspace

I need to redeploy my synapse workspace, but want to keep all dedicated sqlPools. How can the sqlPools getting moved to a different synapse workspace like this:
R. Maier
  • 340
  • 2
  • 13
0
votes
0 answers

Facing issue in Overriding synapse template parameters in three different Azure devops branches?As templates are store in workspace_publish

I have three different branches in Azuredevops and my synapse templates are stored in workspace_publish branch,I need to overwrite these template parameters using Yaml. task: Synapse workspace deployment@1 inputs: TemplateFile:…
Megha
  • 21
  • 1
0
votes
1 answer

Error when running a RDS stored procedure for PostgreSql from AWS in Azure Synapse Pipelines

I have created a pipeline to run RDS stored procedure for PostgreSQL from AWS on Azure Synapse Pipelines. To execute a procedure I am using an activity lookup. In the Lookup configuration I am doing a dynamic query, where I make the procedure call…
Tony
  • 1
  • 1
0
votes
1 answer

If using Azure Synapse Analytics in a new project - is it best to use Synapse Pipelines over ADF, or are there major considerations?

We're moving from on-premise to Azure and will be using Azure Synapse. Our transformations will largely be lift-and-shift of SQL stored procs to start. Looking at the high-level documentation, I'm not seeing any differences between ADF & Azure…
bbb0777
  • 165
  • 14
0
votes
1 answer

Is there a way to copy data from Sharepoint On Premise using Azure Datafactory or Azure Synapse Pipelines?

Hello and I hope you are well. There is this Sharepoint On Premise that stores sa few tables I would like to analyse and transform. I would like to know if it's possible to connect Azure Datafactory or Azure Synapse Pipelines to Sharepoint On…
Seanpai
  • 1
  • 1
0
votes
1 answer

how to drop table if exists in pre-copy script azure synapse pipeline Copy activity

I have an azure synapse pipeline which runs fine if target tables already exist ... Copy activity pre-copy script is @{concat('drop table ', item().target_schema, '.', item().target_object)} however I need to edit above syntax to first check if…
Scott Stensland
  • 26,870
  • 12
  • 93
  • 104
1
2