Comeet to Snowflake
The Comeet kit uses the Comeet REST API to retrieve Comeet recruitment data, and load the data into your data warehouse.
This Kit includes…
Action river to connect to the Comeet Recruiting API using the Candidates and Positions endpoints
Source to Target river to load the Comeet data into Snowflake
Configuring this Kit for use
Before using this kit, you need to get your Comeet API Secret & Key. Follow the instructions here.
Environment Variables
In this Kit, there are 3 environment variables that are used to make for dynamic use of target configuration.
{comeet_db} is used in all Target configurations and queries as the target database name.
{comeet_schema} is used in all Target configurations and queries as the target schema name.
{comeet_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 comeet_db, comeet_schema. 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 API secret and key, which can be set in the Logic river variables menu.
Have questions about this Kit or want more endpoints?
Send an email to helpme@rivery.io with the title “Help – Comeet to Snowflake Kit”
Minimize the firefighting. Maximize ROI on pipelines.
