Clear Looker Cache

[arijit_acharyya]

Hi All,

I've Looker dashboard which connects to BigQuery table. I've the data cache settings to persist for 6 hours as the backend data refresh frequency is 6 hours. However, if a user is accessing the report and in meantime the backend data gets refreshed, i's showing the data from cache and not the latest data from DB. I tried auto clearing the cache using datagroups and "persist with" but it's not working.

Can someone please guide how I can auto clear the cache whenever there is an ETL performed in backend (The model is not using any PDTs)?

[lsolatorio]

Hi @arijit_acharyya 

Thank you for reaching out to the community.

I understand that you are having challenges with your data freshness in your Looker dashboard. The route you took employing datagroups is indeed one way to do it but if it is not working from your end you can also try the Autorefresh function of Looker.

Here are some useful resources for your reference.

• Caching queries
• Manage data freshness
• Improve Looker Studio performance

Hope this helps.

[RobinLee]

Hi @miso 

My datasource is a big csv file. It took much time for users to open the report when cache expired. May I know if I can adjust the cache period/setting for the .csv datasource? Because I still cannot find any information for .csv datasource's cache setting.

[priyalkaur]

If your Google App Engine app was deleted by a team member and you've attempted to recreate it with the same name but ended up with a different link, restoring the original link can be a bit tricky. Google Cloud Platform doesn't allow re-creation of the same app name with the same URL.

Here are a few steps you can consider:

1. **Contact Google Cloud Support**: If your app was accidentally deleted and you want to restore the original URL, you should reach out to Google Cloud Support as soon as possible. They might be able to assist you in recovering the original app or providing guidance on what options are available.

2. **Check Deleted Resources**: Deleted resources might be available in the Google Cloud Console for a limited time after deletion. Go to the Google Cloud Console, navigate to the App Engine section, and look for any "Deleted Resources" or "Trash" sections. You might find your original app there, and there could be options to restore it.

3. **Unique App ID**: Google App Engine app URLs are based on a unique app ID. If an app is deleted, that app ID might be blocked for reuse for some time. This is to prevent issues with caches, indexes, and other components that could still reference the old app. As a result, creating a new app with the same name will often result in a different URL.

4. **Request the Original URL**: If you have specific reasons for needing the original URL, you might consider contacting Google Cloud Support and explaining your situation. While they might not be able to restore the exact URL, they could potentially provide you with some assistance or guidance.

5. **Update References**: If restoring the original URL is not feasible, you might need to update any references to the old app URL in your code, documentation, and any external systems that interacted with the app. This will help ensure that the new app functions correctly even with a different URL.

Remember that Google Cloud Platform's behavior and policies might change over time, so it's always a good idea to directly contact their support for the most up-to-date and accurate information regarding your specific situation.