Skip to main content

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_value calculated 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
  1. Go to Organization > Connectors and find Salesforce Data 360.
  2. Click Enable and choose which tools to allow.
  3. 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.

ToolWhat it does
get_activationGet one activation's full definition by ID.
get_activation_targetGet one activation target's configuration by ID.
get_calculated_insightGet one calculated insight's definition: SQL expression, status, schedule, and derived dimensions and measures.
get_calculated_insight_statusGet the current run status of a calculated insight (POST refresh-status; changes nothing).
get_connectionGet one connection by ID.
get_connection_object_fieldsDescribe the fields (columns, types, keys) of one source object in a connection.
get_connectorGet one connector type's metadata, including the parameter and credential names its connections use.
get_data_actionGet one data action by developer name, including its sources, conditions and targets.
get_data_action_targetGet one data action target by ID, including its type, status and config.
get_data_graph_metadataList the org's data graphs and their schema.
get_data_graph_recordGet one data graph record by its root record ID, with related records (limit/offset); set live=true for real time.
get_data_lake_objectGet one DLO's fields and metadata by its __dll API name.
get_data_model_objectGet one DMO's full schema (fields, category, data space) by its __dlm API name.
get_data_spaceGet one data space's details by API name.
get_data_streamGet a data stream's full configuration (connector, DLO, refresh settings) by name.
get_data_transformGet one data transform by ID or API name, including its full definition and status.
get_data_transform_scheduleGet a data transform's run schedule (frequency, interval, time).
get_dmo_mappingGet one object mapping's configuration, including its field mappings and their developer names (for delete_field_mapping).
get_identity_resolutionGet one identity resolution ruleset with its match rules (priority order) and reconciliation rules.
get_insight_metadataList calculated insights with their dimensions and measures.
get_metadataDescribe one DMO, DLO, or calculated insight by API name: fields, primary keys, relationships.
get_profile_metadataList profile-enabled DMOs (e.g. ssot__Individual__dlm) with their fields and relationships.
get_query_rowsFetch a page of result rows (limit up to 1000, offset) from a query started by query_sql.
get_query_statusGet the status of a query started by query_sql: completion_status, row_count, and chunk_count.
get_segmentGet one segment by record ID or API name, including its type, DMO, schedule, and segmentStatus (check for ACTIVE before publishing or activating).
list_activation_targetsList activation targets (destinations segments are published to) with limit/offset paging.
list_activationsList activations (segment-to-target publications) with limit/offset paging, optionally in one data space.
list_calculated_insightsList calculated insights (CIs) with limit/offset paging, optionally in one data space.
list_connection_objectsList source objects (tables) available through a connection.
list_connection_schemasList 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_connectionsList configured connections of one connector type (required; use list_connectors), filterable by dev_name, label, organization_id and data space, with offset pagination.
list_connectorsList 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_targetsList data action targets (event destinations such as webhooks) with offset pagination.
list_data_actionsList data actions (event-triggered rules that send DMO changes to data action targets) with offset pagination.
list_data_lake_objectsList data lake objects (DLOs, API names ending __dll) with offset paging, filtered by category and data space.
list_data_model_objectsList 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_membersList the data objects that belong to a data space, with their row filters.
list_data_spacesList the org's data spaces with limit/offset paging.
list_data_streamsList data streams (ingestion pipelines into DLOs) with offset paging, filtered by category and data space.
list_data_transformsList data transforms (batch or streaming DLO-to-DLO transforms) with offset pagination.
list_dmo_mappingsList DLO-to-DMO object mappings.
list_identity_resolutionsList identity resolution rulesets with limit/offset paging, optionally in one data space.
list_metadata_entitiesList metadata entities, optionally of one type (DataModelObject, DataLakeObject, CalculatedInsight), in one response.
list_segmentsList segments with limit/offset paging, optionally in one data space.
lookup_data_graphLook up data graph records by natural key (lookup_keys), bounded by limit; set live=true for a real-time graph.
query_calculated_insightRead rows (dimensions and measures) of an existing calculated insight with limit/offset pagination.
query_profileRead records from a profile DMO (Individual, Account, or custom) with bracketed filters, a field projection, and limit/offset (orderby required when offset > 0).
query_sqlRun a Data 360 SQL SELECT query (not SOQL) and return up to row_limit rows inline.
search_metadataNatural-language search over Data 360 metadata (DMOs, DLOs, calculated insights), optionally filtered by metadata_types.
validate_calculated_insightCheck a calculated insight's SQL expression without saving it.
validate_credentialValidate Salesforce Data 360 credentials by listing the org's data spaces.
validate_data_transformValidate (and enrich) a data transform definition without creating it; reports issues such as TARGET_DLO_NOT_FOUND.

