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
For more information on the topics covered on this page, email us or start a conversation in our Slack community.