CODEWITHSUNDEEP
azureazure-data-lakeazure-synapse
Dev
Dev

Reputation: 71

Synapse - Get all sheet of en excel or csv and storage into data lake -

it's possible to get all sheet of an excel or csv and storage them into a data lake ? Many thanks

Upvotes: 0

Views: 337

Answers (1)

Vamsi Bitra
Vamsi Bitra

Reputation: 2764

I reproduced the same thing in my environment. Here are the sample files in the container:

Ref1

I'm able to get all my files you can check:

mssparkutils.fs.ls('wasbs://<container_name>@<storage_account_name>.blob.core.windows.net/')

Ref2

Reference:

Configure access to ADLS Gen2 Storage account | Microsoft

Upvotes: 1

Related Questions