SQL Connector
The SQL Connector feature of the connector enables applications to execute standard SQL queries or legacy Database SQL queries against Databasethe database. It converts SQL-92 queries to CQL operationsDatabase API callsGoogle API calls and processes the results. When the connector is configured to work in SQL With CQL Fallback mode, it uses the SQL Connector to handle SQL queries by loading and processing the data in memory. This feature enables the connector to support SQL operations that cannot be executed natively through CQL queries, such as column filtering and table joins.The SQL Connector also provides support for selecting indexes and running parameterized queries.
The connector does not support query prefixes, and instead determines which dialect to use based on the QueryDialect connection setting. By default, QueryDialect is set to SQL so that the connector executes queries using standard SQL syntax. For more information, see QueryDialect.
- Data Types
- Data Types on page 1
- Data Types on page 1
- Data Types on page 1
- Features
- Installing and Using the Product
- Configuring the Product on page 1