My team is looking for the capability to see and save queries that have been ran against a dataset. I see that there is a “Queries” tab, but it is always greyed out. Can someone explain what is contained in this tab? Thank you!

Hi @high-house-83395! This tab will contain queries that have recently run against your table if the data source you're connecting to supports it. I don't believe we currently support extracting example queries from Postgres as of today, but @gray-shoe-75895 can verify. This would in theory accommodate the "see queries" ask about but not necessarily the "save queries" feature. Can you speak to this a bit more? cc @little-megabyte-1074 for any new feature requests that come of this!

Yep our postgres source does not support usage/query history

@gray-shoe-75895 Does it support it for Snowflake?

Yes! You can use the snowflake source to ingest usage data - see here https://datahubproject.io/docs/generated/ingestion/sources/snowflake/#module-snowflake-beta for docs

hello people, I'm also interested in this. @gray-shoe-75895 do you know if there are plans to make usage/query history available for Postgres? And also the same question for Hive

Yes we definitely hear you - the main issue is on the technical side: I don’t think they actually collect usage/query history, and so we don’t really have a good place to pull that data from. Snowflake has

QUERY_HISTORY

and

ACCESS_HISTORY

tables which is why we can fetch this information for snowflake. Until we have an analogous system on the postgres/hive side, there’s not much we can do 😞

@gray-shoe-75895 oh I see, That's sad. But maybe you could make it possible to add examplary queries to such sources manually in Datahub?

@elegant-salesmen-99143 it should already be possible to add example queries manually, although I don’t think we have any good examples yet. Out of curiosity, where are you planning on pulling example queries from?