Tableau-Server-Postgres-Queries
Tableau-Server-Postgres-Queries copied to clipboard
List of all Tableau Server Postgres DB Tables, Joins and Fields
I couldn't find anything in the Tableau data dictionary about how long the data is stored for [nviews]. When pulling from "views_stats" the date that is presented (as the [time]...
It seems orphan datasource is incorrect as it only gives output for connected. Please correct
Msg 156, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'FROM'. ===================================== SELECT DISTINCT T28.created_at AS "Started", CAST(EXTRACT(SECOND FROM (T28.completed_at - T28.created_at)) AS INT) AS "Runtime_Seconds", T28.notes...
Theres 2 inner joins on here I have commented out as else it doesn't work.. adding one reduced the record count which is incorrect and the checksum one cuts all...