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, descriptionfrom algolia_api_keywhere age(created_at) > interval '90 days'
Access keys with permission to add objects
select key, acl, descriptionfrom algolia_api_keywhere acl ? 'addObject'
.inspect algolia_api_key
API keys for the algolia account.
Name | Type | Description |
---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. |
acl | jsonb | List of permissions the key contains. |
created_at | timestamp with time zone | The date at which the key has been created. |
description | text | Description of the key. |
indexes | jsonb | The list of targeted indices, if any. |
key | text | API key value. |
max_hits_per_query | bigint | Maximum number of hits this API key can retrieve in one call. |
max_queries_per_ip_per_hour | bigint | Maximum number of API calls allowed from an IP address per hour. |
query_parameters | text | Parameters added to all searches with this key. |
referers | jsonb | |
validity | timestamp with time zone | Timestamp of the date at which the key expires. (0 means it will not expire automatically). |