steampipe-alchemy 0.1.2

Python Boilerplate contains all the boilerplate you need to create a Python package.

steampipe-alchemy

A simple SQLAlchemy wrapper around Steampipe.

Currently this is a work in progress. Models exist for the AWS plugin, others will be added in the future.

• Free software: BSD license

• Documentation: [WIP] https://steampipe-alchemy.readthedocs.io.

Features

Install, setup, and start steampipe with the aws plugin.

# We're assuming the the AWS credentials are set in the environment here.
from steampipe_alchemy as sa

sa.install(['aws'])  # Downloads and installs steampipe with the aws plugin.
sa.update_config(['us-east-1', 'us-east-2', 'us-west-1']) #  Modifies ~/.local/share/steampipe_alchemy/config/aws.spc
sa.start()  # Steampipe will be stopped when the script exits or when stop() is called.

We can then use the SQLAlchemy models to query AWS.

from steampipe_alchemy import query
from steampipe_alchemy.models import AwsS3Bucket

for b in query(AwsS3Bucket).limit(3):
    print(b.name)
    print("  Region: " + b.region)
    print("  Owner: " + str(b.acl['Owner']['DisplayName']))

History

0.1.0 (2021-04-15)

• First release on PyPI.