Query Code Extension Logs by Using Query Editor (Beta)
Use Query Editor in Data 360 to view 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.
You can also use Data Explorer to view custom code logs saved in the DLO named DataCustomCodeLogs__dll. See View Your Data in Data Explorer.
| 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 Query Editor: | Permission set:
|
- Data 360 access and permission to use Query Editor in your org
- A completed batch transform execution
- Latency: Logs typically appear within a few minutes after code execution. Allow up to about 10 minutes.
- Message limits: The maximum log message length is 31,072 characters. Longer messages are truncated.
- In Data 360, go to Query Editor.
- Select a workspace or create one. The workspace defines the objects and metadata that the query can access.
- In the left pane, click Data Lake Objects.
- Use the search box to find
DataCustomCodeLogsor scroll through the list to locate and select it. - Review the
DataCustomCodeLogs__dlltable to understand the relevant fields.
| Field (API Name) | Description | Data type |
|---|---|---|
EventId__c | DLO primary key for each log record | UUID |
Timestamp__c | Log record timestamp | Datetime |
Message__c | Your log message | Text |
CorrelationId__c | Correlates your custom code logs to Data 360 internal logs | UUID |
ExecutionId__c | Unique identifier for the code execution; multiple CorrelationId__c can share one execution | UUID |
DataCustomCodeName__c | Code extension package name | Text |
ProcessDefinitionName__c | Name of the batch data transform that uses the code package | Text |
UsedInFeature__c | Feature where the code is used, for example, batch data transform | Text |
OrgId__c | Org identifier | Text |
- From the
DataCustomCodeLogsDLO dropdown, select how to create the query. - Build a query based on your requirement by using the relevant fields of the
DataCustomCodeLogsDLO. The editor suggests fields as you build the query. For information on building a SQL query in Data 360, see Get Started with Data 360 SQL. - Click Run Query to view the results. To keep the query for future reference, click Save.
- Filter by transform (process) name.
- Filter by code extension package name.
- Filter by execution ID (exact run).
- Filter logs from the last 60 minutes.