Setup Guide

0. Setup Video

This video shows how to do the source and easyconnect setup steps below. https://www.loom.com/share/5fdde1f079514064b467ebe94bfc817a?sid=b7a849f7-4bd6-42c1-a61a-89200249926f

1. Getting a client id and client secret

1. Log into Classy and in the menu, select Apps & Extensions

2. Please enter Application Name: "EasyConnect - Snowflake" and Oauth2 Redirect URI: "https://easyconnectapps.com".

3. After you create your app, you can find it under Your Applications.

4. Select Edit and copy your Client ID and Client Secret.

2. Enter client id and client secret into EasyConnect.

1. In the connector setup form on the left, enter the schema name, client id and client secret.

2. Click Save & Test. EasyConnect will take it from here and sync your Classy data.

(Info) Networking Considerations

These are the I.P's/DNS for this source. Use this video guide if you want to modify the network policy to only include this I.P.

api.classy.org

(Info) Sample Queries

Example query #1: For each fundraising page, query transaction count and donation amount.

select
    fundraising_page_id,
    fundraising_page.title,
    count(*),
    sum(transaction.donation_net_amount)
from
    fundraising_page
left join
    transaction
        using(fundraising_page_id)
group by
    all
order by
    count(*) desc;

Example query #2: Query transactions in near real-time.

select
    fundraising_page_id,
    fundraising_page.title,
    count(*),
    sum(transaction.donation_net_amount)
from
    fundraising_page
left join
    live_transaction as transaction
        using(fundraising_page_id)
group by
    all
order by
    count(*) desc;