This pull request is to support the new marketing attribution package. It adds a new cross-db macro to get the array size and also adds the optional functionality to retrieve the index number (starting from 0) for the unnest() macro. This latter currently only supports Snowflake the rest needs testing/to be added hence it's currently draft pull request.
Checklist
[ ] I have verified that these changes work locally
[ ] I have updated the README.md (if applicable)
[ ] I have added tests & descriptions to my models (and macros if applicable)
Description & motivation
This pull request is to support the new marketing attribution package. It adds a new cross-db macro to get the array size and also adds the optional functionality to retrieve the index number (starting from 0) for the unnest() macro. This latter currently only supports Snowflake the rest needs testing/to be added hence it's currently draft pull request.
Checklist