Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- dbDescriptor {
- # Columns of the DB on which group by can done
- tags = ["campaign_id", "creative_id", "publisher_id",
- "publisher_name", "exchange_id", "device_os",
- "device_type", "country_code"]
- # Columns of the DB that will be summed during a group by
- counters = ["bids", "impressions", "clicks", "postclicks",
- "spent", "fees", "postclicks_revenue"]
- # The column with the timestamp used for all time calculations
- timeColumn = "date"
- # List of the partitions needed
- partitions = [
- {
- # Table name in Redshift
- table = "recent_data",
- # Time granularity in the partition
- precision = MINUTE,
- # How long we want to keep the data
- span = 1,
- spanUnit = DAYS
- },
- {
- table = "mid_term_data",
- precision = HOUR,
- span = 3,
- spanUnit = MONTHS
- },
- {
- table = "archived_data",
- precision = HOUR,
- span = 1,
- spanUnit = FOREVER
- }
- ]
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement