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;
| Name | Database | Location |
|---|---|---|
| mqtt_aapl | mydb | mylocation |
| mqtt_goog | mydb | mylocation |
| mqtt_tesla | mydb | mylocation |
| kafka_stock | myrealtime | mylocation |
And I typed "mqtt" , it returns inconsistent result
-
Show only top of list e.g. only "mqtt_aapl"
-
Show all tables in catalog including "kafka_stock"
-
Show nothing
Expectation:
-
When I typed "mqtt", it should return 3 items of list "mqtt_aapl", "mqtt_goog" and "mqtt_tesla"
-
When I typed "stock" it should return only "kafka_stock"
Please help to figure out how I can deal with this situation.
asked 6 months ago27 views
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
Relevant questions
Unable to query dynamodb table in Athena using DynamoDB Connector
Accepted Answerasked 2 years agoHow could we have Glue to get data from csv as String?
Accepted Answerasked 2 months agoWhat is the sizekey parameter in AWS Glue Catalog Data properties?
Accepted Answerasked 2 years agoGlue Console Table GUI Needs Sort Functionality
asked 7 months agoWhat's the meaning of an AWS Glue Database name in italic?
asked 3 months agoGenerating Parquet files from Glue Data Catalog
asked a month agoDelete partitions in Glue Data Catalog using crawler not working.
asked 2 months agoAWS Glue API get-partitions can't seem to cope with the partition column name "key" in the `expression` filter
asked 4 months agoAWS Glue Catalog Table Name Cannot Be Searched By Full Text
Accepted Answerasked 6 months agoPartition schema mismatch in Glue Table
asked a month ago
This Works, Thanks!