EXECUTE DATA LOADER FOR KAFKA
EXECUTE DATA LOADER runs a data loader to load new files from a specified path.
EXECUTE DATA LOADER executes a data loader. It attempts to load all data from Kafka topics and partitions mentioned in the copy statement of Create Data Loader for Kafka. By default, executing the loader commits the transaction.
Syntax
EXECUTE DATA LOADER [schema.]name
Arguments
schema
- Schema containing the data loader. The default schema is
public
. name
- Name of the data loader.
Privileges
Read privileges to the source location.
Non-superuser:
- Owner or EXECUTE privilege on the data loader.
- Write privilege on the table.
Example
Execute a data loader once:
=> EXECUTE DATA LOADER sales_dl;
Rows Loaded
-------------
5
(1 row)