I need to disable - or at least reduce - the cache duration in a Google Spreadsheet Query. At present, adding/subtracting/renaming columns in the GSheet cause ingestion errors for an hour or more until the cache expires. Allegedly there are cache parameters that can bet set, but none appear in the parameter dropdown. Where might I find such settings?
Thanks in advance for any insight.
2 Community Answers
Paul Johnson —
On the connection options property add a parameter called “AutoCache” and set the value to “False”.