Excel Add-In for Cassandra

Build 24.0.9060

Fine-Tuning Data Access

Fine Tuning Data Access

You can use the following properties to gain greater control over Cassandra API features and the strategies the add-in uses to surface them:

  • AllowFiltering: Set this property to allow the server to process slow-performing searches.
  • UseJsonFormat: Set this property to use CQL literals instead of JSON.
  • QueryPassthrough: This property enables you to use native CQL statements instead of SQL.
  • RowScanDepth: This property determines the number of rows that will be scanned to detect column data types when generating table metadata.

    This property applies if you are working with the dynamic schemas generated from Automatic Schema Discovery or if you are using QueryPassthrough.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060