Time to Live in Google Analytics.

[Xu Chen]

Helping a customer to  figure out how to configure BigQuery doesn’t delete the daily tables created everyday by Firebase version of Google Analytics.

It seems that tables created by Google Analytics are deleted once 60 days has lapsed regardless of what I define at the dataset level.

Basically same question as in 

https://stackoverflow.com/questions/64423218/export-firebase-to-bigquery-dataset-time-to-live

[Kato Richardson]

Hi Xu Chen, great to hear from you.

If you are not on a paid plan, then the retention is set permanently to 60 days. If you are on a paid plan, then new tables should get created with the new TTL. You can create commands to do this for pre-existing tables with a query like the following:

SELECT CONCAT("ALTER TABLE `<PROJECT_ID>.analytics_<PROPERTY_NUM>.", table_id, "` SET OPTIONS (expiration_timestamp=NULL);") AS cmd
FROM `<PROJECT_ID>.analytics_<PROPERTY_NUM>.__TABLES_SUMMARY__`
WHERE table_id LIKE 'events_2020%'

☼, Kato

--
You received this message because you are subscribed to the Google Groups "Firebase Google Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebase-tal...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/firebase-talk/160a45f2-b03a-4e18-ab85-18a06343240dn%40googlegroups.com.

--

Kato Richardson |

Developer Programs Eng |

kato...@google.com |

775-235-8398