Supported Presto Versions

0.179 and above

Connection Preview Support

Supports all tables and views listed by show tables.

SQL Query Dataset Support for SQL

Only SELECT statements are supported. Supports all SELECT-related features supported by the connected Presto server. Users need to ensure the syntax conforms to the Presto SQL standard.

Supported Authentication Methods for Connecting to Presto Server

Supports username and password authentication.

Unsupported Field Types

Columns of the following types in Presto tables cannot be processed correctly. If other fields of the table are needed, you can enter a select statement in the SQL query that does not include the field.

  • TIME
  • TIME WITH TIME ZONE
  • INTERVAL
  • VARBINARY
  • ARRAY
  • MAP
  • ROW
  • IPADDRESS
  • HyperLogLog
  • P4HyperLogLog
  • QDigest