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:
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!
Last updated
Was this helpful?