Skip to main content
Version: 3.0.0-LTS

PrestoDB

ToolJet allows you to connect to your PrestoDB database to perform SQL queries and retrieve data.

Connection​

To connect to a PrestoDB data source in ToolJet, you can either click the +Add new data source button on the query panel or navigate to the Data Sources page in the ToolJet dashboard.

To connect to your PrestoDB database, the following details are required:

  • Username
  • Password
  • Catalog
  • Host
  • Port
  • Schema
  • User
  • Timezone (optional)
  • Extra Headers (optional)
PrestoDB Connect

Querying PrestoDB​

  1. Click the + button in the query manager at the bottom of the editor and select the PrestoDB data source added earlier.
  2. Write your SQL query in the query editor.
tip

Query results can be transformed using transformations. Refer to our transformations documentation for more details: link

Supported Operations​

ToolJet supports executing SQL queries on PrestoDB databases.

SQL Query​

This operation allows you to execute SQL queries on your PrestoDB database.

PrestoDB Query

Parameters:​

  • SQL Query: The SQL query to execute.

Example:​

SELECT * FROM my_table WHERE column_name = 'value' LIMIT 10