0 / 0
Presto connection

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

You can use the Presto connection to connect to multiple types of Presto, including the Presto engine within an instance of watsonx.data. Alternatively, you can use the IBM watsonx.data Presto connection.

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 catalog
Click Add to catalog > Connection. See Adding a connection asset to a catalog.
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 (Watson Studio or IBM Knowledge Catalog)
  • DataStage (DataStage service). See Connecting to a data source in DataStage.
  • Metadata import (IBM Knowledge Catalog)
  • SPSS Modeler (Watson Studio)

Catalogs

  • Platform assets catalog

  • Other catalogs (IBM Knowledge Catalog)

    Note:

    Preview, profile, and masking are not certified for this connection in IBM Knowledge Catalog.

Presto setup

To set up Presto, see Presto installation.

Restrictions

  • Only the Presto (Java) engine is supported. (The Presto (C++) engine is not supported.)
  • 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.

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

Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more