Connect to Turbot Pipes from Deepnote
Deepnote is a collaborative notebook for discovering, understanding and sharing data. It connects to many databases, including Postgres, and enables users to explore, query, and visualize data.
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 Deepnote -- 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)
Connect to Steampipe CLI from Deepnote
You can also connect Deepnote 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
Deepnote works with any web browser.
To create a new connection, first click on Projects
to create a new project.
Then click Create new
from the Integrations
tab on the right sidebar, select
PostgreSQL
and enter the connection details. If your connection is protected,
you might need to
whitelist
Deepnote's IP adresses.
![](/_next/image?url=%2Fimages%2Fdocs%2Fpipes%2Fdeepnote-connection-success.png&w=3840&q=75)
Once the integration is successful, click View Schema
from the navigation bar
to explore the connections in your workspace.
![](/_next/image?url=%2Fimages%2Fdocs%2Fpipes%2Fdeepnote-navigationbar.png&w=3840&q=75)
Create a chart with custom query
Let's use the Finance plugin
to chart the change percentage for bitcoin during regular market session. To
begin, click the SQL
block and select the integrated database from the
dropdown list on the projects page. Paste this query in the command palette and
click Run notebook
. You can refresh the notebook on an hourly, daily or weekly
schedule to update the data using the Schedule notebook
feature.
select symbol, short_name, regular_market_price, regular_market_change_percent, regular_market_timefrom finance_quotewhere symbol in ('GME', 'BTC-USD', 'DOGE-USD', 'ETH-USD');
Deepnote previews the data in a table form. The data can also be exported in a CSV format.
![](/_next/image?url=%2Fimages%2Fdocs%2Fpipes%2Fdeepnote-table-preview.png&w=3840&q=75)
Now click Visualize
to open the visualize data form and select Type as
Bar chart
. Update the X and Y Axis data fields with
regular_market_change_percent
and symbol
to display the chart with the data.
Deepnote also supports Block sharing
: it can generate a link that anyone can
use to view the shared block.
![](/_next/image?url=%2Fimages%2Fdocs%2Fpipes%2Fdeepnote-bitcoin-chart.png&w=3840&q=75)
Summary
With Deepnote 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
Create and share charts driven by your custom queries