Integration.Log

The Integration.Log provider enables you to write a Luminesce SQL query that retrieves log details for runs of an integration instance.

Note: The LUSID user running the query must have sufficient access control permissions to both use the provider and read log data for integration runs. This should automatically be the case if you are the domain owner.

See also: Integration.Run, Integration.Dashboard, Integration.Execute

Basic usage

select * from Integration.Log where <filter-expression>;

Data fields

By default, Integration.Log returns a table of data populated with particular fields (columns). You can return a subset of these fields.

To list fields available to return, their data types, whether fields are considered 'main', and an explanation for each, run the following query using a suitable tool:

select FieldName, DataType, IsMain, IsPrimaryKey, SampleValues, Description from Sys.Field where TableName = 'Integration.Log' and FieldType = 'Column';

Note: Fields marked 'main' are returned by queries that include a caret character, for example select ^ from Integration.Log.

Examples

Note: For more example Luminesce SQL queries, visit our Github repo.

Example 1: Retrieve first 10 integration run logs

select * from Integration.Log limit 10

Example 2: Retrieve all logs for a particular run of an integration instance

select * from Integration.Log where RunId = '015c7176-79f7-465a-b28e-7ad52503389d'

Example 3: Retrieve data mapping errors for a particular day

select Description,
  SourceAttributeName
  SourceAttributeValue
  SourcePrimaryIdType
  SourcePrimaryIdValue
  TargetAttributeName
  TargetAttributeValue
  TargetPrimaryIdType
  TargetPrimaryIdValue
from Integration.Log
where Status = 'AttributeFailed' 
  and FirstActivity >= #2025-09-25#