We have shifted from using permanent tables to transient tables for those created and destroyed during application job execution. This change is designed to streamline the lifecycle of application tables and reduce consumer storage costs. Additionally, we have revised the application code to ensure that transient tables are dropped in the event of job failure.
Enhancements
The RUN stored procedure now includes the new parameters
tgt_dentsu_client_keyandsrc_dentsu_client_keywhich can be used instead oftgt_merkury_keyandsrc_merkury_key. Both sets of parameters are currently supported, but we advise transitioning to the Dentsu client key versions as the Merkury key versions will be deprecated in the future.The
client_id_map_vwview now features a newdentsu_client_keycolumn to replace themerkury_keycolumn. Additionally, the default value in this view has been changed fromCONSUMER_MERKURY_KEYtoCONSUMER_DENTSU_CLIENT_KEY.
Furthermore, key value pairsSRC_DENTSU_CLIENT_KEYandTGT_DENTSU_CLIENT_KEYhave been added to the "approved_transcoding_pairs" field. Use these instead of theSRC_MERKURY_KEYandTGT_MERKURY_KEYpairs. While both options are currently supported, users are encouraged to switch to the Dentsu client key versions.We have also implemented backend changes to improve the speed of onboarding new clients.