Presto connection

Last updated: Jan 08, 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.279 and earlier

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.

Choose the method for creating a connection based on where you are in the platform

In a project: Click Assets > New asset > Connect to a data source. See Adding a connection to a project.
In a deployment space: Click Import assets > Data access > Connection. See Adding data assets to a deployment space.
In the Platform assets catalog: Click New connection. See Adding platform connections.

Next step: Add data assets from the connection

See Add data from a connection in a project.

Where you can use this connection

You can use the Presto connection in the following workspaces and tools:

Projects

Data Refinery
Decision Optimization
SPSS Modeler
Synthetic Data Generator

Catalogs

Platform assets catalog

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 the Presto C++ engine TIME and TIMESTAMP data types

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