Profile

Hi, Where to set GOOGLE_APPLICATION_CREDENTIALS variable in Pentaho 9.3 for google bigquery connector? I have set it up in .bash_profile file in 8.3 and we have been using it successfully. We have now upgraded to 9.3 and this does not seem to work anymore in 9.3. Getting the below error. Any leads much ...

Thank you very much! That worked like a charm! Really appreciate it. ------------------------------ Ramya Nadig Account Representative Randstad USA ------------------------------

Hi Duarte, I followed your steps but I am now getting an error. It is not clear what that error is- ------------------------------ Ramya Nadig Account Representative Randstad USA ------------------------------

Thank you for your suggestion. I did update the rest client accordingly but no luck. It is still clearing ALL the cached queries not not just from the cda file mentioned in the parameter. ------------------------------ Ramya Nadig Account Representative Randstad USA ------------------------------

Apologies for not being clear. I am calling the API through a rest client (POST method) in PDI and passing the parameter there. I did look into scheduled queries under cache manager. It does not work unless I give a value to all the parameters used. Week is a parameter and it will not help if I hardcode ...

Got it. Using pt.webdetails.cda.cache.EHCacheQueryCache implementation. Specifying the cdaSettingsId as a parameter. Is there an API to build/prime CDA cache for a particular cda file or a particular dataAccessId in a cda file? That can also help solve the issue we are facing. ------------------------------ ...

Thank you! How do I find out which cache implementation is being used? Also, is there an API to build cache for a particular cda file or a particular dataAccessId in a cda file? ------------------------------ Ramya Nadig Account Representative Randstad USA ------------------------------

I am currently using the below: REST Client on PDI - method - POST URL- /pentaho/plugin/cda/api/cacheMonitor/removeAll Parameter- cdaSettingsId (cda file location/path) When I run this, it is clearing the whole cda cache and not just the queries cached from a particular cda file. Is there a ...

I am currently using the below: REST Client on PDI - method - POST URL- /pentaho/plugin/cda/api/cacheMonitor/removeAll Parameter- cdaSettingsId (cda file location/path) When I run this, it is clearing the whole cda cache and not just the queries cached from a particular cda file. Is there a ...