Exporting Data

Available to: All users (with permission on the domain) Minimum plan: Free

TitanRDM lets you export reference data from any deployed table to a CSV file. Exports can be triggered through the UI or programmatically via the API/SDK. Two export patterns are available: full (all records) and incremental (only records changed since a given timestamp).

Note: Only Full export is currently available. Incremental export is a future feature.

Export data page

Export Patterns

PatternWhat It ExportsUse Case
FullAll non-deleted records in the table.One-off downloads, initial loads for downstream systems, backups.
IncrementalOnly records created, updated, or deleted since the high water mark timestamp. Includes a transaction code column (i = insert, u = update, d = delete).Ongoing synchronisation with downstream systems, change data capture pipelines.

Exporting via the UI

Step 1: Navigate to the Export Page

From the data grid for your table:

  1. Click the Export Data button in the header bar

Step 2: Select the Export Pattern

  1. Choose Full Export or Incremental Export from the dropdown

Step 3: Set the High Water Mark (Incremental Only)

If you selected Incremental Export:

  1. A date-time picker appears
  2. Enter the timestamp from which you want changes — only records with trdm_updated_at after this timestamp will be included
  3. Deleted records (those with trdm_is_deleted = true and updated after the high water mark) are included with a d transaction code

Tip: Use the completion timestamp of your last export as the high water mark to capture all changes since then.

Step 4: Start the Export

  1. Click Start Export
  2. The export job is queued and begins processing in the background
  3. A success message appears with a link to the Export History page

Export started

Step 5: Download the File

  1. Navigate to the Export History page (from the success message link, or via the table header breadcrumb)
  2. Wait for the export status to change to Ready
  3. Click the Download link to save the CSV file

Export History

From any table's data grid, click Export History in the breadcrumb to see all exports for that table.

The export history list shows:

ColumnDescription
StatusCurrent status with a colour-coded badge
PatternFull or Incremental
Correlation CodeIdentifier linking related exports (auto-generated for UI exports, custom for API exports)
StartedWhen the export job began
ReadyWhen the export generation finished
DownloadLink to download the CSV file (appears when ready)

The list supports filtering by status and correlation code, and sorting by status, created date, started date, or completed date.

Export history page

Export Statuses

StatusMeaning
StartedThe export job has been queued and is running.
ReadyThe CSV file has been generated and is ready for download.
FailedAn error occurred during export generation.

Exported File Format

Exports produce a CSV file with:

  • A header row containing column names
  • One row per record
  • All user-defined columns from the table definition
  • System columns: trdm_sk, trdm_created_at, trdm_updated_at, trdm_updated_by, trdm_is_deleted
  • For incremental exports: an additional trdm_transaction_code column (i, u, or d)

Correlation Codes

Every export has a correlation code — a unique identifier for tracking. For UI-initiated exports, this is auto-generated (e.g., manual_export_a1b2c3d4). For SDK/API-initiated exports, you supply your own code, which is useful for tracing exports through your data pipeline.

Usage and Limits

Exports initiated via the SDK/API and UI count towards your plan's SDK Import/Export runs allowance. Export files are only temporary and don't consume storage.

PlanSDK Import/Export Runs
Free100/month
Team3,000/month
Business6,000/month
EnterpriseCustom

See Plans and Tiers for details on limits and overage billing.

SDK/API Exports

For programmatic exports, TitanRDM provides REST API endpoints to:

  1. Trigger an export — specify the table, branch, pattern, and (for incremental) high water mark
  2. Poll for status — check when the export has completed
  3. Download the file — retrieve the generated CSV via a presigned URL

This is covered in detail in SDK Imports and Exports.

Related Pages