Narrower search option for Activations > REST API > Sources > List tables
Currently the List tables endpoint supports a search parameter that matches on table, schema or catalog:
https://fivetran.com/docs/activations/rest-api/api-reference/workspace-apis/sources/tables/list-source-tables#search
We have sources with large amounts of tables so we are using the search parameter on the request to filter this to a narrower set but we only want to match on table and schema name, not catalog.
We would like to request added functionality to be able to choose which fields the search matches on e.g. "search_fields=table,schema".
https://fivetran.com/docs/activations/rest-api/api-reference/workspace-apis/sources/tables/list-source-tables#search
We have sources with large amounts of tables so we are using the search parameter on the request to filter this to a narrower set but we only want to match on table and schema name, not catalog.
We would like to request added functionality to be able to choose which fields the search matches on e.g. "search_fields=table,schema".
Our current use case is "table CONTAINS <x> OR schema CONTAINS <x>", but I could imagine other customers having different use cases e.g. "table CONTAINS <x> AND catalog CONTAINS <y>" so the implementation depends a bit on how flexible you would want to make this.
Thanks!
Please sign in to leave a comment.
Comments
0 comments