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.
The Connect tab for your workspace provides the details you need to connect Deepnote to Turbot Pipes.
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
Steampipe service is running:Database:Host(s): localhost, 127.0.0.1, 192.168.29.204Port: 9193Database: steampipeUser: steampipePassword: 99**_****_**8cConnection string: postgres://steampipe:99**_****_**8c@localhost:9193/steampipe
Deepnote works with any web browser.
To create a new connection, first click on
Projects to create a new project.
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
Deepnote's IP adresses.
Once the integration is successful, click
View Schema from the navigation bar
to explore the connections in your workspace.
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
Run notebook. You can refresh the notebook on an hourly, daily or weekly
schedule to update the data using the
Schedule notebook feature.
selectsymbol,short_name,regular_market_price,regular_market_change_percent,regular_market_timefromfinance_quotewheresymbol 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.
Visualize to open the visualize data form and select Type as
Bar chart. Update the X and Y Axis data fields with
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.
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