TAG data persistence in H2 from Connect

[mohitjoshi]

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?

[MichalM]

@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.

[OndrejC · Accepted solution]

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