Currently we have to manually write the sql to get a field from an sde or context field every time, this can lead to us having to split models or macros when they are otherwise the same. I can also never remember which one is which.
This is the first step to adding other warehouses to the combine_columns macro, I'm not currently working on that but this will be useful if/when we do develop that further.
Checklist
[x] I have verified that these changes work locally
[x] I have updated the README.md (if applicable)
[x] I have added tests & descriptions to my models (and macros if applicable)
Description & motivation
Currently we have to manually write the sql to get a field from an sde or context field every time, this can lead to us having to split models or macros when they are otherwise the same. I can also never remember which one is which.
This is the first step to adding other warehouses to the
combine_columnsmacro, I'm not currently working on that but this will be useful if/when we do develop that further.Checklist