Unable to load data in dedicated SQL pool while using data flow in azure synapse analytics?

Question

Hi Team,
I am new to azure and my requirement is I am loading the data from ADLS folder to Dedicated SQL Pool.

I am able to copy data but now I want whatever files which are coming as source in my ADLS folder should move to other archive folder and delete from the source folder while I run the pipeline from synapse and the target data will be my dedicated sql pool database table.

I tried it doing using data flow but when i am selecting sink it is not giving me the option of dedicated sql pool.

1). How can we achieve the above scenario if data flow does not work?
2). While using the wildcards because i need to load files in bulk, my existing folder is not showing that is the reason it is not deleting files from the source folder?

My source files are JSON files.

Any help would be really appreciated!

Thanks in advance.

Answer 1

Hi anonymous user ,

Thanks for posting your query on Microsoft Q&A platform.

you are right, Please check this post for the steps to use dedicated SQL pool in sink.

Please revert should you have more questions.

Thanks.