Trino

Postgres Connection

Using `trino+http` as connection protocol disables SSL for the connection. Example: `trino+http://host:port/catalog
Notice that basic auth requires SSL for Trino.

import connectorx as cx
conn = 'trino+https://username:password@server:port/catalog'     # connection token
query = "SELECT * FROM table"                                    # query string
cx.read_sql(conn, query)                                         # read data from Trino

Trino-Pandas Type Mapping

Trino Type	Pandas Type	Comment
BOOLEAN	bool, boolean(nullable)
TINYINT	int64, Int64(nullable)
SMALLINT	int64, Int64(nullable)
INT	int64, Int64(nullable)
BIGINT	int64, Int64(nullable)
REAL	float64
DOUBLE	float64
DECIMAL	float64
VARCHAR	object
CHAR	object
DATE	datetime64[ns]
TIME	object
TIMESTAMP	datetime64[ns]
UUID	object
JSON	object
IPADDRESS	object