DATA_LOADER_EVENTS

Lists events from all data loaders.

Lists load events from all data loaders, including the file path, whether the load succeeded, and how many times it has been retried. You must own or have any privilege (EXECUTE, ALTER, or DROP) on a data loader to see its events in this table.

To prevent unbounded growth, records in this table are purged periodically. You can set the purge frequency for individual data loaders when creating or altering the loader. See CREATE DATA LOADER and ALTER DATA LOADER. The default is 14 days.

For SQS errors that precede data load, such as authorization errors or malformed SQS events, see SQS_LISTENER_ERROR_HISTORY.

Column Name	Column Type	Description
`DATA_LOADER_NAMESPACE`	VARCHAR	For Eon Mode databases, namespace of the data loader that performed this load.
`DATA_LOADER_SCHEMA`	VARCHAR	Schema for the data loader that performed this load. 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`.
`DATA_LOADER_NAME`	VARCHAR	Name of the data loader that performed this load.
`TIME_STAMP`	TIMESTAMPTZ	Time when Vertica recorded the event.
`FILE_NAME`	VARCHAR	Path that was loaded (or attempted).
`TRANSACTION_ID`	VARCHAR	Unique identifier for the transaction in which the load occurred.
`LOAD_STATUS`	VARCHAR	`OK` if the load succeeded or `FAIL` if it did not.
`ROWS_LOADED`	INTEGER	If a single file was loaded, the number of rows. If more than one file was loaded in a single batch, this value is null. For batch loads, `FILE_SIZE_BYTES` can be helpful in place of row counts.
`FAILURE_REASON`	VARCHAR	If the load failed, an explanatory message.
`RETRY_ATTEMPT`	INTEGER	0 if this was the first attempt to load the file, otherwise the number of retries including this one.
`FILE_SIZE_BYTES`	INTEGER	File size in bytes when the data loader was executed.
`BATCH_ID`	INTEGER	Identifier, unique within the transaction, for the batch this file was part of. If a file was loaded individually, this value is null.