0 / 0
Presto connection
Last updated: Jan 13, 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

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 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