feat: backend to add key to multiple domains in one call

[langswei]

As part of the RUM for AEM CS initiative, we are getting requests for 100s of domains to share a single domain key. It would be a nice convenience to create the domain key for all domains in one request.

This PR is to document and discuss a change to the table function helix_reporting.ROTATE_DOMAIN_KEYS which is a pre-requisite to a run-query change. Upon approval, I will make the table function change in BigQuery and move on to the run-query changes.

This change is backward compatible -- a single domain may still be passed in. A test implementation exists at helix_reporting.ROTATE_DOMAIN_KEYS_MULTIPLE for now.

CALL helix_reporting.ROTATE_DOMAIN_KEYS_MULTIPLE(
    '<uber_domain_key>',
    '<domain or comma-separated domain list>',
    'UTC',
    -1,
    '-',
    '<desired domain key>',
    true,
    'multiple_test'
);

select * from helix_reporting.domain_keys where note = 'multiple_test';

[github-actions[bot]]

This PR will trigger a minor release when merged.

[langswei]

I think it is weird to do this in a for loop when both UPDATE and INSERT INTO are perfectly fine in accepting a series of rows.

@trieloff Good call, check now.

[langswei]

Updated table function in BQ and no further run-query changes required. Tested and works.

[trieloff]

:tada: This PR is included in version 3.16.0 :tada:

The release is available on:

• v3.16.0
• GitHub release
• v3.16.0

Your semantic-release bot :package::rocket: