skills.rest
accelerate-data
accelerate-dataOFFICIAL
Explore all skills by this author →
WebsiteGitHub

salesforce-extraction

Extract Salesforce data into dbt models on Microsoft Fabric.

Updated Mar 16, 2026
Search Tags:#data extraction#dbt#data migration#CDC#salesforce
One-click install
npx skills add https://github.com/accelerate-data/vibedata-official --skill salesforce-extraction
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: salesforce-extraction
Source: https://github.com/accelerate-data/vibedata-official/tree/main/plugins/vibedata-ingestion-skills/skills/salesforce-extraction
Command: npx skills add https://github.com/accelerate-data/vibedata-official --skill salesforce-extraction

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires simple-salesforce, dbt, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill addresses the complexities of Salesforce data extraction, ensuring accurate and efficient data migration into dbt on Microsoft Fabric.

Core Features & Use Cases

  • CDC Timestamp Management: Correctly identifies and utilizes the SystemModstamp field for change data capture, avoiding data loss and inconsistencies.
  • Soft Delete Handling: Ensures that soft-deleted records are captured during extraction, maintaining data integrity.
  • CPQ Integration: Handles CPQ overrides and provides accurate deal values by extracting CPQ-related fields.
  • Record Type Filtering: Filters and extracts data based on Record Types, preventing data mix-ups.
  • Use Case: For organizations looking to modernize their Salesforce data pipelines and ensure data accuracy post-CPQ implementation.

Quick Start

Use the salesforce-extraction skill to extract Opportunities and Accounts from Salesforce into your dbt models on Microsoft Fabric.

Frequently Asked Questions about salesforce-extraction

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I extract Salesforce data into dbt on Microsoft Fabric?▼

To extract Salesforce data into dbt on Microsoft Fabric, use the Salesforce API to pull records and load them into dbt models for transformation. This process ensures precise data migration with CDC timestamp and soft delete management.

Why does my Salesforce CDC data extraction miss soft-deleted records?▼

Salesforce CDC data extraction misses soft-deleted records when the process fails to capture them during extraction. Proper soft delete handling ensures soft-deleted records are accurately captured and migrated, maintaining data integrity.

How do I handle Salesforce CPQ overrides during data migration?▼

Handling Salesforce CPQ overrides during data migration requires extracting CPQ-related fields specifically. This approach ensures accurate deal values are preserved when moving data into dbt models on Microsoft Fabric.

Can I filter Salesforce data extraction by Record Type to prevent data mix-ups?▼

Yes, you can filter Salesforce data extraction by Record Type. Record Type filtering prevents data mix-ups by ensuring only specified record categories are extracted and loaded into your dbt models.

What field should I use for Salesforce CDC timestamp management in dbt?▼

For Salesforce CDC timestamp management in dbt, you should use the SystemModstamp field. Correctly identifying and utilizing SystemModstamp avoids data loss and inconsistencies during change data capture extraction.

Do I need simple-salesforce and dbt to extract data into Microsoft Fabric?▼

Yes, you need simple-salesforce and dbt to extract data into Microsoft Fabric. The simple-salesforce library facilitates the Salesforce API connection, while dbt handles the subsequent data transformation and loading.

Related Skills

Explore More Data & Analytics Skills→
accelerate-dataaccelerate-data

dbt-fabric-patterns

Provide best practices for dbt projects on Microsoft Fabric.

Official
Advanced
AradotsoAradotso
5

snowflake-dbt-airbnb-analytics

Automate ETL workflows with Snowflake, dbt, and Streamlit.

Official
Advanced
accelerate-dataaccelerate-data

elementary-data-quality

Automate anomaly detection and schema validation for Microsoft Fabric data quality monitoring.

Official
Advanced
chicanoandres702chicanoandres702

data-engineering-data-pipeline

Design and orchestrate scalable batch and streaming data pipelines.

Community
Advanced