env0 Model

The Cloud Analyst data model provides a structured view of the data available within our system, enabling users to run queries and extract meaningful insights. It includes detailed information about key entities, relationships, and attributes, allowing users to explore their resources, usage, costs, performance and other critical data and metrics.

Whether using our AI chatbot or building custom visualizations, users can leverage this data model to gain a deeper understanding of their cloud environment and make data-driven decisions.

Full Entities Relational Diagram:


Elaborating on the Main Entities:

TableFieldsConnects ToDescription
ProjectsName, DatesTemplates, Environments, Budgets
EnvironmentsName, Dates, Template data, Status, Drift StatusProjects, Deployments, Daily Costs, State Resources, Templates, Module Usage
DeploymentsType, Drift Detected, Duration, Error, Date, Start/Finish Times, IaC version, StatusEnvironments, Deployment Stepsand Users (which started the deployment)
Deployment StepsName, Duration, Start/Compete Times, StatusDeployments
TemplatesName, Dates, Type, Project AssociationProjects, Environments
UsersName, Dates, EmailDeployments (they started), Teams
TeamsName, DatesUsers
Daily CostsDate, Amount, Cloud TypeEnvironments
BudgetsDate, Time Frame, AmountProjects
ModulesName, DatesModule Downloads, Module Usages
Module DownloadsDate, VersionModulesHow many times a module was downloaded
Module UsageDates, Provider, VersionModules, EnvironmentsWhich Environments use which modules
State ResourcesDates, Type, Cloud Provider, Account, Region, IaC tool, Module, Provider, Deployment (last one that managed it)Environments , Cloud ResourcesAll resources created by your env0 Environments
Cloud ResourcesName, Dates, IaC/API/Click Operations, First Seen, Severity, Type, Service, Management Type, Cloud ProviderState Resources, Change Events, Cloud Resource TrendsAll resources found in the cloud (which may or may not be managed using env0)
Change EventsEvent Name, Dates, User Agent, UsernameCloud ResourcesAll change events found in the cloud
Cloud Resource TrendsDates, IaC/API/Click Count, TypeCloud Resources