By using AWS re:Post, you agree to the Terms of Use
/AWS Glue Catalog Table Name Cannot Be Searched By Full Text/

AWS Glue Catalog Table Name Cannot Be Searched By Full Text

0

Service Name: AWS Glue

Situation: When I search for table in Glue Data Catalog by input a part of table name in web UI search box, the result is not showed correctly. For example;

NameDatabaseLocation
mqtt_aaplmydbmylocation
mqtt_googmydbmylocation
mqtt_teslamydbmylocation
kafka_stockmyrealtimemylocation

And I typed "mqtt" , it returns inconsistent result

  1. Show only top of list e.g. only "mqtt_aapl"

  2. Show all tables in catalog including "kafka_stock"

  3. Show nothing

Expectation:

  1. When I typed "mqtt", it should return 3 items of list "mqtt_aapl", "mqtt_goog" and "mqtt_tesla"

  2. When I typed "stock" it should return only "kafka_stock"

Please help to figure out how I can deal with this situation.

1 Answers
0
Accepted Answer

The easiest way is to use the Lake Formation Data Catalog.

All the information contained in the Glue Catalog is available there, but with full text search support

answered 6 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions