Schema Comparison: RudderStack vs. Segment

Detailed schema comparison between the Salesforce RudderStack Cloud Extract Source and the Salesforce Source in Segment.

This guide is useful if you want to migrate your Salesforce source from Segment to RudderStack.

Schema Comparison

In this guide, we compare the schemas of the opportunity table synced by RudderStack and Segment.

RudderStack Columns

Segment Columns

id

id

current_generators_c

-

probability

probability

context_request_ip

-

is_deleted

is_deleted

close_date

close_date

attributes_url

-

last_modified_by_id

last_modified_by_id

context_sources_job_id

-

context_sources_task_id

-

channel

-

name

name

last_modified_date

last_modified_date

forecast_category_name

forecast_category_name

has_opportunity_line_item

has_opportunity_line_item

system_modstamp

system_modstamp

forecast_category

forecast_category

tracking_number_c

-

attributes_type

-

is_won

is_won

lead_source

lead_source

event_text

-

timestamp

-

sent_at

-

expected_revenue

-

amount

amount

created_by_id

created_by_id

original_timestamp

-

owner_id

owner_id

fiscal_year

fiscal_year

order_number_c

-

is_private

-

has_overdue_task

has_overdue_task

loaded_at

loaded_at

context_ip

-

description

description

event

-

has_open_activity

has_open_activity

fiscal

fiscal

user_id

-

stage_name

stage_name

main_competitors_c

-

context_sources_job_run_id

-

fiscal_quarter

fiscal_quarter

type

type

account_id

account_id

created_date

created_date

received_at

received_at

uuid_ts

uuid_ts

delivery_installation_status_c

-

context_sources_task_run_id

-

is_closed

is_closed

A blank value indicates that the column was not sent to the platform.

Since the column names are identical for the Salesforce source in both RudderStack and Segment, the migration should not require any additional coding or modification to the tables.

Here's a high-level summary of the number of columns synced to RudderStack, as compared to Segment:

Columns synced to RudderStack

Columns synced to Segment

Number of common columns

Columns missing in RudderStack

Columns missing in Segment

52

30

30

0

22

Contact Us

If you come across any issues while migrating your Salesforce source to RudderStack, please feel free to contact us. You can also start a conversation on our Slack channel; we will be happy to talk to you!