Searches a set of tables based on properties in the table metadata as well as on the parent database. You can search against text or filter conditions.
glue_search_tables(CatalogId, NextToken, Filters, SearchText,
SortCriteria, MaxResults)A unique identifier, consisting of <i>account_id</i>/datalake.
A continuation token, included if this is a continuation call.
A list of key-value pairs, and a comparator used to filter the search results. Returns all entities matching the predicate.
A string used for a text search.
Specifying a value in quotes filters based on an exact match to the value.
A list of criteria for sorting the results by a field name, in an ascending or descending order.
The maximum number of tables to return in a single response.
svc$search_tables(
CatalogId = "string",
NextToken = "string",
Filters = list(
list(
Key = "string",
Value = "string",
Comparator = "EQUALS"|"GREATER_THAN"|"LESS_THAN"|"GREATER_THAN_EQUALS"|"LESS_THAN_EQUALS"
)
),
SearchText = "string",
SortCriteria = list(
list(
FieldName = "string",
Sort = "ASC"|"DESC"
)
),
MaxResults = 123
)
You can only get tables that you have access to based on the security policies defined in Lake Formation. You need at least a read-only access to the table for it to be returned. If you do not have access to all the columns in the table, these columns will not be searched against when returning the list of tables back to you. If you have access to the columns but not the data in the columns, those columns and the associated metadata for those columns will be included in the search.