Write (14)​

Create or send data.

ToolWhat it does
add_field_mappingsAdd field pairs to an existing object mapping (PATCH).
create_activationCreate an activation that publishes a published segment's members to an activation target, by name (segmentApiName, activationTargetName).
create_activation_targetCreate an activation target.
create_calculated_insightCreate a calculated insight from ANSI SQL over DMOs. api_name must end with __cio, and COUNT(DISTINCT) is not supported.
create_data_actionCreate a data action that sends events when source DMO records change.
create_data_action_targetCreate a data action target, the destination (e.g. a WebHook endpoint) that data actions send events to.
create_data_lake_objectCreate a DLO directly (data streams usually create their DLO automatically; prefer create_data_stream).
create_data_model_objectCreate a custom DMO.
create_data_spaceCreate 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_streamCreate a data stream and its DLO.
create_data_transformCreate a data transform from a definition (STL graph or SQL) that writes to a target DLO.
create_dmo_mappingMap a DLO to a DMO with field pairs.
create_identity_resolutionCreate an identity resolution ruleset that merges source profiles into unified profiles.
create_segmentCreate a segment on a segmentable DMO.

Delete or overwrite (37)​

Remove or replace existing data.

ToolWhat it does
add_data_space_membersAdd 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_queryCancel a running query started by query_sql; its results are discarded.
deactivate_segmentDeactivate a segment by its API (developer) name, not its record ID, so it stops publishing.
delete_activationPermanently delete an activation so the segment stops publishing to its target.
delete_calculated_insightPermanently delete a calculated insight.
delete_data_actionPermanently and irreversibly delete a data action by developer name.
delete_data_action_targetPermanently delete a data action target.
delete_data_lake_objectPermanently delete a DLO and its stored data.
delete_data_model_objectPermanently delete a DMO.
delete_data_spacePermanently delete a data space and its contents; this cannot be undone.
delete_data_streamDelete a data stream. should_delete_data_lake_object chooses whether its DLO and data are deleted too.
delete_data_transformPermanently delete a data transform.
delete_dmo_mappingDelete an object mapping.
delete_field_mappingDelete one field mapping from an object mapping.
delete_identity_resolutionPermanently delete an identity resolution ruleset; unified profiles it produced may be affected.
delete_segmentPermanently delete a segment by its API (developer) name, not its record ID.
disable_calculated_insightDisable a calculated insight so it stops refreshing; dependent segments and activations may be affected.
enable_calculated_insightEnable a calculated insight so it refreshes and can be used by segments and activations.
publish_identity_resolutionRetry 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_segmentPublish a segment, starting an asynchronous membership calculation.
remove_data_space_membersRemove up to 10 members from a data space by name.
run_calculated_insightStart a calculation run of a calculated insight now, consuming compute and updating downstream results.
run_data_streamManually trigger ingestion for a data stream.
run_data_transformRun a batch data transform now, rewriting its output DLO; consumes org resources.
run_identity_resolutionRun an identity resolution ruleset now, consuming compute and updating unified profiles.
set_data_transform_scheduleSet (replace) a data transform's run schedule, e.g. frequency 'Daily', interval 1, 03:00 in a time zone.
update_activationReplace an activation's definition (PUT: full replace, so omitted fields are cleared).
update_activation_targetUpdate an activation target by ID (PATCH; only given keys change).
update_calculated_insightUpdate a calculated insight's display name, description, SQL expression, or schedule (PATCH; only given fields change).
update_data_action_targetUpdate a data action target's label and/or config.
update_data_lake_objectAdd fields to a DLO (PATCH).
update_data_model_objectUpdate a DMO (PATCH, partial): label, description, or ADD fields (additive; fields cannot be removed this way).
update_data_spaceUpdate a data space's label or description (PATCH; only given fields change).
update_data_streamUpdate a data stream (PATCH; only given fields are sent): label, refresh_config, or other keys.
update_data_transformReplace a data transform (PUT: a full replace, so send the complete name, label, type and definition; omitted optional fields are cleared).
update_identity_resolutionUpdate an identity resolution ruleset (PATCH; only given fields change, but match_rules and reconciliation_rules replace their whole lists).
update_segmentUpdate a segment's display name, description, or publish schedule (PATCH).
⌘J