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 the auth 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.
id	bigint	=	Unique identifier for the org.
name	text	=	Name of the org.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.

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