DATA_LOADERS

Lists all defined data loaders.

Column Name	Column Type	Description
`NAME`	VARCHAR	Loader name.
`NAMESPACENAME`	VARCHAR	For Eon Mode databases, namespace in which the loader is defined.
`SCHEMANAME`	VARCHAR	Schema in which the loader is defined. If the schema belongs to a non-default namespace in an Eon Mode database, the schema name is front-qualified with the name of the schema's namespace. For example, `n1.s` refers to schema `s` in namespace `n1`.
`OWNER`	VARCHAR	OpenText™ Analytics Database user who created the loader.
`COPYSTMT`	VARCHAR	COPY statement used by this loader.
`RETRYLIMIT`	INT	Number of times to retry a failed file load. For loaders that do not specify an explicit value, this value is updated if the value of the DataLoaderDefaultRetryLimit configuration parameter changes.
`HISTORYRETENTIONINTERVAL`	INTERVAL	How long to wait before purging rows in the loader's monitoring table. See CREATE DATA LOADER.
`TRIGGER`	VARCHAR	External trigger for this data loader, if any.
`ENABLED`	BOOLEAN	Whether the data loader is enabled. EXECUTE DATA LOADER does not run a disabled data loader.
`iskafka`	BOOLEAN	Indicates whether it is a Kafka data loader.
`CREATE_TIME`	TIMESTAMPTZ	Time when the data loader was created.

Examples

=> SELECT * FROM DATA_LOADERS;
 name | namespacename | schemaname |  owner  |             copystmt              | retrylimit | historyretentioninterval | trigger |enabled | iskafka  |  create_time  
------+------------+---------+-----------------------------------+------------+---------------------------|--------+---------
 dl   |               | public     | dbadmin | copy sales from 's3://data/*.dat' |    3       |           14 days        |         |   t    |     f    | 2025-05-28 03:32:12.867798-04
(1 row)