Thomas_Aimiuwu
New Contributor III
create table demo.cases_test as
select * from csv.`/Volumes/workspace/demo/raw/cases_test.csv`
WITH (
  header = "true",
  inferSchema  "true"
);
 
The above query also works for csv file and below works for json,parquet files respectively
 %sql
drop table if exists demo.constructors;
create table demo.constructors as
select * from json.`/Volumes/workspace/demo/raw/constructors.json`
 %sql
drop table if exists demo.constructors;
create table demo.constructors as
select * from parquet.`/Volumes/workspace/demo/raw/constructors.parquet`
Once @szymon_dybczak  thanks again, really appreciate
AT