Missing Tables in "Table or Database View" but Accessible via "Database Query

Options
Karthik_Anbusekar
Karthik_Anbusekar
in General

Hi community,

I successfully created an external system connection to a database schema, including credentials. However, when I try to create a dataset using the "Table or Database View" option, I notice that some tables are missing from the list.

Interestingly, I am able to access and query those missing tables using the "Database Query" option without any issues.

Has anyone else experienced this? Are there any known limitations or configurations that might cause certain tables to be hidden in the "Table or Database View" interface?

Any insights would be appreciated!

Tagged:

Comments

  • Josh Boxer
    Josh Boxer Administrator

    Hello, it is probably this:

    https://community.experianaperture.io/discussion/comment/1811#Comment_1811

    Difficult to comment further without more information. The type of Database / table or dbView / jdbc driver and version etc.

  • henry_
    henry_

    Data Studio itself is very unlikely to be filtering out specific tables or views when using Create Dataset, so it's going to be down to a JDBC driver config or setting.

    I've seen some drivers hide sys tables by default although there's usually a connection property that reveals them.

    It could also be that the driver settings include a fixed DB schema, which is being used to return tables, but your DB credentials have access to multiple schemas, allowing you broader querying.

    I'd recommend looking at the driver's documentation (specific schema settings and related connection properties) for more. If you're using a native driver, you may find the documentation link here: https://docs.experianaperture.io/data-quality/aperture-data-studio/configuration/configure-external-systems/#jdbcconnectiontroubleshooting~jdbc-databases

Categories