vRcrH5Lq

1CREATE TABLE IF NOT EXISTS fct_bookings (
2    id_listing BIGINT COMMENT 'Unique ID of the listing'
3  , id_host    BIGINT COMMENT 'Unique ID of the host who owns the listing'
4  , m_bookings BIGINT COMMENT 'Denoted 1 if a booking transaction occurred'
5)
6PARTITION BY ( -- this is how we define partition keys
7  ds STRING
8);