Query Code Extension Logs by Using the Query API (Beta)

Use the Data 360 Query API to programmatically retrieve logs generated for custom code runs. Logs are stored in the Data Lake Object (DLO) named DataCustomCodeLogs__dll, and you can query them like any other DLO.

Code extension is a pilot or beta service that is subject to the Beta Services Terms at Agreements - Salesforce.com or a written Unified Beta Agreement if executed by Customer, and applicable terms in the Product Terms Directory. Use of this pilot or beta service is at the Customer's sole discretion.
Edition Table
Available in: Developer, Enterprise, Performance, and Unlimited Editions. See Data 360 edition availability.
User Permissions Needed
To query code extension logs by using the Query API:Permission set:
  • Data Cloud Architect
  • Latency: Logs typically appear within a few minutes after code execution. Allow up to about 10 minutes.
  • Message limits: Maximum log message length is 31,072 characters. Longer messages are truncated.

  1. Understand the relevant fields of the DataCustomCodeLogs__dll DLO.

    • EventId__c — DLO primary key for each log record
    • Timestamp__c — Log record timestamp
    • Message__c — Your log message
    • CorrelationId__c — Correlates your custom code logs to Data 360 internal logs
    • DataCustomCodeName__c — Name of the code extension package
    • ProcessDefinitionName__c — Name of the batch data transform that uses the code package
    • ExecutionId__c — Unique identifier for the code execution. More than one CorrelationId__c can share one execution
    • UsedInFeature__c — Feature where the code is used, for example, batch data transform
    • OrgId__c — Org identifier

  2. Create your SQL query to query the DataCustomCodeLogs__dll DLO like any other Data 360 object. See Create sql query.

    Examples

    • Filter by transform (process) name.
    • Filter by code extension package name.
    • Filter by execution ID.
    • Filter by correlation ID.

  3. Check the query status. See Get SQL Query Status.

  4. (Optional) Retrieve additional rows. If your query returns more data than the initial response, retrieve additional rows. See getSqlQueryRows.