Skip to content

Schema Mapping Overview

Schema Mapping allows you to choose what data to sync and how it will appear in your destination.

✨ What is Schema Mapping?

When you connect a source (like Salesforce) and destination (like BigQuery), the platform detects all available objects and fields. You decide:

  • Which objects to include (e.g., Accounts, Contacts).
  • Which fields to enable or exclude.
  • Whether to transform data during sync.

✨ Selecting Objects

In the Map Schema step:

  1. Use the search bar to find objects.
  2. Check the boxes to select.
  3. Each object creates a table in the destination.

✨ Mapping Fields

For each object:

  • Field Name: API name in source.
  • Data Type: e.g., String, Number, Date.
  • Include: Toggle on/off.
  • Transformation: Apply formatting or renaming.

Tip: Use Preview Data to see sample records.

✨ Best Practices

  • Review data types to avoid mismatches.
  • Exclude unused fields to improve performance.
  • Document transformations for clarity.

For detailed examples, see Transformations.