cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

Can´t read a simple .CSV from a blob

ferbystudy
New Contributor III

Guys, I am using "Databricks Community" to study. I put some files in a Blob, granted all access but I have no ideia why DB is not reading. Please see the code below and thanks for helping!

csf 

thanks!

1 ACCEPTED SOLUTION

Accepted Solutions

ferbystudy
New Contributor III

Guys, i found the problem! ****, databricks! Hhahaha

First i went to datalake and set all access to public/grant all user owner access..

I already mounted before.. So after this changes you will need to

Unmount and then Mount again!

 Yeah, after that it let me read the CSV! Hope it helps someone one day! hahaha

UNMOUNT:

dbutils.fs.unmount("/mnt/formula1d4t4lake/raw")

MOUNT:

container_name = "raw"

dbutils.fs.mount(

 source = f"abfss://{container_name}@{storage_account_name}.dfs.core.windows.net",

 mount_point = f"/mnt/{storage_account_name}/{container_name}",

 extra_configs = configs)

View solution in original post

4 REPLIES 4

Pat
Honored Contributor III

Hi @Fernando Rezende​ ,

can you please expand the whole error? It might be easier to find out why.

thanks,

Pat.

ferbystudy
New Contributor III

Sure, thanks for helping!

erro2

ferbystudy
New Contributor III

Guys, i found the problem! ****, databricks! Hhahaha

First i went to datalake and set all access to public/grant all user owner access..

I already mounted before.. So after this changes you will need to

Unmount and then Mount again!

 Yeah, after that it let me read the CSV! Hope it helps someone one day! hahaha

UNMOUNT:

dbutils.fs.unmount("/mnt/formula1d4t4lake/raw")

MOUNT:

container_name = "raw"

dbutils.fs.mount(

 source = f"abfss://{container_name}@{storage_account_name}.dfs.core.windows.net",

 mount_point = f"/mnt/{storage_account_name}/{container_name}",

 extra_configs = configs)

Kaniz
Community Manager
Community Manager

Hi @Fernando Rezende​, Thank you for sharing the solution with us.

It would mean a lot if you could select the "Best Answer" to help others find the correct answer faster.

This makes that answer appear right after the question, so it's easier to find within a thread.

It also helps us mark the question as answered so we can have more eyes helping others with unanswered questions.

Can I count on you?

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.