Tableau Performance: Reading from constraint_columns

jkoskeladevjkoskeladev
in General Discussion

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?

 

Comments

  • Connyrt-empConnyrt-emp

    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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...