[ELE-167] store actual schema(s) being used in invocation

[ayalalo]

Is your feature request related to a problem? Please describe. Elementary tables records the target schema(s) for each invocation. In case the schemas undergo change (e.g: usage of macros such as generate_schema_name) the custom value are not stored.

Describe the solution you'd like On all relevant elementary tables add a column to fetch schemas

Describe alternatives you've considered No alternatives

Additional context Add any other context or screenshots about the feature request here.

Would you be willing to contribute this feature? Absolutely :)

_ELE-167

[oravi]

Hi @ayalalo !

Here's what's needed to work on this issue -

• Add invocation_schemas new column to the dbt_invocations here
• Add invocation_schemas field and value here. The value should be just the schemas jinja variable

Please let me know if you have any followup questions!

[Maayan-s]

Hi @ayalalo, Wanted to follow up here and ask if you plan to work on this issue? If not I will mark it as open for contribution, and if yes I'll assign to you :)

[aarushisoni]

Hi! I want to work on this issue; please assign me to this.

[Maayan-s]

Thanks @aarushisoni! Let me know if you need help. (The code is on the dbt package repo, here: https://github.com/elementary-data/dbt-data-reliability)

[elongl]

Hi @aarushisoni, do you need any help or guidance? Thanks.

[aarushisoni]

Hi @aarushisoni, do you need any help or guidance? Thanks.

hi can you please explain this issue also can you please tell me the file in which i need to make chnages