community
cancel
Showing results for 
Search instead for 
Did you mean: 

alteryx connect Discussions

Find answers, ask questions, and share expertise about Alteryx Connect.
SOLVED

TAG data persistence in H2 from Connect

I want to extract the details of tags/ Description entered in connect for every table. I have already connected to H2 database, but I did not find any table persisting this data? Can someone help me, where the data (Tags, description etc.) is being persisted in H2?

Alteryx
Alteryx

@mohitjoshi 

 

You can find the H2 Db data dictionary here

https://community.alteryx.com/t5/Alteryx-Connect-Discussions/Connect-Data-Dictionary/td-p/152602

 

The table called ENTRY should contain all objects created in Connect so this would be the best place to check.

Highlighted
Alteryx
Alteryx

Hi @mohitjoshi ,

ENTRY table contains only basic information such as entry name, xid.

You are looking for the description so you need so query ATTRIBUTE table, so in you case if you would like to query for description (added from Connect UI which differs from the "platform description" coming from the source system e.g. database):

 

select * from STD_XFORMS.ATTRIBUTE WHERE ATTR_KEY='description' AND ENTRY_XID='YOUR_ENTRY_XID'

 

Ondrej

Connect Team