Aiven

Aiven is a comprehensive managed cloud data infrastructure platform that provides open-source data technologies as-a-service across multiple cloud providers. This integration enables organizations to query, monitor, and manage their Aiven infrastructure, services, accounts, projects, and associated resources for operational visibility, security auditing, compliance reporting, and cost management.

Category	Database
Direction	Query source
Sign-in	API Token, User Credentials
Query languages	SQLite
Tables	10
Query templates	43
Website	http://aiven.io

Before you start

Huntbase can sign in to Aiven with any of these methods: API Token, User Credentials. Pick one, create the credential in Aiven, then keep it to hand for the Connect step.

API Token

Aiven authentication token created in the Aiven Console for use with the Aiven CLI or API.

1. In the Aiven Console, open User information and choose Tokens.
2. Click Generate token, enter a description, and set the session duration.
3. Click Generate token again, then use the Copy icon to copy the token and click Close.

Watch out for

• You cannot view the token again after you close the window, so copy it before you click Close.

For the vendor's own instructions, see Aiven personal token documentation.

tip

Use a dedicated, read-only credential for Huntbase where the product allows it. Huntbase only needs to read.

Connect Aiven

1. Go to Connections and click New connection, or click New connection on the Aiven product page.
2. On Product, pick Aiven and choose the Owner.
3. On Details, give the connection a Name and, optionally, a Description.
4. On Connect, fill in the settings and credentials described below.
5. On Verify, review the summary and click Create & check.

For everything else on the setup page — saving a draft, I'll do this later, and what each check result means — see Connections.

Settings

Where your Aiven lives:

Field	Required	Notes
Email	No

Credentials

Choose a Method, enter a Credential label (for example Production), then fill in the fields for that method.

API Token

Field	Required	Notes
API Token	Yes	Secret — not shown again after you save it.

User Credentials

Field	Required	Notes
Password	Yes	Secret — not shown again after you save it.

Query it

Once connected, Aiven can serve these languages in a query tab, and Scout can use it when you ask in Auto:

Language	Use it for
SQLite	SQL over the 10 tables listed below, alongside every other connected source.

Example: SQLite

List service integration endpoint settings — Explore the configuration details of service integration endpoints to understand their types and user settings.

select
  endpoint_id,
  endpoint_name,
  endpoint_type,
  user_config
from
  aiven_service_integration_endpoint;

Aiven ships with 43 query templates. Find them in Library › Queries — see Query templates.

Tables

Aiven adds 10 tables. Browse their columns from Schema in the query bar's ⋯ menu.

All 10 tables

Table	Contains
aiven_account	Retrieve information about your accounts.
aiven_account_authentication	Retrieve information about your account authentications.
aiven_account_team	Retrieve information about your account teams.
aiven_billing_group	Retrieve information about your billing groups.
aiven_project	Retrieve information about your projects.
aiven_project_event_log	Retrieve information about your project event logs.
aiven_project_user	Retrieve information about your project users.
aiven_project_vpc	Retrieve information about your project VPCs.
aiven_service	Retrieve information about your services.
aiven_service_integration_endpoint	Retrieve information about your service integration endpoints.

Next steps

• Connections — health, credentials and settings after you connect
• Query languages — syntax, parameters and time ranges
• Chatting with Scout — ask questions without writing a query
• All integrations — the rest of the catalog