flipsidecrypto2023-06-30 09:12 AM
    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