judell

Me: paste context from https://jreyesr.github.io/posts/steampipe-part-int-pi-mods/

Me

given this context, how would i add a slider widget?

Cody Adding a slider widget to Steampipe dashboards would be a useful feature. Here is how I would approach implementing it:

Define the slider widget in the Steampipe dashboard DSL. It could look something like this:

judell

Me

which parts of the code should i explore to learn how to make a new echarts widget, say a slider, available as an HCL component that runs SQL and feeds data into the echarts slider?

Cody

Read 13 files To add a new ECharts widget (like a slider) as an HCL component that runs SQL, you should explore the following parts of the code:

ui/dashboard/src/components/dashboards/charts/echarts.ts - This file registers all the ECharts chart types that Steampipe supports. You'll need to import the ECharts slider component here and add it to the echarts.use() call.

judell

Me

"The dashboard server executes each SQL query and caches the results."

That's wrong. The Steampipe CLI runs the query and passes results to the dashboard server

Cody

Read 12 files You're right, my previous statement was incorrect. The correct explanation is:

judell

Me how does the dashboard server receive the results of sql queries and render them as tables and charts?

Cody

Read 13 files The Steampipe dashboard server receives SQL query results and renders them as tables and charts in the following way:

When a dashboard is loaded, the dashboard server parses the dashboard definition file (dashboard.sp). This includes parsing any SQL queries defined in the dashboard.

judell

The initial release of the AWS Well-Architected mod supported two of the six pillars of the AWS Well-Architected Framework: Reliability and Security. In this post we'll show how you can extend the Well-Architected mod with a benchmark that helps you assess your infrastructure in terms of the enviromental impacts targeted by the Sustainability pillar.

Well-Architected is itself an example of how to Reuse and remix existing benchmarks and dashboards: it reuses controls from AWS Compliance. The Sustainability

judell

from mastodon import Mastodon #You need to install mastodonpy for python3.
import os

import logging
logging.basicConfig(level=logging.DEBUG)

mastodon = Mastodon(
    access_token='***',
    api_base_url='https://social.coop'
    #access_token='***',

judell

with data as (
  select
    account,
    account_url,
    content,
    created_at,
    display_name,
    followers,
    following,
    id,

judell

How to save Steampipe outputs for analysis

Steampipe queries persist in cache for a default 5 minutes. You can increase the TTL to keep results in cache longer, but sometimes you'll want to save query results for later analysis.

Here are some common scenarios.

I want to analyze the results of a CIS 1.5 control or benchmark

You can use steampipe check with the --export flag to capture a CSV representation of the data that powers an individual control, or a suite of controls packaged as a benchmark.

judell

dashboard "javier" {

  with "tls_connection" {
    sql = <<EOQ
      create or replace function public.tls_connection(domain text) returns setof net_tls_connection as $$
        select
          *
        from
          net_tls_connection
        where

judell

dashboard "javier" {

  with "tls_data" {
    sql = <<EOQ
      select
        'domain.com:443' as address,
        max(distinct version) as max_version
      from
        net_tls_connection
      where