topic Re: No Data for External Table from Blob Storage in Data Engineering

No Data for External Table from Blob Storage

JOFinancial — Fri, 17 May 2024 13:04:30 GMT

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'

Re: No Data for External Table from Blob Storage

Hkesharwani — Fri, 17 May 2024 14:28:11 GMT

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