Keep each record tied to its source ID. Use the references below to choose field owners and preserve relationships between records.
Download the mapping worksheet · CSV, no email required
Reporting dataset
Proposed company table in Snowflake (choose its name) / Account
Plan a company dataset while preserving its source meaning.
Object-specific availability and field permissions determine this mapping. Use the restrictions shown for each record type.
- Snowflake
- Your database schema
- Zoho CRM
- Documented record · ✅ Supported
- Record identity
- Retain the source company ID and the destination customer/company ID. Separate legal entities, subsidiaries, and business units; a shared name or web domain is insufficient.
- Field ownership
- Assign ownership separately for relationship details and finance-controlled billing details.
Fields to include
- Source record ID
- Legal or display name
- Business-unit reference
- Lifecycle status
- Record dependencies
- Resolve parent organizations, business units, and currency references before dependent transactions.
- Validation
- Use two organizations with similar names and one with multiple business units. Verify that an update reaches the intended entity only.
- Recovery
- Repair the cross-system ID relationship before retrying dependent records; do not merge companies solely to remove a sync error.
References: Zoho CRM: Account documentation
Reporting dataset
Proposed contact table in Snowflake (choose its name) / Contact
Plan a contact dataset while preserving its source meaning.
Object-specific availability and field permissions determine this mapping. Use the restrictions shown for each record type.
- Snowflake
- Your database schema
- Zoho CRM
- Documented record · ✅ Supported
- Record identity
- Use a stable person/contact ID and an explicit cross-system lookup. Email can change and can be shared, so treat it as a matching clue rather than a universal key.
- Field ownership
- Keep consent and communication preferences under an agreed authority; a general contact update must not silently resubscribe someone.
Fields to include
- Source person ID
- Display name
- Email address
- Organization reference
- Consent state
- Record dependencies
- Resolve the organization relationship and any owner or consent references required by the destination.
- Validation
- Test an email change, two records sharing an email, and a person associated with multiple organizations.
- Recovery
- Hold ambiguous matches for review and reconcile the person ID before retrying; preserve the consent decision already recorded by its owner.
References: Zoho CRM: Contact documentation
Reporting dataset
Proposed deal or opportunity table in Snowflake (choose its name) / Deal
Plan a deal or opportunity dataset while preserving its source meaning.
Object-specific availability and field permissions determine this mapping. Use the restrictions shown for each record type.
- Snowflake
- Your database schema
- Zoho CRM
- Documented record · ✅ Supported
- Record identity
- Keep the opportunity/deal ID separate from any later order or invoice ID.
- Field ownership
- The sales process owns qualification and stage changes; downstream financial records have their own state and approval rules.
Fields to include
- Source deal ID
- Stage
- Amount and currency
- Expected close date
- Company reference
- Record dependencies
- Map the customer and sales pipeline before the opportunity; map stage values deliberately.
- Validation
- Test a reopened won deal, a stage with no destination equivalent, and an amount using a different currency.
- Recovery
- Suspend downstream creation for a rejected deal and review whether an order already exists before retrying.
References: Zoho CRM: Deal documentation
Reporting dataset
Proposed prospect or lead table in Snowflake (choose its name) / Lead
Plan a prospect or lead dataset while preserving its source meaning.
Object-specific availability and field permissions determine this mapping. Use the restrictions shown for each record type.
- Snowflake
- Your database schema
- Zoho CRM
- Documented record · ✅ Supported
- Record identity
- Retain the lead ID and record its relationship to any converted contact or company.
- Field ownership
- Choose which system may qualify or convert the lead; do not infer identical lifecycle stages.
Fields to include
- Source lead ID
- Qualification status
- Owner reference
- Conversion reference
- Record dependencies
- Resolve owner and campaign references and decide how conversion changes the identity relationship.
- Validation
- Convert a test lead after the first load and verify that it does not create a duplicate person or orphan its activity.
- Recovery
- Repair the lead-to-contact conversion link before replaying later updates.
References: Zoho CRM: Lead documentation
Reporting dataset
Proposed support case or ticket table in Snowflake (choose its name) / Case
Plan a support case or ticket dataset while preserving its source meaning.
Object-specific availability and field permissions determine this mapping. Use the restrictions shown for each record type.
- Snowflake
- Your database schema
- Zoho CRM
- Documented record · ✅ Supported
- Record identity
- Retain the ticket ID and distinguish parent tickets, follow-ups, and merged cases.
- Field ownership
- Agree which queue controls status and assignee; keep private comments distinct from public replies.
Fields to include
- Source ticket ID
- Requester reference
- Status
- Priority
- Assigned team
- Record dependencies
- Resolve requester, organization, team, and status references before ticket updates.
- Validation
- Test a merged ticket, a private note, a reopened case, and an attachment with restricted access.
- Recovery
- Check whether a reply or notification was already sent before replaying ticket actions.
References: Zoho CRM: Case documentation
Reporting dataset
Proposed sales order table in Snowflake (choose its name) / Sales Order
Plan a sales order dataset while preserving its source meaning.
Object-specific availability and field permissions determine this mapping. Use the restrictions shown for each record type.
- Snowflake
- Your database schema
- Zoho CRM
- Documented record · ✅ Supported
- Record identity
- Preserve both the order ID and stable line IDs. Allow one order to relate to several shipments or invoices.
- Field ownership
- Decide which system approves the order and which can cancel or amend it after fulfillment begins.
Fields to include
- Source order ID
- Customer reference
- Line references and quantities
- Order status
- Currency
- Record dependencies
- Create or locate the customer and products first; resolve taxes, currency, and fulfillment references.
- Validation
- Test a multi-line order, a partial cancellation, and two partial shipments. Compare line totals as well as the header.
- Recovery
- Check for an existing destination order before retrying a timed-out create; reconcile line IDs to avoid duplicate fulfillment.
References: Zoho CRM: Sales Order documentation