Table: algolia_search
Run a search query, each row is a result.
Notes:
- Use algolia_search_metadata to get search result metadata.
Examples
Search the offices index for the term "usa"
select rank, object_id, jsonb_pretty(hit) as resultfrom algolia_searchwhere index = 'offices' and query = 'usa'order by rank
Get all records from all indexes
Warning: This is a very large query, use carefully!
select *from algolia_search
.inspect algolia_search
Search results (hits) for a given query.
Name | Type | Description |
---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. |
highlight_result | jsonb | Highlight information. |
hit | jsonb | Hit data of the search result. |
index | text | Name of the index for the search result. |
object_id | text | Object ID for this search result. |
query | text | Query used to obtain the search result. |
rank | bigint | Rank (position) of the search result. The top result is number 1. |
ranking_info | jsonb | Ranking information for the search result. |
snippet_result | jsonb | Snippet information. |