Using connection strings #

The Starburst ODBC driver V3 series is described in the following pages:

• Overview
• Installation
• DSN configuration
• This page — Using connection strings
• Connection string keywords
• Mapping keywords from V2 to V3
• Upgrading and rolling back

Some applications require full ODBC connection strings to connect to Starburst servers. Other applications let you provide partial connection strings to provide additional information or override existing settings.

The following sections contain connection string examples with the minimum required attributes to connect to Starburst servers. For more information about all available attributes and keywords, see Connection string keywords.

DSN connection string #

If you have a defined DSN, create the following simple connection string:

DSN=<data_source_name>

Set additional connection attributes by appending key=value pairs to the connection string, separated by semicolons (;):

DSN=<data_source_name>;key=value;

The connection attributes you set in the connection string override the connection attributes you set in the DSN configuration.

DSN-less connection string #

A DSN-less connection string connects directly to the Starburst server without requiring a pre-configured Data Source Name (DSN).

Use the following syntax:

DRIVER={Starburst ODBC Driver};Server=<host_or_ip_of_server>;PORT=<port>;AuthenticationType=<authentication_type>;UID=<user>;PWD=<password>;<keyword>=<value>;

Where Starburst ODBC Driver is the default driver name registered in ODBCINST.INI.

If you define an attribute multiple times in a connection string, the rightmost value takes precedence.

For a complete list of connection string keywords, see Connection string keywords.

Connection strings with V2 keywords still work, but updating your connection strings to V3 keywords is recommended. For more information, see Mapping keywords from V2 to V3.

Special characters #

Enclose values in curly brackets ({}) if they start or end with whitespaces, or contain these special characters: []{(),;?*=!@. If a value contains a closing bracket (}), replace it with two brackets (}}).

Examples #

The following connection string example connects to a Galaxy cluster with JWT authentication:

Driver=Starburst ODBC Driver; Server=yourgalaxyaccount-cluster.trino.galaxy.starburst.io; Port=443; AuthenticationType=JWT; SSL=1; AccessToken=eyJraWQiOiJCVThtQW1h...

The following connection string example connects to SEP with password authentication, where the password ` my Pa;}&d is escaped as { my Pa;}}&d}`:

Driver=Starburst ODBC Driver; Server=sep.example.com; Port=8443; AuthenticationType=Password; SSL=1; UID=user1; PWD={ my Pa;}}&d};