Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[FEATURE] - Add string constant support for XTS macro #192

Open
RonniePitts opened this issue Apr 23, 2023 · 0 comments
Open

[FEATURE] - Add string constant support for XTS macro #192

RonniePitts opened this issue Apr 23, 2023 · 0 comments
Assignees
Labels
feature This is is requesting a new feature

Comments

@RonniePitts
Copy link

RonniePitts commented Apr 23, 2023

In the XTS macro we need to specify the SATELLITE name as an additional column which typically exists in the staging macro as the below example shows :

image

These additional devised columns can be painful when multiple satellite are sourced from the staging model.

My feature is to support a string constant as we do in the staging macro which would allows us to reference a macro to return the node name.

For example:
src_satellite:
SAT_CUSTOMER_DETAILS:
sat_name:
SATELLITE_NAME: '!{{get_satobject(this}}}'
hashdiff:
HASHDIFF: CUSTOMER_HASHDIFF

get_satobject receives the SAT_CUSTOMER_DETAILS node and returns the node name of which is SAT_CUSTOMER_DETAILS given this is typically what the string constant name is in the staging model derived fields anyhow.

AB#5362

@RonniePitts RonniePitts added the feature This is is requesting a new feature label Apr 23, 2023
@DVAlexHiggs DVAlexHiggs added feature This is is requesting a new feature and removed feature This is is requesting a new feature labels May 15, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature This is is requesting a new feature
Projects
None yet
Development

No branches or pull requests

2 participants