Changes in access to normalized LTV data

[Arkadiusz Komarzewski]

tl;dr: introducing a BigQuery view for revenue_derived.client_ltv_v1 - read on if you're using this table.

Data users,

As part of work on implementing revenue data access policies [1] we're restructuring [2] LTV tables and the way to access them. We're introducing a restricted view revenue.client_ltv_normalized over revenue_derived.client_ltv_v1 table. If you are using this table, please switch your queries to the view, making sure you have required access rights [3].

We'll be disabling direct user access to the table by the end of next week, from this point forward the view will be the right way for accessing the data.

Feel free to reach out on #data-help on Slack if you have questions.

[1] https://docs.google.com/document/d/1WS5t4YDA3E_o_N49e7JtROVPReMMjtw_8Fn4bvR9BJ0/edit#

[2] https://bugzilla.mozilla.org/show_bug.cgi?id=1714471

[3] https://mana.mozilla.org/wiki/display/DATA/Revenue+data+in+BigQuery