ETLRoute Table - Revision history

Sam at 16:14, 24 January 2024

2024-01-24T16:14:47Z

Sam at 12:50, 8 December 2020

2020-12-08T12:50:56Z

Sam at 12:50, 8 December 2020

2020-12-08T12:50:46Z

Sam at 09:29, 13 June 2020

2020-06-13T09:29:25Z

Sam at 09:21, 13 June 2020

2020-06-13T09:21:26Z

Sam at 10:21, 26 May 2020

2020-05-26T10:21:00Z

Sam: Created page with " CREATE TABLE "ETLRoute" ( "LoadConfigurationID" integer DEFAULT 0 NOT NULL, "FileTypeID" smallint DEFAULT 0 NOT NULL, "ETLQueueName" t..."

2020-05-26T10:19:50Z

Created page with "<syntaxhighlight lang="SQL"> CREATE TABLE "ETLRoute" ( "LoadConfigurationID" integer DEFAULT 0 NOT NULL, "FileTypeID" smallint DEFAULT 0 NOT NULL, "ETLQueueName" t..."

New page

<syntaxhighlight lang="SQL">
CREATE TABLE "ETLRoute" (
"LoadConfigurationID" integer DEFAULT 0 NOT NULL,
"FileTypeID" smallint DEFAULT 0 NOT NULL,
"ETLQueueName" text NOT NULL
);
</syntaxhighlight>

@@ Line 6: / Line 6: @@
 This table maps a file type to a message queue for a given load configuration.
 <source lang="SQL">
 CREATE TABLE "ETLRoute"
@@ Line 14: / Line 15: @@
 );
 </source>

@@ Line 1: / Line 1: @@
-The <code>ETLRoute</code> controls how types of files get routed to ETL exploitation processes.
+The <code>[ETLRoute]</code> 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.
@@ Line 6: / Line 6: @@
 This table maps a file type to a message queue for a given load configuration.
-<syntaxhighlight lang="SQL">
+<source lang="SQL">
-CREATE TABLE "ETLRoute" (
+CREATE TABLE "ETLRoute"
      "LoadConfigurationID" integer DEFAULT 0 NOT NULL,
      "FileTypeID" smallint DEFAULT 0 NOT NULL,
      "ETLQueueName" text NOT NULL
 );
-</syntaxhighlight>
+</source>

@@ Line 2: / Line 2: @@
 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]]
+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.
 <syntaxhighlight lang="SQL">

← Older revision		Revision as of 09:21, 13 June 2020
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">

← Older revision		Revision as of 10:21, 26 May 2020
Line 1:		Line 1:
		+	The <code>ETLRoute</code> controls how types of files get routed to ETL exploitation processes.
		+
	<syntaxhighlight lang="SQL">		<syntaxhighlight lang="SQL">
	CREATE TABLE "ETLRoute" (		CREATE TABLE "ETLRoute" (