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.

posta 2 anni fa528 visualizzazioni
1 Risposta
0
Risposta accettata

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
con risposta 2 anni fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande