How to import blob storage container with sub-directories as a database in databricks sql?

[Athar]

I am trying to upload blob storage on databricks sql warehouse. I followed this document https://docs.databricks.com/data/data-sources/azure/azure-storage.html. but this doesn't seem to be working. Query executed fine but created schema was empty. And how we can make sure that data is always synced with blob container?

[Prabakar]

Was there any error reported after the query execution?

[BilalAslamDbrx]

@Athar Abbas​ the simplest thing would be to create a SAS token to the ADLS Gen 2 container and then use the COPY INTO command with the AZURE_SAS_TOKEN credential: https://docs.microsoft.com/en-us/azure/databricks/data/data-sources/azure/adls-gen2/azure-datalake-g...

[Kaniz_Fatma]

Hi @Athar Abbas​ , We haven't heard from you on the last response from @Prabakar Ammeappin​​ and @Bilal Aslam​, and I was checking back to see if their suggestions helped you.

Or else, If you have any solution, please share it with the community as it can be helpful to others.

Also, please don't forget to click on the "Select As Best" button whenever the information provided helps resolve your question.

[jose_gonzalez]

Hi @Athar Abbas​,

Just a friendly follow-up. Did any of the responses help you to resolve your question? if it did, please mark it as best. Otherwise, please let us know if you still need help.