turbot/algolia

GitHub
steampipe plugin install algoliasteampipe plugin install algolia

Table: algolia_search

Run a search query, each row is a result.

Notes:

Examples

Search the offices index for the term "usa"

select
rank,
object_id,
jsonb_pretty(hit) as result
from
algolia_search
where
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.

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
highlight_resultjsonbHighlight information.
hitjsonbHit data of the search result.
indextextName of the index for the search result.
object_idtextObject ID for this search result.
querytextQuery used to obtain the search result.
rankbigintRank (position) of the search result. The top result is number 1.
ranking_infojsonbRanking information for the search result.
snippet_resultjsonbSnippet information.