No Data for External Table from Blob Storage

JOFinancial
New Contributor

‎05-17-2024 06:04 AM

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'
0 Kudos

Hkesharwani
Contributor II

‎05-17-2024 07:28 AM

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.

Hkesharwani_0-1715955604153.png

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
0 Kudos