AWS Glue Catalog Table Name Cannot Be Searched By Full Text

1

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.

preguntada hace 2 años528 visualizaciones
1 Respuesta
0
Respuesta aceptada

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

didone
respondido hace 2 años

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas