F2kvmP8c

1CREATE EXTERNAL TABLE IF NOT EXISTS fact_tables.active_customers (
2    customer_id  BIGINT,
3    product STRING
4 )
5 PARTITIONED BY (country string)
6STORED AS PARQUET
7LOCATION '/YourCompany/fact_tables/active_customers';