Skip to main content

Env0

Env0 is a cloud infrastructure automation and self-service platform that enables organizations to manage, govern, and orchestrate their Infrastructure as Code (IaC) deployments. It provides automated workflow management for Terraform, Terragrunt, Pulumi, OpenTofu, Kubernetes, and Helm, allowing teams to deploy cloud infrastructure with built-in governance, cost controls, and compliance policies.

CategoryInfrastructure as code
DirectionQuery source
Sign-inAPI Key and Secret
Query languagesSQLite
Tables9
Query templates42
Websiteenv0.com

Before you start​

Huntbase signs in to Env0 with API Key and Secret. Create the credential in Env0 first, then keep it to hand for the Connect step.

  1. In env0, go to Organization Settings › API Keys and click +.
  2. Create a User API key rather than an Admin API key, and give it only the project permissions Huntbase needs.
  3. Copy the API key ID and secret.
Watch out for
  • An organization administrator creates API keys and assigns their role. If the role assignment changes, the key's permissions change too.
  • After you delete an API key, it can take up to an hour to stop working.

For the vendor's own instructions, see env0 API authentication documentation.

tip

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

Connect Env0​

  1. Go to Connections and click New connection, or click New connection on the Env0 product page.
  2. On Product, pick Env0 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.

Credentials​

The only Method is API Key and Secret. Enter a Credential label (for example Production), then fill in:

FieldRequiredNotes
API KeyYesThe API key ID. Secret — not shown again after you save it.
API SecretYesThe API key secret. Secret — not shown again after you save it.

Query it​

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

LanguageUse it for
SQLiteSQL over the 9 tables listed below, alongside every other connected source.

Example: SQLite​

List all teams — basic info — Explore your team's basic information, such as names and associated IDs, to understand the structure and organization of your team within the platform.

select
  name,
  id,
  description,
  organization_id
from
  env0_team;

Env0 ships with 42 query templates. Find them in Library › Queries — see Query templates.

Tables​

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

All 9 tables
TableContains
env0_api_keyReturns information about the env0 API keys.
env0_environmentReturns information about the env0 environment.
env0_notificationReturns information about the env0 notifications.
env0_organizationReturns information about the env0 organization.
env0_projectReturns information about the env0 project.
env0_roleReturns information about the env0 roles.
env0_teamReturns information about the env0 teams.
env0_templateReturns information about the env0 template.
env0_userReturns information about the env0 users.

Next steps​