add segment and pdt time

Change-Id: I8af9d8f7180ffa84e684da2da2a6e5dd19fe05d0

views/revenue_pdt.view.lkml

diff --git a/views/revenue_pdt.view.lkml b/views/revenue_pdt.view.lkml
index 75c373f..f5a9cab 100644
--- a/views/revenue_pdt.view.lkml
+++ b/views/revenue_pdt.view.lkml
@@ -3,7 +3,8 @@
 #   # Or, you could make this view a derived table, like this:
   derived_table: {
     sql: SELECT
-        'foo' as foo
+        'foo' as foo,
+        segment
       FROM gcc_internal.revenue
       ;;
     sql_trigger_value: SELECT EXTRACT(HOUR FROM CURRENT_TIMESTAMP());;
@@ -16,6 +17,17 @@
     type: string
     sql: ${TABLE}.foo ;;
   }
+
+  dimension: segment {
+    type: string
+    sql: ${TABLE}.segment ;;
+
+  }
+  dimension: pdt_time {
+    type: string
+    sql: format_timestamp('%F %T', current_timestamp(), 'America/Los_Angeles') ;;
+
+  }
 #
 #   dimension: lifetime_orders {
 #     description: "The total number of orders for each user"