JDBC Driver for Google Sheets

Build 22.0.8462

Schema

This section provides a complete list of the Schema properties you can configure in the connection string for this provider.


PropertyDescription
LocationA path to the directory that contains the schema files defining tables, views, and stored procedures.
BrowsableSchemasThis property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC.
TablesThis property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC.
ViewsRestricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC.
TypeDetectionSchemeDetermines how to determine the data types of columns.
HeaderIndicates whether or not the first row should be used as a column header.
PrimaryKeyIdentifierSet this property to control the name of the primary key.
DefineTablesDefine the tables within the Google Spreadsheet.
OrientationIndicates whether the data in the sheet is laid out horizontally or vertically.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462