Re: Delta External table

tajinder123 · ‎03-26-2024

@shan_chandra THankyou, I just figured out same but i am glad you replied. Below i wrote and now i came and saw same thig. One thing I observed is that if files are already there in that location, create table wont work. It need to be empty, although we can use Insert into table statement and put data inside. Let me know if i am wrong here.

%sql

CREATE TABLE employee12345(id String,

first_name String,

last_name String,

email String,

gender String,

salary String,

team String)

USING DELTA

LOCATION '/dbfs/FileStore/extracted_files/employee_details/csv_files_1';