MySQL Connection Parameters
List of MySQL connection parameters, descriptions, default values, and supported data types.
The following sections list the required and optional MySQL connection parameters.
Required Connection Parameters
The following table lists the required connection parameters:
| Parameter | Description | Default Value | Data Type |
|---|---|---|---|
| Connection Url | JDBC connection url. | null | STRING |
| Connection User | Specifies the login name of the user for the connection. | null | STRING |
| Connection Password | Specifies the password of the user for the connection. | null | STRING |
| Enable Local Snapshot Table | Enable Caching while querying. | true | BOOLEAN |
Optional Connection Parameters
The following table lists the optional connection parameters:S
| Parameter | Description | Default Value | Data Type |
|---|---|---|---|
| Case Insensitive Name Matching | Match schema and table names case insensitively. | false | BOOLEAN |
| Case Insensitive Name Matching Cache Ttl | Duration for which remote dataset and table names will be cached. Set to 0ms to disable the cache. | 1m | DURATION |
| Allow Drop Table | Allow connector to drop tables. | false | BOOLEAN |
| Mysql Auto Reconnect | When auto reconnect is enabled, presto tries to reconnect to the mysql server if it finds that connection is down. When it is disabled it will throw an error without retrying if connection is down. | true | BOOLEAN |
| Mysql Max Reconnects | Number of connection retries. | 3 | INTEGER |
| Mysql Connection Timeout | The time to wait while trying to establish a connection before terminating the attempt and generating an error. | 10 sec | DURATION |
| Generic Cache Table Ttl | TTL for cache table expiry in minutes. | 1440 | INTEGER |