DATA_LOADERS

Lists all defined data loaders.

Column Name	Column Type	Description
`NAME`	VARCHAR	Loader name.
`SCHEMANAME`	VARCHAR	Schema in which the loader is defined.
`OWNER`	VARCHAR	Vertica 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.

Examples

=> SELECT * FROM DATA_LOADERS;
 name | schemaname |  owner  |             copystmt              | retrylimit | historyretentioninterval
------+------------+---------+-----------------------------------+------------+--------------------------
 dl   | public     | dbadmin | copy sales from 's3://data/*.dat' |           3| 14 days
(1 row)