Skip to main content

Tableau Performance: Reading from constraint_columns

  • July 16, 2015
  • 1 reply
  • 11 views

jkoskeladev

Hi,

I work for Tableau and we need to collect metadata about unique constraints/primary keys.

The ODBC driver doesn't implement the API which we usually use to collect this information (SQLStatistics).

So we are querying the constraint_columns view directly.

 

This view reads from two tables:

v_internal.vs_constraint_columns

and

v_internal.vs_columns

 

We don't need the information from the second table (not null contraints).

I wanted to know if it is safe to read the information from v_internal.vs_constraint_columns.

 

Is the schema for this table subject to change?

 

1 reply

Connyrt-emp
  • New Participant
  • July 21, 2015

Hi, This is Norma and I have worked with you in the past on the integration. I will reach out to you via email to work on this implementation. Thank you