Advertisement
Guest User

Untitled

a guest
Sep 24th, 2019
166
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. dbDescriptor {
  2.   # Columns of the DB on which group by can done
  3.   tags = ["campaign_id", "creative_id", "publisher_id",
  4.         "publisher_name", "exchange_id", "device_os",
  5.         "device_type", "country_code"]
  6.  
  7.   # Columns of the DB that will be summed during a group by
  8.   counters = ["bids", "impressions", "clicks", "postclicks",
  9.               "spent", "fees", "postclicks_revenue"]
  10.  
  11.   # The column with the timestamp used for all time calculations
  12.   timeColumn = "date"
  13.  
  14.   # List of the partitions needed
  15.   partitions = [
  16.     {
  17.       # Table name in Redshift
  18.       table = "recent_data",
  19.       # Time granularity in the partition
  20.       precision = MINUTE,
  21.       # How long we want to keep the data
  22.       span = 1,
  23.       spanUnit = DAYS
  24.     },
  25.     {
  26.       table = "mid_term_data",
  27.       precision = HOUR,
  28.       span = 3,
  29.       spanUnit = MONTHS
  30.     },
  31.     {
  32.       table = "archived_data",
  33.       precision = HOUR,
  34.       span = 1,
  35.       spanUnit = FOREVER
  36.     }
  37.   ]
  38. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement