skills.rest
forcedotcom
forcedotcomOFFICIAL
Explore all skills by this author →
Website𝕏@salesforcedevsGitHub

retrieving-datacloud

Execute Data Cloud SQL queries and describe DMO/DLO tables.

803|289|Updated Nov 7, 2025
Search Tags:#vector search#hybrid search#search index#retrieve#metadata introspection#data cloud#sqlv2
One-click install
npx skills add https://github.com/forcedotcom/sf-skills --skill retrieving-datacloud
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: retrieving-datacloud
Source: https://github.com/forcedotcom/sf-skills/tree/main/skills/retrieving-datacloud
Command: npx skills add https://github.com/forcedotcom/sf-skills --skill retrieving-datacloud

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

It helps you retrieve Salesforce Data Cloud data and metadata by turning Data Cloud SQL, search, and introspection requests into correct, validated query executions instead of guessing tables, fields, or index readiness.

Core Features & Use Cases

  • Data Cloud SQL retrieval: Executes quick counts and paginated or async SQL workflows for Data Cloud DMO data.
  • Table/metadata introspection: Uses Data Cloud describe to validate schema before you write or adjust SQL.
  • Vector, hybrid, and index lifecycle support: Runs vector or hybrid search (with optional prefilters) and inspects search-index availability for troubleshooting.
  • Operational guardrails: Applies a retrieve-phase readiness check via the shared orchestrating classifier to reduce failures and misdirected tooling.

Quick Start

Ask your AI to retrieve the Data Cloud table schema and run a count query for unified profiles in your org alias you specify.

Frequently Asked Questions about retrieving-datacloud

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

FAQPage Schema
How do I query and retrieve data from Salesforce Data Cloud DMO objects?▼

You validate Data Cloud tables by using the table describe operation to introspect DMO and DLO objects. This describe-first validation ensures you know the exact schema and index availability before composing SQL queries or search requests.

Can I run vector and hybrid search with prefilters in Data Cloud?▼

Yes, you can execute vector and hybrid search in Data Cloud with optional prefilters to narrow results. The Skill also supports search-index listing and inspection workflows to help troubleshoot index availability and readiness before querying.

How do I validate Data Cloud table schema before writing SQL queries?▼

You validate Data Cloud tables by using the table describe operation to introspect DMO and DLO objects. This describe-first validation ensures you know the exact schema and index availability before composing SQL queries or search requests.

What is the retrieve-phase readiness check for Data Cloud queries?▼

The retrieve-phase readiness check is a diagnostic classification script from the shared orchestrating classifier. It evaluates your Data Cloud environment to reduce failures and misdirected tooling before executing SQL, vector search, or introspection operations.

Does this Skill handle standard CRM SOQL queries outside of Data Cloud?▼

No, this Skill does not handle standard CRM SOQL queries. It specifically delegates standard CRM SOQL elsewhere and focuses exclusively on Data Cloud SQL, async query lifecycles, vector search, and metadata introspection for DMO and DLO objects.

Related Skills

Explore More Data & Analytics Skills→
forcedotcomforcedotcom
803

segmenting-datacloud

Create, publish, and validate Salesforce Data Cloud segments and calculated insights.

Official
Intermediate
padjeipadjei

data360-query

Execute SQL, paginated SQL, async queries, and vector searches in Salesforce Data Cloud.

Community
Advanced
salesforce-miscsalesforce-misc
4

refresh-data-streams

Automate sequential Data Cloud Data Stream refreshes via Playwright browser automation.

Official
Advanced
angryracoonangryracoon

data360-query

Query Salesforce Data Cloud with SQL and inspect search indexes.

Community
Advanced