flipsidecrypto2023-06-30 09:12 AM
99
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
›
⌄
with compass_users as (
select
*,
case when is_banned is null then FALSE else is_banned end as clean_is_banned
from BI_ANALYTICS.COMPASS_PROD.USERS
-- where (is_banned is null or is_banned = FALSE)
),
stripe_customers as (
select
to_timestamp(created::string) as created_date,
metadata_gumby_username as gumby_username,
case
when invoice_settings_default_payment_method is null
then FALSE ELSE TRUE END as added_card,
id as stripe_id,
email as stripe_email,
metadata_gumby_id as gumby_id,
metadata_gumby_email as gumby_email
from BI_ANALYTICS.STRIPE_PROD.CUSTOMER
),
gumby_users as (
select
id as gumby_id,
email as gumby_email,
username as gumby_username
from BI_ANALYTICS.VELOCITY_APP_PROD.USERS
),
runs as (
select
qr.user_id,
qr.STARTED_AT,
qr.QUERY_RUNNING_ENDED_AT,
datediff(seconds,qr.STARTED_AT,qr.QUERY_RUNNING_ENDED_AT) as diff
Run a query to Download Data