Grafana Tables

The Grafana Integration uses the following tables

Tables

GrafanaDashboards

Required Scopes: Read access to searched folders/dashboards (RBAC filters results)

GrafanaDashboards Lists all dashboards with their names, folders, and tags so you can see what dashboards exist and where to find them.

NameTypeDescription
ConfigIDintegerGrafana configuration identifier.
DashboardIDintegerGrafana dashboard numeric ID
OrganizationIDintegerID of the Grafana organization that owns the dashboard
UIDstringStable unique identifier of the dashboard used in URLs and API calls
TitlestringDashboard title.
UrlstringRelative URL path to the dashboard
TypestringSearch result type; for dashboards this is dash-db.
TagsJSONstringJSON array of tags assigned to the dashboard
IsStarredbooleanWhether the dashboard is starred by the authenticated user
UristringDeprecated dashboard URI; retained for backward compatibility
FolderIDintegerID of the dashboard's containing folder when applicable
FolderUIDstringUID of the containing folder
FolderTitlestringTitle of the containing folder
FolderUrlstringRelative URL path of the containing folder
BatchDatedatetimeThe date of the data was gathered.

GrafanaDatasources

Required Scopes: datasources:read on datasources:*

GrafanaDatasources Lists the data connections Grafana uses (by name and type) so you know where dashboard data comes from.

NameTypeDescription
ConfigIDintegerGrafana configuration identifier.
DatasourceIDintegerNumeric identifier of the data source
OrganizationIDintegerID of the owning organization
UIDstringUnique identifier of the data source
NamestringDisplay name of the data source
TypestringData source plugin type, for example prometheus or elasticsearch
TypeLogoUrlstringPath/URL to the data source type logo
AccessstringAccess mode for queries: proxy or direct
UrlstringBase URL of the data source
PasswordstringPassword field as returned; usually empty because secrets are stored in secureJsonFields
UserstringUsername for basic authentication, if configured
DatabasestringDefault database/schema for the data source, if applicable
BasicAuthbooleanWhether Basic Auth is enabled for the data source
IsDefaultbooleanWhether this data source is the organization's default
ReadOnlybooleanWhether the data source is read-only
LogLevelFieldstringElasticsearch jsonData.logLevelField setting for the log level field.
LogMessageFieldstringElasticsearch jsonData.logMessageField setting for the log message field.
MaxConcurrentShardRequestsintegerElasticsearch jsonData.maxConcurrentShardRequests setting.
TimeFieldstringElasticsearch jsonData.timeField setting.
BatchDatedatetimeThe date of the data was gathered.

GrafanaFolderPermissions

Required Scopes: folders.permissions:read on folders:*

GrafanaFolderPermissions Shows who can view, edit, or manage each folder so access is clear and auditable.

NameTypeDescription
ConfigIDintegerGrafana configuration identifier.
PermissionIDintegerPermission entry identifier
FolderUIDstringUID of the folder these permissions apply to
FolderIDintegerNumeric ID of the folder
CreatedstringISO timestamp when the permission was created
UpdatedstringISO timestamp when the permission was last updated
UserIDintegerUser ID the permission targets
UserLoginstringLogin/username of the targeted user
UserEmailstringEmail of the targeted user
TeamIDintegerTeam ID the permission targets
TeamstringTeam name
RolestringRole if the permission targets a built-in role, for example Viewer or Editor
PermissionintegerNumeric permission level: 1=View, 2=Edit, 4=Admin
PermissionNamestringPermission level as text (View, Edit, Admin)
UIDstringUID of the referenced resource for this permission
TitlestringTitle of the referenced resource
SlugstringURL slug of the referenced resource
IsFolderbooleanTrue if the permission applies to a folder
UrlstringRelative URL of the resource
BatchDatedatetimeThe date of the data was gathered.

GrafanaFolders

Required Scopes: folders:read on folders:*

GrafanaFolders Shows the folder structure used to organize dashboards, including names and nesting.

NameTypeDescription
ConfigIDintegerGrafana configuration identifier.
FolderUIDstringStable unique identifier for the folder
FolderIDintegerNumeric identifier of the folder
TitlestringFolder title.
UrlstringRelative URL path to the folder
HasAclbooleanWhether the folder has an explicit access control list
CanSavebooleanWhether the current user can save dashboards to the folder
CanEditbooleanWhether the current user can edit the folder
CanAdminbooleanWhether the current user can administer folder permissions
CreatedBystringUsername that created the folder
CreatedstringCreation timestamp
UpdatedBystringUsername that last updated the folder
UpdatedstringLast updated timestamp
VersionintegerFolder version number
ParentUIDstringUID of the parent folder when nested folders are enabled
ParentsJSONstringJSON array of ancestor folders for breadcrumb/path display
BatchDatedatetimeThe date of the data was gathered.

GrafanaIntegrations

GrafanaIntegrations Lists integrations that are set up, with simple details to see what’s enabled.

NameTypeDescription
IDintegerIntegration identifier
NamestringIntegration display name.
CreatedDatedatetimeTimestamp when the integration was created
ModifiedDatedatetimeTimestamp when the integration was last modified
CreatedBystringUser who created the integration
ModifiedBystringUser who last modified the integration
IsEnabledbooleanWhether the integration is enabled/active
BaseURLstringBase URL or endpoint associated with the integration
OrganizationIDintegerID of the owning Grafana organization

GrafanaOrganizations

Required Scopes: orgs:read

GrafanaOrganizations Lists the workspaces (organizations) in your Grafana instance by name.

NameTypeDescription
ConfigIDintegerGrafana configuration identifier.
OrganizationIDintegerOrganization identifier
NamestringOrganization name
BatchDatedatetimeThe date of the data was gathered.

GrafanaTeams

Required Scopes: teams:read on teams:* - GrafanaTeams (members): teams.permissions:read on teams:*

GrafanaTeams Lists teams, their contact email, and how many people are in each team.

NameTypeDescription
ConfigIDintegerGrafana configuration identifier.
TeamIDintegerTeam identifier
OrganizationIDintegerID of the owning organization
NamestringTeam name
EmailstringTeam email address
AvatarUrlstringPath/URL to the team's avatar
MemberCountintegerNumber of team members
BatchDatedatetimeThe date of the data was gathered.

GrafanaUsers

Required Scopes: org.users:read on users:*

GrafanaUsers Lists people who have access to Grafana, their role, and when they were last active.

NameTypeDescription
ConfigIDintegerGrafana configuration identifier.
UserIDintegerUser identifier
OrganizationIDintegerOrganization ID for the org-user relation
EmailstringUser email address
AvatarUrlstringPath/URL to the user's avatar
LoginstringUser login/username
RolestringUser role within the organization
LastSeenAtstringTimestamp of the user's last activity in Grafana
LastSeenAtAgestringHuman-readable time since lastSeenAt
BatchDatedatetimeThe date of the data was gathered.

Bridge Tables

GrafanaTeams_GrafanaUsers

GrafanaTeams_GrafanaUsers Shows which people belong to which teams.

NameTypeDescription
TeamIDintegerTeam identifier
ConfigIDintegerGrafana configuration identifier.
UserIDintegerUser identifier

Did this page help you?