ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a few hours due to scheduled maintenance starting on Thursday, April 22nd at 5pm MST. Please plan accordingly.

Alteryx Connect Discussions

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

TAG data persistence in H2 from Connect

mohitjoshi
6 - Meteoroid

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

OndrejC
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