Setup Guide

0. Setup Video

This video shows how to do the source and easyconnect setup steps below. https://www.loom.com/share/c9a87173250748688ed8d0aa43a944e4?sid=f44bb039-5e32-4605-bc3d-9594343ab262

1. Getting an access token.

  1. First we'll want to login to engagaingnetworks.com account. Then go to your account settings. Image

  2. Click on "Tokens" on the left side navigation bar. Image

  3. Click "create new private token. Image

2. Enter access token into EasyConnect.

  1. In the connector setup form on the left, enter the schema name, and token. Token

  2. Click Save & Test. EasyConnect will take it from here and sync your Engaging Networks 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. 

us.engagingnetworks.app

(Info) Sample Queries

Example #1: Get specific columns from the data and apply types to the data. 

select
    easy_connect__date,
    data['Account ID']::int as account_id,
    data['Address 1']::varchar as address_1,
    data['Campaign Data 1']::varchar as campaign_data_1
from
    easyconnect.engaging_networks.raw;

Example #2: This query will give you every column available. Our suggestion is to take the list and enter it into chatgpt to create a view. 

select
    array_sort(array_union_agg(object_keys(data)))
from
    easyconnect.engaging_networks.raw;