DecisionTableDatasetLink Metadata Type in SFDX

Architectural Overview#

The DecisionTableDatasetLink metadata type creates an architectural bridge between a DecisionTable definition and a backing data store, such as a CRM Analytics dataset, Data Cloud data lake object, or high-volume custom dataset. In enterprise architectures managing millions of rate schedules or eligibility records, querying standard transactional sObjects directly can exhaust governor limits or lead to index degradation.

By decoupling the logical decision definition from the underlying data warehouse or analytical dataset, DecisionTableDatasetLink allows architects to optimize data ingestion and indexing schedules independently of application business logic.

SFDX Directory and File Suffix#

Key Metadata Fields#

Declarative XML and Package.xml Examples#

DecisionTableDatasetLink Metadata File#

<?xml version="1.0" encoding="UTF-8"?>
<DecisionTableDatasetLink xmlns="http://soap.sforce.com/2006/04/metadata">
    <dataset>Insurance_Actuarial_Rates_DS</dataset>
    <decisionTable>Underwriting_Rate_Table</decisionTable>
    <description>Links the underwriting decision table to the actuarial risk rates dataset.</description>
    <masterLabel>Premium Rate Dataset Link</masterLabel>
    <status>Active</status>
</DecisionTableDatasetLink>

package.xml Manifest#

<?xml version="1.0" encoding="UTF-8"?>
<Package xmlns="http://soap.sforce.com/2006/04/metadata">
    <types>
        <members>Premium_Rate_Dataset_Link</members>
        <name>DecisionTableDatasetLink</name>
    </types>
    <version>68.0</version>
</Package>

SFDX CLI Retrieval and Deployment Commands#

Retrieve and deploy dataset links across environments:

# Retrieve all dataset link components
sf project retrieve start --metadata "DecisionTableDatasetLink" --target-org analytics-dev

# Deploy the decision table and its dataset link simultaneously
sf project deploy start \
  --metadata "DecisionTable:Underwriting_Rate_Table,DecisionTableDatasetLink:Premium_Rate_Dataset_Link" \
  --target-org uat-env

# Query linked decision tables via Tooling API
sf data query --use-tooling-api --query "SELECT Id, DeveloperName, DecisionTableId, Status FROM DecisionTableDatasetLink" --target-org uat-env

Senior Architect Best Practices and Gotchas#

• Dependency Ordering in Manifests: In automated CI pipelines, package DecisionTable before DecisionTableDatasetLink or ensure both are deployed in an atomic single-transaction deployment.
• Monitoring Query Latency: Monitor execution times in Event Monitoring when decision tables evaluate multi-gigabyte linked datasets to ensure platform transaction timeouts are not exceeded.

Frequently asked questions

Why use DecisionTableDatasetLink instead of querying sObjects directly?

It offloads complex decision evaluation from standard relational transactional tables to pre-aggregated, indexed analytical datasets for millisecond lookups.

Where are DecisionTableDatasetLink files stored in a Salesforce DX project?

They are stored in force-app/main/default/decisionTableDatasetLinks with the file suffix .decisionTableDatasetLink-meta.xml.

What happens when the linked dataset schema changes?

Schema changes in the underlying dataset require updating the DecisionTable parameter mappings before re-deploying the link metadata.