Difference between revisions of "ETLRoute Table"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
The <code>ETLRoute</code> controls how types of files get routed to ETL exploitation processes. | The <code>ETLRoute</code> 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]] | ||
<syntaxhighlight lang="SQL"> | <syntaxhighlight lang="SQL"> | ||
Revision as of 05:21, 13 June 2020
The ETLRoute 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
CREATE TABLE "ETLRoute" (
"LoadConfigurationID" integer DEFAULT 0 NOT NULL,
"FileTypeID" smallint DEFAULT 0 NOT NULL,
"ETLQueueName" text NOT NULL
);