Search code examples
azureazure-data-lakeazure-synapse

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


Solution

  • 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