Drill JDBC Driver Configuration Options

The following table lists the properties that you can use to configure the behavior of the Drill JDBC driver:

Property	Description	Default Value	Required
CastAnyToVarchar	When set to “true,” the driver casts columns to VARCHAR if SQLColumns returns columns of type ANY. When set to “false,” the driver does not change the returned columns.	false	No
ExcludedSchemas	A list of schemas that do not appear in client applications. Use a comma (,) to separate schemas in the list.	None	No
PWD	The password that corresponds to the user name that you provided using the property UID.	None	Yes, if the server requires authentication for access.
UID	The name of the user accessing the Drill server.	None	Yes, if the server requires authentication for access.