Load CSV data from Azure data lake to Snowflake tables

If you would like to learn Snowflake from scratch, access to my full Snowflake course on Udemy:
www.udemy.com/course/snowflak...
Website:
www.theeducationmachine.com/
-------------------------------------------------------------------------------
Post your queries, questions in comment section, i will try to answer them within 24 hours.
Please like, comment and subscribe my channel.
HAPPY LEARNING!

[@keshavareddy4179]

I search so many websites not getting exact information,but your video more helpful bother.....

[@deepaksen9308]

I got the exact answer which I was looking for. thanks

[@rahulsadawarte3846]

Hey, This is very helpful. :)

[@sarveshkr5082]

awesome

[@janvinaik5072]

thankyouuu

[@prabhakark5433]

How to read a txt formatted file which having multiple columns and I want to load the data into a singular column in snowflake?

[@arunashah6555]

I work in snowflake and ingest data but not sure how exactly the account set up works to fetch data from data lake as account used is company account so I used my own dummy data and table and was able to.load data in raw layer

[@arunashah6555]

So basically how data is getting stored in data lake and what r rhe methods to ingest it.

[@dibyajyotidatta871]

Can you make an video on loading data from external source in power bi using rest api. For example peoplesoft hr sytem

[@shankarnarayanan24]

What if we have 10 files of txt format in AdLS gen2.. do we have to use all these steps for each and every file?

[@shankarnarayanan24]

And what if these files come on a regular basis.. how do we load everyday using this method?

[@ganeshkalaivani6250]

created stage but it show unauthorized /permission error. Do i want to change any role access in snowflake

[@theeducationmachine]

You need to provide a "Storage Blob Contributor" role on ADLS to Snowflake Service principal

[@ganeshkalaivani6250]

@@theeducationmachine thank you...yes now fine