Creating External Table from partitioned parquet table

[data_loader]

I am trying to create an external table in catalog using parquet where the parquet file is partitioned

I have tried using the below syntax,

%sql

CREATE TABLE table_name

(

col1 type1, 

col2 type2, 

col3 type3, 

)

USING parquet

 PARTITIONED BY ( col4 type4)

LOCATION "s3://<bucket-name>/<folder-name>/parquet_file/"

which gives success in creating the table

but no data is shown when i try to select the table

Can someone let me know what am i doing wrong.

[MichTalebzadeh]

This is my guess

Your code (LOCATION "s3://<bucket-name>/<folder-name>/parquet_file/) is likely pointing to a single Parquet file instead of the entire folder containing partitioned data.
try this

CREATE TABLE table_name
(
  col1 type1,
  col2 type2,
  col3 type3,
)
USING parquet
PARTITIONED BY (col4 type4)
LOCATION "s3://<bucket-name>/<folder-name>/"  -- Include trailing slash for the folder