topic Re: Can´t read a simple .CSV from a blob in Data Engineering

Can´t read a simple .CSV from a blob

ferbystudy — Tue, 08 Nov 2022 06:07:15 GMT

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!

thanks!

Re: Can´t read a simple .CSV from a blob

Pat — Tue, 08 Nov 2022 09:58:51 GMT

Hi @Fernando Rezende ,

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

thanks,

Pat.

Re: Can´t read a simple .CSV from a blob

ferbystudy — Tue, 08 Nov 2022 15:20:45 GMT

Sure, thanks for helping!

Re: Can´t read a simple .CSV from a blob

ferbystudy — Tue, 08 Nov 2022 21:45:15 GMT

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)