JDBC Driver for SurveyMonkey

Build 20.0.7654


Restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC.

Data Type


Default Value



Listing the views from some databases can be expensive. Providing a list of views in the connection string improves the performance of the driver.

This property can also be used as an alternative to automatically listing views if you already know which ones you want to work with and there would otherwise be too many to work with.

Specify the views you want in a comma-separated list. Each view should be a valid SQL identifier with any special characters escaped using square brackets, double-quotes or backticks. For example, Views=ViewA,[ViewB/WithSlash],WithCatalog.WithSchema.`ViewC With Space`.

Note that when connecting to a data source with multiple schemas or catalogs, you will need to provide the fully qualified name of the table in this property, as in the last example here, to avoid ambiguity between tables that exist in multiple catalogs or schemas.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654