Salesforce Data 360
Query and manage Salesforce Data 360 (formerly Data Cloud): SQL queries, metadata, data model and data lake objects, segments, calculated insights, identity resolution, activations, data streams, and data spaces.
Categories: Marketing, Analytics, CRM
What you can ask
- List every calculated insight that is currently disabled and when each last ran.
- Show the fields on the Individual data model object and which data streams feed it.
- Run the
customer_lifetime_valuecalculated insight and report its status when it completes.
Set up
Salesforce Data 360 connects with credentials from your Salesforce Data 360 account. Have these values ready:
- Instance domain
- Consumer key
- Consumer secret
- Go to Organization > Connectors and find Salesforce Data 360.
- Click Enable and choose which tools to allow.
- Each member enters their own values the first time they use it.
To use one account for the whole organization, turn on Share one connection with everyone. Every member's agents then act as that account, with exactly the access it has.
Tools
Salesforce Data 360 offers 103 tools. Admins choose which ones agents can use. See Tool permission groups.
Read (52)
View and search information without changing it.
| Tool | What it does |
|---|---|
get_activation | Get one activation's full definition by ID. |
get_activation_target | Get one activation target's configuration by ID. |
get_calculated_insight | Get one calculated insight's definition: SQL expression, status, schedule, and derived dimensions and measures. |
get_calculated_insight_status | Get the current run status of a calculated insight (POST refresh-status; changes nothing). |
get_connection | Get one connection by ID. |
get_connection_object_fields | Describe the fields (columns, types, keys) of one source object in a connection. |
get_connector | Get one connector type's metadata, including the parameter and credential names its connections use. |
get_data_action | Get one data action by developer name, including its sources, conditions and targets. |
get_data_action_target | Get one data action target by ID, including its type, status and config. |
get_data_graph_metadata | List the org's data graphs and their schema. |
get_data_graph_record | Get one data graph record by its root record ID, with related records (limit/offset); set live=true for real time. |
get_data_lake_object | Get one DLO's fields and metadata by its __dll API name. |
get_data_model_object | Get one DMO's full schema (fields, category, data space) by its __dlm API name. |
get_data_space | Get one data space's details by API name. |
get_data_stream | Get a data stream's full configuration (connector, DLO, refresh settings) by name. |
get_data_transform | Get one data transform by ID or API name, including its full definition and status. |
get_data_transform_schedule | Get a data transform's run schedule (frequency, interval, time). |
get_dmo_mapping | Get one object mapping's configuration, including its field mappings and their developer names (for delete_field_mapping). |
get_identity_resolution | Get one identity resolution ruleset with its match rules (priority order) and reconciliation rules. |
get_insight_metadata | List calculated insights with their dimensions and measures. |
get_metadata | Describe one DMO, DLO, or calculated insight by API name: fields, primary keys, relationships. |
get_profile_metadata | List profile-enabled DMOs (e.g. ssot__Individual__dlm) with their fields and relationships. |
get_query_rows | Fetch a page of result rows (limit up to 1000, offset) from a query started by query_sql. |
get_query_status | Get the status of a query started by query_sql: completion_status, row_count, and chunk_count. |
get_segment | Get one segment by record ID or API name, including its type, DMO, schedule, and segmentStatus (check for ACTIVE before publishing or activating). |
list_activation_targets | List activation targets (destinations segments are published to) with limit/offset paging. |
list_activations | List activations (segment-to-target publications) with limit/offset paging, optionally in one data space. |
list_calculated_insights | List calculated insights (CIs) with limit/offset paging, optionally in one data space. |
list_connection_objects | List source objects (tables) available through a connection. |
list_connection_schemas | List database schemas available through a database connection (e.g. Snowflake), scoped by advanced_attributes such as the database. Read-only. Use list_connections to find the connection ID, then list_connection_objects to list tables in a schema. |
list_connections | List configured connections of one connector type (required; use list_connectors), filterable by dev_name, label, organization_id and data space, with offset pagination. |
list_connectors | List the connector types in the org's Data 360 catalog (e.g. SalesforceDotCom, SNOWFLAKE). Call this first to get the connector_type that list_connections and get_connection require, or a name for get_connector. |
list_data_action_targets | List data action targets (event destinations such as webhooks) with offset pagination. |
list_data_actions | List data actions (event-triggered rules that send DMO changes to data action targets) with offset pagination. |
list_data_lake_objects | List data lake objects (DLOs, API names ending __dll) with offset paging, filtered by category and data space. |
list_data_model_objects | List data model objects (DMOs, API names ending __dlm) with offset paging, filtered by category and data space and sortable by order_by. |
list_data_space_members | List the data objects that belong to a data space, with their row filters. |
list_data_spaces | List the org's data spaces with limit/offset paging. |
list_data_streams | List data streams (ingestion pipelines into DLOs) with offset paging, filtered by category and data space. |
list_data_transforms | List data transforms (batch or streaming DLO-to-DLO transforms) with offset pagination. |
list_dmo_mappings | List DLO-to-DMO object mappings. |
list_identity_resolutions | List identity resolution rulesets with limit/offset paging, optionally in one data space. |
list_metadata_entities | List metadata entities, optionally of one type (DataModelObject, DataLakeObject, CalculatedInsight), in one response. |
list_segments | List segments with limit/offset paging, optionally in one data space. |
lookup_data_graph | Look up data graph records by natural key (lookup_keys), bounded by limit; set live=true for a real-time graph. |
query_calculated_insight | Read rows (dimensions and measures) of an existing calculated insight with limit/offset pagination. |
query_profile | Read records from a profile DMO (Individual, Account, or custom) with bracketed filters, a field projection, and limit/offset (orderby required when offset > 0). |
query_sql | Run a Data 360 SQL SELECT query (not SOQL) and return up to row_limit rows inline. |
search_metadata | Natural-language search over Data 360 metadata (DMOs, DLOs, calculated insights), optionally filtered by metadata_types. |
validate_calculated_insight | Check a calculated insight's SQL expression without saving it. |
validate_credential | Validate Salesforce Data 360 credentials by listing the org's data spaces. |
validate_data_transform | Validate (and enrich) a data transform definition without creating it; reports issues such as TARGET_DLO_NOT_FOUND. |
Write (14)
Create or send data.
| Tool | What it does |
|---|---|
add_field_mappings | Add field pairs to an existing object mapping (PATCH). |
create_activation | Create an activation that publishes a published segment's members to an activation target, by name (segmentApiName, activationTargetName). |
create_activation_target | Create an activation target. |
create_calculated_insight | Create a calculated insight from ANSI SQL over DMOs. api_name must end with __cio, and COUNT(DISTINCT) is not supported. |
create_data_action | Create a data action that sends events when source DMO records change. |
create_data_action_target | Create a data action target, the destination (e.g. a WebHook endpoint) that data actions send events to. |
create_data_lake_object | Create a DLO directly (data streams usually create their DLO automatically; prefer create_data_stream). |
create_data_model_object | Create a custom DMO. |
create_data_space | Create a data space (an isolated admin workspace) from a label; the platform derives its API name, returned as name (the dataspace value for other tools). |
create_data_stream | Create a data stream and its DLO. |
create_data_transform | Create a data transform from a definition (STL graph or SQL) that writes to a target DLO. |
create_dmo_mapping | Map a DLO to a DMO with field pairs. |
create_identity_resolution | Create an identity resolution ruleset that merges source profiles into unified profiles. |
create_segment | Create a segment on a segmentable DMO. |
Delete or overwrite (37)
Remove or replace existing data.
| Tool | What it does |
|---|---|
add_data_space_members | Add data objects (DLO/DMO API names from list_data_lake_objects or list_data_model_objects) to a data space, optionally with row filters. |
cancel_query | Cancel a running query started by query_sql; its results are discarded. |
deactivate_segment | Deactivate a segment by its API (developer) name, not its record ID, so it stops publishing. |
delete_activation | Permanently delete an activation so the segment stops publishing to its target. |
delete_calculated_insight | Permanently delete a calculated insight. |
delete_data_action | Permanently and irreversibly delete a data action by developer name. |
delete_data_action_target | Permanently delete a data action target. |
delete_data_lake_object | Permanently delete a DLO and its stored data. |
delete_data_model_object | Permanently delete a DMO. |
delete_data_space | Permanently delete a data space and its contents; this cannot be undone. |
delete_data_stream | Delete a data stream. should_delete_data_lake_object chooses whether its DLO and data are deleted too. |
delete_data_transform | Permanently delete a data transform. |
delete_dmo_mapping | Delete an object mapping. |
delete_field_mapping | Delete one field mapping from an object mapping. |
delete_identity_resolution | Permanently delete an identity resolution ruleset; unified profiles it produced may be affected. |
delete_segment | Permanently delete a segment by its API (developer) name, not its record ID. |
disable_calculated_insight | Disable a calculated insight so it stops refreshing; dependent segments and activations may be affected. |
enable_calculated_insight | Enable a calculated insight so it refreshes and can be used by segments and activations. |
publish_identity_resolution | Retry publishing an identity resolution ruleset whose status is Error (rulesets publish automatically on create/update; the API refuses a retry in any other status). |
publish_segment | Publish a segment, starting an asynchronous membership calculation. |
remove_data_space_members | Remove up to 10 members from a data space by name. |
run_calculated_insight | Start a calculation run of a calculated insight now, consuming compute and updating downstream results. |
run_data_stream | Manually trigger ingestion for a data stream. |
run_data_transform | Run a batch data transform now, rewriting its output DLO; consumes org resources. |
run_identity_resolution | Run an identity resolution ruleset now, consuming compute and updating unified profiles. |
set_data_transform_schedule | Set (replace) a data transform's run schedule, e.g. frequency 'Daily', interval 1, 03:00 in a time zone. |
update_activation | Replace an activation's definition (PUT: full replace, so omitted fields are cleared). |
update_activation_target | Update an activation target by ID (PATCH; only given keys change). |
update_calculated_insight | Update a calculated insight's display name, description, SQL expression, or schedule (PATCH; only given fields change). |
update_data_action_target | Update a data action target's label and/or config. |
update_data_lake_object | Add fields to a DLO (PATCH). |
update_data_model_object | Update a DMO (PATCH, partial): label, description, or ADD fields (additive; fields cannot be removed this way). |
update_data_space | Update a data space's label or description (PATCH; only given fields change). |
update_data_stream | Update a data stream (PATCH; only given fields are sent): label, refresh_config, or other keys. |
update_data_transform | Replace a data transform (PUT: a full replace, so send the complete name, label, type and definition; omitted optional fields are cleared). |
update_identity_resolution | Update an identity resolution ruleset (PATCH; only given fields change, but match_rules and reconciliation_rules replace their whole lists). |
update_segment | Update a segment's display name, description, or publish schedule (PATCH). |