steampipe plugin install grafana

Table: grafana_folder - Query Grafana Folders using SQL

Grafana Folders are a feature within Grafana that allows users to organize and group dashboards. This feature helps in managing large numbers of dashboards, providing a hierarchical structure for better navigation and search. Grafana Folders can also be used to apply permissions at a folder level, controlling user access to a group of dashboards.

Table Usage Guide

The grafana_folder table provides insights into the organization of dashboards within a Grafana instance. As a DevOps engineer, use this table to explore folder-specific details, including the title, unique identifier, version, and associated metadata. Utilize it to manage and understand the hierarchical structure of dashboards, their grouping, and permissions applied at the folder level.

Examples

List all folders

Explore all folders within your Grafana setup to understand their structure and organization. This can be particularly useful for managing and navigating your data visualization projects.

select
*
from
grafana_folder;
select
*
from
grafana_folder;

List all folders with their permissions

Explore which Grafana folders have specific permissions to determine areas in which access may need to be revised or updated. This is useful for managing access control and ensuring appropriate levels of data security.

select
f.uid,
f.title,
fp.*
from
grafana_folder as f,
grafana_folder_permission as fp
where
f.uid = fp.folder_uid;
select
f.uid,
f.title,
fp.*
from
grafana_folder as f,
grafana_folder_permission as fp
where
f.uid = fp.folder_uid;

Schema for grafana_folder

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
idbigint=Unique identifier for the folder.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
titletextTitle of the folder.
uidtextGlobally unique identifier for the folder.

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_folder