Connect to Turbot Pipes from Sigma
Sigma is a cloud-native analytics platform with a user-friendly spreadsheet interface for instant, code-free exploration and real-time insights from cloud data warehouses.
Steampipe provides a single interface to all your cloud, code, logs and more. Because it's built on Postgres, Steampipe provides an endpoint that any Postgres-compatible client — including Sigma — can connect to.
You can get the information needed to connect to your Turbot Pipes database instance from the Query tab for your workspace. On the Query tab, click the info button at the top of the query window to show the connection information.
![](/_next/image?url=%2Fimages%2Fdocs%2Fpipes%2Fquery-info-connect.png&w=3840&q=75)
Once the connection to Turbot Pipes is established, you can access the tables provided by the Steampipe plugins, run queries, and build reports.
You can also connect Sigma to Steampipe CLI. To do that, run steampipe service start --show-password
and use the displayed connection details.
Steampipe service is running:
Database:
Host(s): localhost, 127.0.0.1, 192.168.29.204 Port: 9193 Database: steampipe User: steampipe Password: 99**_****_**8c Connection string: postgres://steampipe:99**_****_**8c@localhost:9193/steampipe
Getting started
Sigma is available as a free trial or by making a paid purchase.
To create a new connection click on the profile icon located at the top right corner and click on Add connection
, name your connection and select PostgreSQL
. Then add the connection details and click Create
.
![](/_next/image?url=%2Fimages%2Fdocs%2Fpipes%2Fsigma-connection-success.png&w=3840&q=75)
Once you've connected to Turbot Pipes, you can access plugins and their tables from the object explorer.
![](/_next/image?url=%2Fimages%2Fdocs%2Fpipes%2Fsigma-explorer.png&w=3840&q=75)
Here we select the aws_region
table from the `AWS Plugin. Sigma displays the table's schema and previews the returned data which can be exported into various formats.
![](/_next/image?url=%2Fimages%2Fdocs%2Fpipes%2Fsigma-data-preview.png&w=3840&q=75)
Create and share a chart with custom query
Here we will focus on creating a chart to analyze the S3 buckets that restrict public bucket policies. To begin, click Create New
then click Workbook
. Select VIZ
under Data Elements, then select Write SQL
.
![](/_next/image?url=%2Fimages%2Fdocs%2Fpipes%2Fsigma-data-elements.png&w=3840&q=75)
Paste this query in the command palette, then click Run
.
select name, region, account_id, restrict_public_bucketsfrom aws_s3_bucket
Sigma previews the data in the table form. Now click Save
to open the visualization data form and select Type
as Pie
. Update the Value
field with Name
and Restrict Public Buckets
to generate the chart with the data.
![](/_next/image?url=%2Fimages%2Fdocs%2Fpipes%2Fsigma-visualization-chart.png&w=3840&q=75)
The generated charts can be distributed via email, Slack, or uploaded to cloud storage using the export menu. Here, the created chart has been shared via email.
![](/_next/image?url=%2Fimages%2Fdocs%2Fpipes%2Fsigma-email-output.png&w=3840&q=75)
Summary
With Sigma and Turbot Pipes you can:
View tables in your Turbot Pipes workspace
Write custom queries to preview data from the tables in your Turbot Pipes workspace and create charts driven by them
Share the generated charts