>
Say we we have a script that gets data from WikipediaZeroUsage_14574251, >would we need to temporarily change the script to get data from WikipediaZeroUsage_>>14574251_15423246 for like a day and then change it back >to WikipediaZeroUsage_14574251 or would that be a permanent change until another schema revision?
Sorry it was not clear, no. You would have a union in this case.
For example:
-- renamed table, no more new records from 2017/03/23
select * from WikipediaZeroUsage_14574251_15423246
UNION
-- new data gets entered here
select * from WikipediaZeroUsage_14574251
Make sense?