Connect to Turbot Pipes from DBT
DBT is a SQL-first IDE to query, edit and manage your databases.
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 DBT -- can connect to.
The Connect tab for your workspace provides the details you need to connect DBT to Turbot Pipes.
Once the connection to Turbot Pipes is established and tested, you can explore the Steampipe plugins, run queries and build reports.
You can also connect DBT to Steampipe CLI. To
do that, run
steampipe service start --show-password and use the displayed
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
[DBT is available to use on the desktop and the cloud. To use it, create an account and select a DBT cloud plan -- here we use the free developer plan. In this example we will create a Turbot Pipes connection from DBT and query the top stories by score from hackernews_top.
Since DBT projects include
it requires linking your git repository with write access enabled through
linked accounts under
account settings. Next, Select PostgreSQL under
Credentials to create a new connection and enter the Turbot Pipes connection
Test Connection to
Once you've connected to Turbot Pipes, paste this query and click compile. DBT
then previews the data in a table form which can also be saved in a
select*fromhackernews_toporder byscore desc