Sample for Searching Data Catalog

[brentarias]

All over the web I've seen suggestions that Glue Data Catalog enables metadata searches....so that for example I could ask for all tables that contain a certain column name or that have a particular comment on a column.

To date I've not seen a single tutorial, sample, guide, how to, cheat sheet or any documentation of any kind that actually shows how to search for a column name in the Glue Data Catalog. The closest I've come is this article which suggests that I can use these keywords when searching Glue Tables:

• column_name
• column_comment
• table_desc

When I try using one of these (e.g. column_name: star*) it always returns nothing, even though I do have tables that have a column named with "star".

This capability is far too basic and obviously needed, and thus warrants having a sample or some documentation created somewhere.

[dzmitry-kankalovich]

Actually I have the same problem and struggling to find examples, specifically - utilizing the Glue API for programmatic access to the Data Catalog.

It would be really helpful to have those.