I believe the table that you actually want to connect to is called datasources, instead of the dataconnections table. More information can be found here: Workgroups Database
Hope this helps!
1 of 1 people found this helpful
You should have read only access to the PostgreSQL database of the Tableau Server repository
Below is the table name and description provided here for those customers who want to query it for information about their Tableau Server usage. This information is provided with a caution that because the purpose of these tables and views is primarily to support Tableau Server, their structure and contents may change without warning and as a result, any custom views built from them may break.
tablename character varying The name of the table in the database that this connection connects to.
You can contact the admin if you don't see the records against table name which you are supposed to see, please see the definition above.
I do not see anything as schema column under this table , remember "their structure and contents may change without warning"
data_connections: Describes various data sources that are included in either workbooks or datasources. Name Type Description id integer Primary key for the record. server text DNS server name to connect to. dbclass character varying Type of data connection (ie mysql, postgres, sqlproxy etc). port integer TCP port number of the connection (eg. 5432 for postgres). username text Username to use when connecting. password boolean True means password is embedded in owner (see owner_type and owner_id fields). name character varying Unique identifier for this data_connection. dbname character varying The database name to which the particular connection is linked. tablename character varying The name of the table in the database that this connection connects to. owner_type character varying One of "Datasource" or "Workbook". It is the type of object making the data connection. owner_id integer The ID of the workbook or datasource that is creating the data connection. created_at timestamp without time zone When this record was created. updated_at timestamp without time zone When this record was last updated. caption character varying Friendly name of this connection as seen in the Desktop data pane. site_id integer A foreign key reference to the site in which this data connection is contained. keychain text Encode string in yaml format. An attribute bag that will match the embedded keychain connection this connection is associated with. luid uuid The locally unique ID, which is intended for exposing externally by the server API. This is automatically generated. has_extract boolean Indicates if the data connection is an extract. datasource_id integer Reference to the Datasource that owns this data connection. db_subclass character varying Subclass of the dbclass, for example, dbclass is webdata-direct, db_subclass is intuit-quickbook
It is a recommended practise to mark the answers accordingly in order to keep our forum clean.
Please mark any of the answer as CORRECT/HELPFUL if it really helped you so that it can help others as well.
Thanks for sharing a detailed response.
I am familiar with the database and its tables and I am the admin and I cannot see any actual table names for the data sources connections.
Do you see table names for your connections?
Is it nulls for both data_connections.tablename and for datasources.table_name.
I have contacted tableau support, but the answer was "there is no support for admin views" .