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

judell

Steampipe is an open-source tool that can query cloud services rapidly, at scale, using SQL as the common way to access the APIs of AWS, GitHub, Kubernetes, M365, and more than 100 others. For example, Steampipe maps the AWS APIs to over 400 tables, with extensive copy-and-run examples for each table. If you've been writing Python scripts to gather and analyze data from these APIs, you'll want to give Steampipe a try. We bet you'll retire those Python scripts because accessing APIs with Steampipe, both within and across providers, is an easier, faster, and better way to get the job done.

Compliance benchmarks layered on the Steampipe core provide suites of controls that implement recommendations from CIS, GDPR, HIPAA, NIST 800-53, PCI, SOC2, and other frameworks. Use these be

judell

package main

import (
	"context"
	"database/sql"
	"fmt"
	"strings"
	"time"

	_ "github.com/lib/pq"

judell

import os, requests, time

org_handle = "acme"
workspace_handle = "jon"
url = f"https://cloud.steampipe.io/api/v0/org/{org_handle}/workspace/{workspace_handle}/snapshot"
headers = {
    "Authorization": f"Bearer {os.environ['STEAMPIPE_CLOUD_TOKEN']}"
}

# Fetch all snapshots with the specified title

judell

judell

judell

Count peers of servers in the home timeline

with data as (
  select
    'https://' || server as server
  from
    mastodon_toot
  where
    timeline = 'home'

judell

import json, psycopg2, psycopg2.extras, os, re
conn_str = f"host='localhost' dbname='steampipe' user='steampipe' port='9193' password='{os.getenv('STEAMPIPE_LOCAL_PASSWORD')}'"

def get_repos():
  sql = f"""
    select 
      full_name
    from
      github_my_repository
    where

judell

with data as (
  select
    l.title as list,
    a.*
  from
    mastodon_list l
  join
    mastodon_list_account a
  on
    l.id = a.list_id

judell

Rendering HTML in dashboard tables

The Mastodon API returns HTML which dashboards display raw. The Mastodon plugin deals with that by stripping HTML tags which is minimally OK but not great. Here is rough go at a way to enable HTML to render in table cells.

Code

In ~/steampipe/ui/dashboard/src/components/dashboards/Table/index.tsx:

Add these imports: