Troubleshooting Missing Lineage in Oracle Table and Views Integration

troubleshoot
1

Original Slack Thread

Hello,
I am ingesting some oracle tables, and views. ingestion succeeded. However, views are not processed and there’s no lineage.

      "num_view_definitions_failed_parsing": 0,
      "num_view_definitions_failed_column_parsing": 0,
      "view_definitions_parsing_failures": [],```
`source:`
    `type: oracle`
    `config:`
        `host_port: 'oracledb:1531'`
        `username: orclusr`
        `password: '${oracle_pass}'`
        `include_view_lineage: true`
        `include_views: true`
        `include_tables: true`
        `database: ORDB`
        `schema_pattern:`
            `allow:`
                `- app`

any thoughts why I can't see lineage?
2

Hey there! :wave: Make sure your message includes the following information if relevant, so we can help more effectively!

  1. Which DataHub version are you using? (e.g. 0.12.0)
  2. Please post any relevant error logs on the thread!
3

version 0.13

4

Are you seeing the view definitions for those views in the UI?

Also, we’d need the full version number and ingestion logs to debug further

5

I don’t see view definitions of those views. I am using v0.13.2

I see too many WARN level for all of these views:

"WARNING {datahub.ingestion.source.sql.sql_common:1045} - Invalid view identifier: myschema.test_vw"

ingestion spec:

    type: oracle
    config:
        host_port: 'oracldb:1531'
        env: UAT
        username: usr
        password: '${psswd_oracle}'
        include_view_lineage: true
        include_views: true
        include_tables: true
        database: MYDB
        schema_pattern:
            allow:
                - myschema```