Scheduler.Repository.Image

Type

Read/write

Author

Availability

Data provider

Read

Finbourne

Provided with LUSID

The Scheduler.Repository.Image provider enables you to write a Luminesce SQL query that retrieves Docker image data from Scheduler.

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

See also: Scheduler.Repository

select * from Scheduler.Repository.Image where <filter-expression>;
SQL

Scheduler.Repository.Image has parameters that enable you to filter or refine a query.

To list available parameters, their data types, default values, and an explanation for each, run the following query using a suitable tool:

select FieldName, DataType, ParamDefaultValue, Description from Sys.Field where TableName = 'Scheduler.Repository.Image' and FieldType = 'Parameter';
SQL

By default, Scheduler.Repository.Image 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 = 'Scheduler.Repository.Image' and FieldType = 'Column';
SQL

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

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

select * from Scheduler.Repository.Image limit 10
SQL
select Name, PushTime from Scheduler.Repository.Image where Name = 'lusid-upsert-transactions-image'
SQL
select Tags from Scheduler.Repository.Image where Name = 'lusid-upsert-transactions-image'
SQL