Calendly to Snowflake

The Calendly kit uses the Calendly API to connect, list all events of a specific organization and all users, and load the data into your data warehouse.

This Kit includes…

• Action river to connect to the Calendly “List Event” endpoint

• Action river to connect to the Calendly “List Organization Memberships” endpoint

• Source to Target river to load the Calendly event data into Snowflake

• Source to Target river to load the Calendly organization membership data into Snowflake

• Logic river to orchestrate and schedule the Calendly ingestion

Configuring this Kit for use

Before using this kit, you need to get your Calendly access token: https://developer.calendly.com/how-to-authenticate-with-personal-access-tokens

Environment Variables

In this Kit, there are 3 environment variables that are used to make for dynamic use of target configuration. 

• {db_calendly} is used in all Target configurations and queries as the target database name.

• {schema_calendly} is used in all Target configurations and queries as the target schema name.

• {calendly_organization} is used in the 2 action rivers and allows to retrieve all events and users for this organization – it requires admin/owner privilege (ex: https://api.calendly.com/organizations/ARPDEEDZMDUSIWO1)

• {Calendly_Alert_Group} is used as the alert email address(es) for when a river fails (optional).

Go to the Variables menu on the left side navigation bar and create variables for db_calendly, schema_calendly and calendly_organization. Fill in the values for the Snowflake Database/Schema you'd like the data to land.

Connections

Kits are imported with ‘blank’ source and target connections. In order to use the template, you have two options:

• Swap out blank connections with existing connections

• Add credentials to the blank connections that come with the imported template.

This kit requires a connection with the key "token" and its value

Have questions about this Kit or want more endpoints?

Send an email to helpme@rivery.io with the title “Help – Calendly to Snowflake Kit”