Share this page
ETL_GENERATED_ARTIFACT
This table stores generated SQL code and related information of every step while running FlowEngine. This table is under the schema that contains management tables.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
|
Field Name |
Null? |
Field Type |
Field Description |
|---|---|---|---|
|
STREAM_ID |
Not null |
int |
Stream ID |
|
STREAM_TYPE |
Nullable |
Varchar(100) |
Two stream types are supported:
|
|
ETL_STEP |
Nullable |
Varchar(20) |
Should be the same as ETL steps defined in the ETL Template Engine |
|
ARTIFACT_CONTENT |
Nullable |
Varchar(50000) |
Generated SQL |
|
CONTENT_PACK_ID |
Nullable |
int |
Content pack ID |
|
REGISTERED_BY |
Nullable |
VARCHAR(10) |
The following values are supported:
|
|
MD_CREATETIME |
Nullable |
datetime |
Date when the record is created |
|
MD_LASTMODDDATE |
Nullable |
datetime |
Date when the record is updated |
Projections
This table uses no projections.
Sequences
This table uses no sequences.
