ConnectOnOpen
This property specifies whether to connect to the Google Sheets when the connection is opened.
Data Type
bool
Default Value
false
Remarks
When set to true, a connection will be made to Google Sheets when the connection is opened. This property enables the Test Connection feature available in various database tools.
This feature acts as a NOOP command as it is used to verify a connection can be made to Google Sheets and nothing from this initial connection is maintained.
Setting this property to false may provide performance improvements (depending upon the number of times a connection is opened).