CData Power BI Connector for AWS Data Management 2019 - Online Help
Questions / Feedback?

Auto Cache

CData Power BI Connector for AWS Data Management 2019 - Build 19.0.7362

Automatically caches the results of SELECT queries into a cache database specified by either CacheLocation or both of CacheConnection and CacheProvider .

Data Type

bool

Default Value

false

Remarks

When AutoCache = true, the connector automatically maintains a cache of your table's data in the database of your choice.

Setting the Caching Database

When AutoCache = true, the connector caches to a simple, file-based cache. You can configure its location or cache to a different database with the following properties:

See Also

  • CacheMetadata: This property reduces the amount of metadata that crosses the network by persisting table schemas retrieved from the AWSDataManagement metadata. Metadata then needs to be retrieved only once instead of every connection.
  • Explicitly Caching Data: This section provides more examples of using AutoCache in Offline mode.
  • CACHE Statements: You can use the CACHE statement to persist any SELECT query, as well as manage the cache; for example, refreshing schemas.

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