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 in our Slack community; we will be happy to talk to you!