CSV file format reference¶
Table Metadata CSV¶
A CSV file to import Table Metadata must have following fields in its header line (the 1st line).
Field Name | Value | Required? |
---|---|---|
DATABASE_NAME | Database Name | Requried |
SCHEMA_NAME | Schema Name | Required |
TABLE_NAME | Table Name | Required |
TABLE_NAME_NLS | Table Name (in NLS) | |
TABLE_COMMENT | Table Comment | |
TAGS | Tags (Comma separated) | |
TABLE_OWNER | Owner |
Table comment can be written in the Markdown format.
DATABASE_NAME,SCHEMA_NAME,TABLE_NAME,TABLE_NAME_NLS,TABLE_COMMENT,TAGS,TABLE_OWNER
ORCL,SCOTT,CUSTOMER,Customer Master,,,
ORCL,SCOTT,LINEITEM,Order Detail,,"TAG1,TAG2",
ORCL,SCOTT,NATION,Country Master,,,
ORCL,SCOTT,ORDERS,Order Transaction,,TAG1,
ORCL,SCOTT,PART,Item Master,,,
ORCL,SCOTT,PARTSUPP,Item-Supplier Bridge Table,,TAG2,
ORCL,SCOTT,REGION,Region Master,,,
ORCL,SCOTT,SUPPLIER,Supplier Master,,TAG2,
Column Metadata CSV¶
A CSV file to import Column Metadata must have following fields in its header line (the 1st line).
Field Name | Value | Required? |
---|---|---|
DATABASE_NAME | Database Name | Required |
SCHEMA_NAME | Schema Name | Required |
TABLE_NAME | Table Name | Required |
COLUMN_NAME | Column Name | Required |
COLUMN_NAME_NLS | Column Name (in NLS) | |
COLUMN_COMMENT | Column Comment | |
FK | Foreign Key References |
Column comment can be written in the Markdown format.
DATABASE_NAME,SCHEMA_NAME,TABLE_NAME,COLUMN_NAME,COLUMN_NAME_NLS,COLUMN_COMMENT,FK
ORCL,SCOTT,CUSTOMER,C_CUSTKEY,Customer ID,,
ORCL,SCOTT,CUSTOMER,C_NAME,Customer Name,,
ORCL,SCOTT,CUSTOMER,C_ADDRESS,Customer Address,,
ORCL,SCOTT,CUSTOMER,C_NATIONKEY,Country Code,,NATION.N_NATIONKEY
ORCL,SCOTT,CUSTOMER,C_PHONE,Phone Number,,
ORCL,SCOTT,CUSTOMER,C_ACCTBAL,Account Balance,,
ORCL,SCOTT,CUSTOMER,C_MKTSEGMENT,Market Segment,,
ORCL,SCOTT,CUSTOMER,C_COMMENT,Comment on this Customer,,
Schema Comment CSV¶
A CSV file to import Schema Comment must have following fields in its header line (the 1st line).
Field Name | Value | Required? |
---|---|---|
DATABASE_NAME | Database Name | Required |
SCHEMA_NAME | Schema Name | Required |
SCHEMA_DESCRIPTION | Short Schema Description | Required |
SCHEMA_COMMENT | Schema Comment | Required |
Schema comment can be written in the Markdown format.
DATABASE_NAME,SCHEMA_NAME,SCHEMA_DESCRIPTION,SCHEMA_COMMENT
ORCL,SCOTT,Schema for FOO BAR,This is SCOTT schema.
Tag Comment CSV¶
A CSV file to import Tag Comment must have following fields in its header line (the 1st line).
Field Name | Value | Required? |
---|---|---|
TAG_NAME | Tag Name | Required |
TAG_DESCRIPTION | Short Tag Description | Required |
TAG_COMMENT | Tag Comment | Required |
Tag comment can be written in the Markdown format.
TAG_NAME,TAG_DESCRIPTION,TAG_COMMENT
TAG1,Data Set AAA,This a comment on TAG1.
Data Mapping CSV¶
If you want to know more about the concept and the details of Data Mapping, please refer:
A CSV file to import Data Mapping must have following fields in its header line (the 1st line).
Field Name | Value | Required? |
---|---|---|
CHANGE_DATE | Changed Date | Required |
DATABASE_NAME | Target Database Name | Required |
SCHEMA_NAME | Target Schema Name | Required |
TABLE_NAME | Target Table Name | Required |
COLUMN_NAME | Target Column Name | |
DATA_TYPE | Data Type | |
PK | Is the column a primary key? | |
NULLABLE | Is the column nullable? | |
SOURCE_DATABASE_NAME | Source Database Name | |
SOURCE_SCHEMA_NAME | Source Schema Name | |
SOURCE_TABLE_NAME | Source Table Name | |
SOURCE_COLUMN_NAME | Source Column Name | |
TRANSFORMATION_CATEGORY | Transformation Category | |
TRANSFORMATION_ROLE | Transformation Rule | |
UPDATED_BY | Updated by |
CR/LF and white space in the TRANSFORMATION_ROLE
field will be converted to <br/>
and
in HTML.
CHANGE_DATE,DATABASE_NAME,SCHEMA_NAME,TABLE_NAME,COLUMN_NAME,DATA_TYPE,PK,NULLABLE,SOURCE_DATABASE_NAME,RECORD_ID,SOURCE_SCHEMA_NAME,SOURCE_TABLE_NAME,SOURCE_COLUMN_NAME,TRANSFORMATION_CATEGORY,TRANSFORMATION_ROLE,UPDATED_BY
2016-12-03,ORCL,SCOTT,ORDERS,O_ORDERDATE,DATE,,,ORCL,AAA01(Application),DWH_AAA,APPLICATION,APP_DT,,TO_CHAR('YYYYMMDD'),snaga
2016-12-03,ORCL,SCOTT,ORDERS,O_ORDERDATE,DATE,,,ORCL,BBB01(Reservation),DWH_BBB,RESERVE,REGIST_DATE,Direct,,snaga
2016-12-03,ORCL,SCOTT,ORDERS,O_ORDERDATE,DATE,,,ORCL,BBB02(Cancel),DWH_BBB,RESERVE,CANCEL_DATE,Direct,,snaga
Business Glossary CSV¶
A CSV file to import Business Glossary must have following fields in its header line (the 1st line).
Field Name | Value | Required? |
---|---|---|
TERM | Business term | Required |
DESCRIPTION_SHORT | Short description | Required |
DESCRIPTION_LONG | Long description | Required |
OWNER | Owner | Required |
CATEGORIES | Category (Camma separated) | |
SYNONYMS | Synonyms (Camma separated) | |
RELATED_TERMS | Related terms (Camma separated) | |
RELATED_ASSETS | Related tables (Camma separated) |
TERM,DESCRIPTION_SHORT,DESCRIPTION_LONG,OWNER,CATEGORIES,SYNONYMS,RELATED_TERMS,RELATED_ASSETS
Customer,Customer (Short description),"# Definition of the Customer (Detailed description)
* Customer
* Supplier
* Account
This field can be written in Markdown.",snaga,Category1,"Customer","Account,Supplier","SCOTT.CUSTOMER,SCOTT.COMPANY, SUPPLIER"
Data Validation Rule CSV¶
A CSV file to import Validation Rules must have following fields in its header line (the 1st line).
Field Name | Value | Required? |
---|---|---|
DATABASE_NAME | Database Name | Required |
SCHEMA_NAME | Schema Name | Required |
TABLE_NAME | Table Name | Required |
COLUMN_NAME | Column Name | Required |
DESCRIPTION | Description | Required |
RULE | Rule Name | Required |
PARAM | 1st parameter | |
PARAM2 | 2nd parameter |
See “Data Validation Rules reference” for more information about Data Validation Rule CSV.