Skip to main content

Database specifics

For some databases, when extracting table schemas, we need to specify the location of the table and column comments f or some specific databases like DB2, SQL Server or Oracle, if you want to extract the comments in addition to the schemas. Other databases like mysql or Postgresql or sqlserver do not require this information.

For DB2, you can specify the location of the comments in the columnRemarks and 'tableRemarks sections of the configuration file. For example:

metadata/extract/db2_extract.yaml
extract:
  connectionRef: "my_db2_connection" # The database connection to use
  jdbcSchemas:
    - schema: "starbake"
      columnRemarks: SELECT COLUMN_NAME, COLUMN_TEXT FROM "SYSIBM"."SQLCOLUMNS" WHERE TABLE_SCHEM = '{{schema}}' AND TABLE_NAME = '{{table}}'
      tableRemarks: SELECT TABLE_TEXT FROM QSYS2.SYSTABLES WHERE TABLE_SCHEMA = '{{schema}}' AND TABLE_NAME = '{{table}}'
      ...