CREATE EXTERNAL TABLE AS SELECT create multiple files on blob.

Question

CREATE EXTERNAL TABLE AS SELECT create multiple files on blob.

Gaddai, P (Prasad) 21

Hi, I working on a process that extracts data from synapse and write to files on blob with multi string delimiter. It tried with external table but it create multiple files on target. Is there any other way to create a single file with multi string delimiter.

Answer accepted by question author

0 additional answers

Your answer

Answer 1

Nandan Hegde 36,716 MVP Volunteer Moderator

Hey,
You can use Azure data factory copy activity with synapse as source and blob as sink creating a multi delimitteer file

Gaddai, P (Prasad) 21 Reputation points

2022-01-25T02:42:48.76+00:00

it wont accept multi string delimiter.
Nandan Hegde 36,716 Reputation points MVP Volunteer Moderator

2022-01-25T03:56:10.48+00:00

Hey,
There was an update in ADF a couple of months back wherein they now support multi delimiters.

https://learn.microsoft.com/en-us/azure/data-factory/format-delimited-text#:~:text=In%20mapping%20data%20flows%2C%20you,text%20format%20in%20Amazon%20S3.

Please accept it as answer in case helpful as it may benefit other community members as well
Gaddai, P (Prasad) 21 Reputation points

2022-01-25T04:07:45.94+00:00

Thank you for that till last week i was trying and i get row delimiter cannot be empty and multi delimiter.
Nandan Hegde 36,716 Reputation points MVP Volunteer Moderator

2022-01-25T04:43:18.13+00:00

Hey,
I am able to do it :
Gaddai, P (Prasad) 21 Reputation points

2022-01-25T04:46:05.123+00:00

Yes, Now its working. Thank you.

I was telling that last week when i tried it was not working.
Nandan Hegde 36,716 Reputation points MVP Volunteer Moderator

2022-01-25T04:49:43.277+00:00

Hey,
Great!
Glad that it worked :)

Can you please accept it as answer in case helpful as it may benefit other community members as well

Share via

CREATE EXTERNAL TABLE AS SELECT create multiple files on blob.

0 additional answers

Your answer