Presto connection

Last updated: Apr 01, 2025
Presto connection

To access your data in Presto, create a connection asset for it.

Presto is a fast and reliable SQL engine for Data Analytics and the Open Lakehouse.

Supported versions

  • Version 0.286.

Create a connection to Presto

To create the connection asset, you need these connection details:

  • Hostname or IP address
  • Port
  • Username
  • Password (required if you connect to Presto with SSL enabled)
  • SSL certificate (if required by the Presto server)

Connecting to Presto within IBM watsonx.data

To connect to a Presto server within watsonx.data on IBM Cloud, use these connection details:

  • Username: ibmlhapikey
  • Password (for SSL-enabled, which is the default): An IBM Cloud API key. For more information, see Connecting to Presto server.

To connect to a Presto server within watsonx.data on Cloud Pak for Data or stand-alone watsonx.data, use the username and password that you use for the watsonx.data console.

Presto setup

To set up Presto, see Presto installation.

Restrictions

  • You can use this connection only for source data. You cannot write to data or export data with this connection.

Limitation

  • The Presto connection does not support the Apache Cassandra Time data type.

  • The Presto connection does not support TIME and TIMESTAMP data types when the Presto C++ engine is used

Running SQL statements

To ensure that your SQL statements run correctly, refer to the SQL Statement Syntax for the correct syntax.

Learn more

Presto documentation

Related connection: IBM watsonx.data Presto connection

Parent topic: Supported connections