Overview
This guide demonstrates the simple process for connecting Decagon to your data stack using Fivetran
Requirements
-
Access to the Fivetran portal
-
Decagon API Key
-
The URL of Decagon Google Cloud Function:
-
Access to Destination database
Steps for Integration:
-
Access the Fivetran Portal
- Log in to your Fivetran account.
-
Create a New Connector
- Go to the ‘Connectors’ section, select ‘Create a new connector’, and choose ‘Google Cloud Functions’ as the connector type.
-
Configure the Connector
-
In ‘Destination schema’, specify your target schema for conversation exports.
-
For ‘Function Trigger’, use the provided Google Cloud Function URL:
-
Add a secret named apiKey to securely store your Decagon API key. Note: The “Provide Invoker role to service account” step is pre-configured and can be skipped.
-
The configured connector should look similar to below example:
-
-
Save & Test
-
Verify your setup by saving and testing the connector configuration to ensure it can invoke the Google Cloud Function successfully.
-
Successful configuration should be similar to below example:
-
-
Set up a destination (if not already configured)
- Add a destination of choice
-
Start Initial Sync
- Once the connector and destination has been configured, start an initial sync
-
Verify the table schema
- Once the initial sync is complete, the conversation table schema should be visible on the “Schema” tab (example below)
-
Verify Exported Conversations in the Destination Database
- After completing the initial synchronization, you can confirm the success of the data export by querying the destination database
select * from “destination_schema”.conversation;
Support
If you encounter any issues or have questions during the setup, please contact our team for assistance at support@decagon.ai.