Creates a writable external web table, campaign_out
, that pipes output data received by the segments to an executable script, to_adreport_etl.sh
:
=# CREATE WRITABLE EXTERNAL WEB TABLE campaign_out
(LIKE campaign)
EXECUTE '/var/unload_scripts/to_adreport_etl.sh'
FORMAT 'TEXT' (DELIMITER '|');
Parent topic: Examples for Creating External Tables