Hi,
The code looks completely fine. please check if you have any other delimiter other than , .If your CSV files use a different delimiter, you can specify it in the table definition using the OPTIONS clause.
Just to confirm I created a sample table and that worked fine for me.
Just to confirm if you have read access to the csv. try this
display(spark.read.csv("abfss://raw@finaldatabricks.dfs.core.windows.net/2021-03-21/circuits.csv"))
Harshit Kesharwani
Data engineer at Rsystema