df-partition-table.py

spark.sql("""

CREATE TABLE IF NOT EXISTS airbnb_db.listing_meta (
    listing_id         BIGINT,
    listing_name       STRING,
    listing_url        STRING,
    property_type      STRING,
    country            STRING,
    state              STRING,
    city               STRING,
    description        STRING,
    
    dt                 STRING
)
USING PARQUET
PARTITIONED BY (dt)
LOCATION 's3://airbnb-data-lake/db/listing_meta'
COMMENT 'Airbnb Listing Meta'

""")