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:

  • SOURCE
  • TARGET

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:

  • SYSTEM
  • OOTB
  • CUSTOMIZATION

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.