The following table summarizes connection properties which can be used to configure the driver to use requests using HTTP transport (HTTP mode).

Table 1. Data Type Handling Properties
Property Characteristic

HTTPPath

 Specifies the path of the HTTP/HTTPS endpoint used for connections when HTTP mode is enabled (TransportMode=http).

The default is cliservice.
TransportMode

Specifies whether binary (TCP) mode or HTTP mode is used to access Apache Spark SQL data sources.

If set to binary, Thrift RPC requests are sent to directly to data sources using a binary connection (TCP mode).

If set to http, Thrift RPC requests are sent using HTTP transport (HTTP mode). HTTP mode is typically used when connecting to a proxy server, such as a gateway, for improved security, or a load balancer.

The default is binary.

UserAgent

Specifies the string value of the User-Agent header to be used in HTTP requests. This property provides a method to override the default value of the User-Agent header when required by a service.

No default value, which means the driver uses Progress/8.0 (SparkSQL ODBC driver) for the value of the User-Agent header.