Convex

This page contains the setup guide and reference information for the Convex destination connector.

Get started with Convex at the Convex website. See your data on the Convex dashboard.

Overview

The Convex destination connector supports Full Refresh Overwrite, Full Refresh Append, Incremental Append, and Incremental Dedup. Note that for Incremental Dedup, Convex does not store a history table like some other destinations that use DBT, but Convex does store a deduped snapshot.

Output schema

Each stream will be output into a table in Convex. Convex's table naming rules apply - table names can only contain letters, digits, and underscores and may not start with an underscore.

Each record is a document in Convex and is assigned _id and _creationTime fields during sync.

Features

Feature	Supported?
Full Refresh Sync	Yes
Incremental - Append Sync	Yes
Incremental - Dedupe Sync	Yes
Replicate Incremental Deletes	Yes
Change Data Capture	Yes

Performance considerations

Take care to use the appropriate sync method and frequency for the quantity of data streaming from the source. Performance may suffer with large, frequent syncs with Full Refresh. Prefer Incremental modes when they are supported and especially for large tables. If you see performance issues, please reach via email to Convex support or on Discord.

Getting started

Requirements

• Convex Account
• Convex Project
• Deploy key

Setup guide

HeroPixelintegration is available to all Convex developers.

On the Convex dashboard, navigate to the project and deployment that you want to sync.

1. Navigate to the Settings tab.
2. Copy the "Deployment URL" from the settings page to the deployment_url field in HeroPixel
3. Click "Generate a deploy key".
4. Copy the generated deploy key into the access_key field in HeroPixel