Skip to main content
Exporting marketing data from Inflection to your data warehouse enables your marketing, operations, and data teams to build custom reports and run analytics in their BI tools. Track email engagement, journey performance, and form submissions alongside your product and revenue data for comprehensive growth insight

​
Data You Can Export

Inflection allows you to export marketing data (email events, journey activity, and form & inbound webhook submissions) directly to your data warehouse. This makes it easier for your marketing, ops, and data teams to create reports and run analytics in their BI tools. The events and attributes are supported:
All ID columns are accompanied by human-friendly names to make querying and dash-boarding easy.
Journey Completed vs. Journey Exited: Journey Completed is triggered when a record finishes all flow steps in the journey and reaches the end. Journey Exited is triggered when a record meets the journey’s exit criteria and exits the journey.

​
Configure Data Warehouse Export

Inflection currently supports importing data from the following data warehouses:

​
Manage Data Warehouse Export

Once your data export connection is active, you can review its status, manage what data is being synced, and monitor sync activity via:
  • Sync Settings: View sync history, sync errors, monitor record counts, and track export status.
  • Connection Details: Review or edit connection configuration and view SQL snippet used for creating the export tables.

​
Sync Settings

The Sync Details tab gives you visibility into the status and history of all sync activity. Here you can:
  • See next scheduled sync time and the last completed sync duration
  • Track the number of records synced and total tables updated
  • View a sync history table showing:
    • Timestamp of each sync
    • Target table (e.g., Inflection Activities, Entity)
    • Number of rows inserted or updated
    • Count of any errors
  • Filter history by:
    • Date range (via calendar selector)
    • Empty vs. non-empty syncs
You can also pause the entire sync using the Pause Sync button in the top-right corner.

​
Connection Details

The Connection Settings tab shows the credentials and database details configured for your data warehouse export connection. This is where you can review or update your connection setup. Here you’ll find:
  • Connection Credentials
    • Account Name: Your data warehouse account identifier
    • Username: The user Inflection will authenticate as
    • Password: Stored securely and not visible in the UI
  • Database Details
    • Connection Name: Internal name for this export connection
    • Database: The destination database for exported data
    • Schema: The schema where Inflection will write tables
  • Table Creation SQL (Snowflake only)
    • Pre-generated SQL code to create the required tables in your warehouse
    • You can view, copy, or send the SQL to your data team
To update credentials or database information, click Edit Details. The sync will be paused before making changes.

​
Table Schema

Inflection exports two tables to your data warehouse:

​
1. inflection_marketing_activities

This is the main event log table. Each row corresponds to a single marketing activity or event such as an email send, form fill, or journey entry.

​
2. inflection_marketing_entities

This is a supporting table used for mapping IDs in the event table to their corresponding names and types. It improves readability and enables easier joins in BI tools.
entity_type and entity_name can be joined with IDs in the main table to create user-friendly reports and dashboards.

​
Permissions & Security

Inflection only requires table-level permissions for export:
  • INSERT
  • UPDATE
  • DELETE
  • ALTER
We do not require database or schema-level access.
Databricks requires you to grant USE CATALOG and USE SCHEMA permissions to Inflection’s service principal.These don’t give access to your data; they just let Inflection choose the right catalog and schema when running queries.
This ensures you can maintain tight control over what Inflection can access and modify.

​
Example Reports You Can Build

Once your data is in the warehouse, you can use any BI tool to generate reports like:
  • Journey funnel drop-off
  • A/B test performance
  • Email click rates over time
  • Unsubscribes vs. sends (MoM)
  • Cross-journey activity trends

​
Troubleshooting & FAQs

My sync is stuck. What do I do?
  • Check the Sync Health Status on the connection page. Common issues include:
    • Table structure mismatch
    • Missing permissions
    • Connection credentials expired
  • Contact your data team to validate the table setup or re-run the setup script.