Salesforce Docs Portal

Copy a Generated Semantic Query

Use the copied semantic query to access data from your semantic model in Business Intelligence (BI) tools that don't automatically display your semantic model data as a standard table. Before you can copy the semantic query, you must first preview the semantic model and test a query.

Required Editions

Available in: All editions supported by Data 360. See Data 360 edition availability.
User Permissions Needed
To copy a semantic query:

One of these permission sets:

  • Data Cloud Admin
  • Data Cloud Marketing Admin

AND

Semantic Models object
  1. In Data Cloud, on the Semantic Layer tab, select a data model.
  2. At the top-right corner of the Semantic Model Builder, click Test Model.
  3. Prepare the test outline, add filters, and configure other options. See Test a Semantic Model.
    A data preview is generated based on your selected dimensions, measures, and filters. The Copy Semantic Query button becomes available.
  4. You can view the generated semantic query in the Semantic Query Preview tab.
  5. To copy the SQL statement to your clipboard, click Copy Semantic Query.