turbot/algolia

GitHub
steampipe plugin install algoliasteampipe plugin install algolia

Table: algolia_api_key

API Keys defined in the Algolia account.

Examples

List all API Keys

select
*
from
algolia_api_key

Access keys more than 90 days old

select
key,
created_at,
description
from
algolia_api_key
where
age(created_at) > interval '90 days'

Access keys with permission to add objects

select
key,
acl,
description
from
algolia_api_key
where
acl ? 'addObject'

.inspect algolia_api_key

API keys for the algolia account.

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
acljsonbList of permissions the key contains.
created_attimestamp with time zoneThe date at which the key has been created.
descriptiontextDescription of the key.
indexesjsonbThe list of targeted indices, if any.
keytextAPI key value.
max_hits_per_querybigintMaximum number of hits this API key can retrieve in one call.
max_queries_per_ip_per_hourbigintMaximum number of API calls allowed from an IP address per hour.
query_parameterstextParameters added to all searches with this key.
referersjsonb
validitytimestamp with time zoneTimestamp of the date at which the key expires. (0 means it will not expire automatically).