forked from pipeline-looker-blocks/stripe
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathstripe_transfers.view.lookml
128 lines (97 loc) · 2.82 KB
/
stripe_transfers.view.lookml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
- view: stripe_transfers
sql_table_name: stripeblook.stripe_transfers # https://stripe.com/docs/api/curl#transfer_object
fields:
- dimension: id
primary_key: true
type: string
sql: ${TABLE}.id
- dimension: _rjm_batched_at
type: number
sql: ${TABLE}._rjm_batched_at
- dimension: amount
type: number
sql: ${TABLE}.amount / 100 # Amount (in cents) to be transferred to your bank account
- dimension: amount_reversed
type: number
sql: ${TABLE}.amount_reversed / 100 # Amount in cents reversed (can be less than the amount attribute on the transfer if a partial reversal was issued).
- dimension: balance_transaction
type: string
sql: ${TABLE}.balance_transaction
- dimension: bank_account__bank_name
type: string
sql: ${TABLE}.bank_account__bank_name
- dimension: bank_account__country
type: string
sql: ${TABLE}.bank_account__country
- dimension: bank_account__currency
type: string
sql: ${TABLE}.bank_account__currency
- dimension: bank_account__fingerprint
type: string
sql: ${TABLE}.bank_account__fingerprint
- dimension: bank_account__id
type: string
sql: ${TABLE}.bank_account__id
- dimension: bank_account__last4
type: string
sql: ${TABLE}.bank_account__last4
- dimension: bank_account__object
type: string
sql: ${TABLE}.bank_account__object
- dimension: bank_account__routing_number
type: string
sql: ${TABLE}.bank_account__routing_number
- dimension: bank_account__status
type: string
sql: ${TABLE}.bank_account__status
- dimension_group: created
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.created
- dimension: currency
type: string
sql: ${TABLE}.currency
- dimension_group: date
type: time
timeframes: [time, date, week, month]
datatype: epoch
sql: ${TABLE}.date
- dimension: description
type: string
sql: ${TABLE}.description
- dimension: destination
type: string
sql: ${TABLE}.destination
- dimension: livemode
type: yesno
sql: ${TABLE}.livemode
- dimension: object
type: string
sql: ${TABLE}.object
- dimension: reversals__has_more
type: yesno
sql: ${TABLE}.reversals__has_more
- dimension: reversals__object
type: string
sql: ${TABLE}.reversals__object
- dimension: reversals__total_count
type: number
sql: ${TABLE}.reversals__total_count
- dimension: reversals__url
type: string
sql: ${TABLE}.reversals__url
- dimension: reversed
type: yesno
sql: ${TABLE}.reversed
- dimension: source_type
type: string
sql: ${TABLE}.source_type
- dimension: status
type: string
sql: ${TABLE}.status
- dimension: type
type: string
sql: ${TABLE}.type
- measure: count
type: count
drill_fields: [id, bank_account__bank_name]