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)