ETLRoute Table

The [ETLRoute] table controls how types of files get routed to ETL exploitation processes. A "route" in Truxton can be thought of a type of load configuration. It controls the path that files will take through the ETL processes in the exploitation layer. The configuration of a load has two parts, the options specified for the Load process to get data into the exploitation layer and the ETL Route which governs which types of files are sent to which message queues.

This table maps a file type to a message queue for a given load configuration.

CREATE TABLE "ETLRoute"
(
    "LoadConfigurationID" integer DEFAULT 0 NOT NULL,
    "FileTypeID" smallint DEFAULT 0 NOT NULL,
    "ETLQueueName" text NOT NULL
);