Opportunity Schema Comparison

Opportunity schema comparison

Cross-platform field analysis · Salesforce Production · Snowflake · Data Cloud

36

Salesforce fields

3

Snowflake columns

22

Data Cloud fields

11

Matched across SF + DC

Field distribution by platform coverage

Platform field summary

Salesforce Production

36 fields

10 custom fields

Standard + custom (__c) fields

Snowflake Mirror

3 fields

Partial DDL — only 3 columns visible in metadata

Data Cloud (ssot__)

22 fields

Standardised ssot__ namespace fields

Snowflake DDL unavailable

The Snowflake table DDL returned empty. Only 3 columns were discoverable via metadata search, so the comparison below under-reports Snowflake coverage.

Key findings

SF → DC coverage

11 fields resolve to the same concept in Salesforce and Data Cloud. Data Cloud uses the ssot__ namespace and renames several concepts (Amount → ssot__TotalAmount__c).

Naming convention gap

Salesforce uses PascalCase, Data Cloud uses ssot__PascalCase__c, Snowflake uses SCREAMING_SNAKE_CASE with an SF_ prefix. No two platforms agree.

Type mismatches

3 matched fields carry different types across platforms — mostly Checkbox → STRING and Date → DATE_TIME.