Query Data in Data Cloud

Learn how to programmatically query your data in Data Cloud using various APIs and tools.

Data Cloud provides multiple ways to query your data:

  • Query APIs: Execute SQL queries against your data using Query API V1 or V2
  • Profile API: Look up and search customer profile information
  • DataGraph APIs: Query metadata and data from data graphs
  • Calculated Insights API: Extract insights from your data
  • Python Connector: Use Python to analyze Data Cloud data in Pandas DataFrames

Key Features 

  • Query API

    • A powerful API for querying and analyzing data in Data Cloud using SQL

  • Profile API

    • Look up and search customer profile information
    • Integrate with external web or mobile apps
    • Access profile data model objects

  • Metadata API

    • Retrieve metadata about all entities
    • Access information about Calculated Insights, Engagement, Profile, and other entities
    • View relationships between objects and key qualifier fields

  • Python Connector

    • Extract data into Python Pandas DataFrames
    • Create visual data models
    • Perform analytical operations
    • Build machine learning and AI models

  • JDBC Driver

    • Connect to Data Cloud using standard JDBC interfaces
    • Query data using SQL tools and applications
    • Integrate with Java applications and SQL clients like DBeaver

  • Calculated Insights API

    • Query Calculated Insights with SQL dimensions and measures
    • Apply optional filters
    • Extract insights from your data

  • Webhook Data Action Targets

    • Send Data Cloud data action events to webhook targets
    • Protect message integrity with Salesforce-generated secret keys
    • Validate payload requests with signature-based authentication

  • Universal ID Lookup

    • Retrieve all individual records associated with a unified record
    • Query across different data sources

  • DataGraph Overview

    • Learn about DataGraph APIs
    • Understand data graph concepts and usage

Getting Started 

  1. Get Started with Querying Data Cloud Data

    • Learn about apps, APIs, libraries, and SQL for querying data
    • Understand the basics of data extraction

  2. API Limits

    • Review limits for Profile, Query, and Calculated Insights APIs
    • Understand rate limits and best practices

  3. Query Services Status Codes

    • Reference status codes for Query API V1 and V2
    • Troubleshoot common issues

Clouds with binary code floating aboveCloud with binary code floating above

No Results

Search Tips:

  • Please consider misspellings
  • Try different search keywords
Data Cloud Reference Guide
Connect Data
Ingest Data
Model Data in Data Cloud
Query Data
Webhook Data Action Targets in Data Cloud