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
andTIME
data types when the Presto C++ engine is usedTIMESTAMP
Running SQL statements
To ensure that your SQL statements run correctly, refer to the SQL Statement Syntax for the correct syntax.
Learn more
Related connection: IBM watsonx.data Presto connection
Parent topic: Supported connections