Table: grafana_org - Query Grafana Organizations using SQL
Grafana Organizations are a way to manage access to resources in Grafana. Each user can belong to one or many organizations, and each dashboard belongs to a particular organization. Organizations allow for grouping and isolation of resources.
Table Usage Guide
The grafana_org
table allows users to gain insights into Grafana Organizations. As a system administrator or a DevOps engineer, you can use this table to fetch details about different organizations, their associated users, and dashboards. This can be particularly beneficial for managing access to resources and ensuring the isolation of resources across different organizations.
Important Notes
- The API used by this table requires admin user access via basic authentication (i.e.
admin:password
) in theauth
config field. Reference.
Examples
List all orgs
Explore the various organizations within your Grafana setup to understand their settings and configurations. This aids in managing resources and maintaining an overview of your organizational structure.
select *from grafana_org;
select *from grafana_org;
Schema for grafana_org
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
id | bigint | = | Unique identifier for the org. |
name | text | = | Name of the org. |
Export
This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.
You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh
script:
/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- grafana
You can pass the configuration to the command with the --config
argument:
steampipe_export_grafana --config '<your_config>' grafana_org