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.

SQL

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

Columns

LoadConfigurationID

Denotes which configuration this route belongs. It corresponds to the ID column of the [LoadConfiguration] table. This is also known as Route identifier.

FileTypeID

The type of file. This corresponds to the ID column of the [FileType] table.

ETLQueueName

The name of the queue to receive messages for this file type.;