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.