Table: algolia_search

Run a search query, each row is a result.

Notes:

Examples

select
  rank,
  object_id,
  jsonb_pretty(hit) as result
from
  algolia_search
where
  index = 'offices'
  and query = 'usa'
order by
  rank

Warning: This is a very large query, use carefully!

select
  *
from
  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.