EXA_STATISTICS and SYS views not visible in Tableau

andreeroos
SQL-Fighter

Hi.

When using Tableau, even though the schemas EXA_STATISTICS  and SYS  are visible they are empty showing no content at all. All other schemas work fine. The content of these schemas are, however, accessible through custom SQL expressions.

I can access this content fine through other tools (DBeaver) using the same username.

Is there a workaround/setting enable these views in Tableau?

5 REPLIES 5

Lukasz_Obst
Contributor

One workaround would be to create a SYS_TABLEAU and EXA_STATISTICS_TABLEAU schemas, where you create Views which select the desired Tables from SYS and EXA_STATISTICS. This works because tableau doesn't fetch the tables/views in SYS and EXA_STATISTICS but it will fetch it from your custom schema.

przemek
Xpert

Hi,
Which Tableau version do you use? Tableau Online or Tableau Desktop?

You can also use custom SQL in Tableau, that works in any case.

przemek
Xpert

A custom SQL with the system and statistics tables also works with Tableau Online

Tableau_Online_Custom_Query.jpg

przemek
Xpert

Sorry @andreeroos. I'll have to read more carefully next time 😉 You have already written yourself that custom SQL in Tableau works with the system tables.

andreeroos
SQL-Fighter

This is what I've done, but it would be easier if these views were  exposed in their default schemas.