No Data for External Table from Blob Storage

[JOFinancial]

Hi All,

I am trying to create an external table from a Azure Blob storage container.  I recieve no errors, but there is no data in the table.  The Blob Storage contains 4 csv files with the same columns and about 10k rows of data.  Am I missing something?

create table users
(column1 string,
column2 string,
column3 string)
using csv
location 'abfss://path/to/blob/folder'

[Hkesharwani]

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"))