What change(s) does this PR introduce?
Adds the ability to set source database and schema via environment variable.
Did you update the CHANGELOG?
[x] Yes
Does this PR introduce a breaking change?
[ ] Yes (please provide breaking change details below.)
[x] No (please provide an explanation as to how the change is non-breaking below.)
If fetching settings from environment variables fails, defaults will be returned, causing a fallback to the current var values in src_zendesk.yml.
Did you update the dbt_project.yml files with the version upgrade (please leverage standard semantic versioning)? (In both your main project and integration_tests)
[x] Yes
Is this PR in response to a previously created Bug or Feature Request
[x] Local (please provide additional testing details below)
I tested by setting both the new var values (zendesk_schema_env_var and zendesk_database_env_var) and the current var values (zendesk_schema and zendesk_database) and running dbt build against a Snowflake warehouse.
Select which warehouse(s) were used to test the PR
[ ] BigQuery
[ ] Redshift
[x] Snowflake
[ ] Postgres
[ ] Databricks
[ ] Other (provide details below)
Provide an emoji that best describes your current mood
Are you a current Fivetran customer? Yes
What change(s) does this PR introduce? Adds the ability to set source database and schema via environment variable.
Did you update the CHANGELOG?
Does this PR introduce a breaking change?
If fetching settings from environment variables fails, defaults will be returned, causing a fallback to the current
var
values insrc_zendesk.yml
.Did you update the dbt_project.yml files with the version upgrade (please leverage standard semantic versioning)? (In both your main project and integration_tests)
Is this PR in response to a previously created Bug or Feature Request
How did you test the PR changes?
I tested by setting both the new
var
values (zendesk_schema_env_var
andzendesk_database_env_var
) and the currentvar
values (zendesk_schema
andzendesk_database
) and runningdbt build
against a Snowflake warehouse.Select which warehouse(s) were used to test the PR
Provide an emoji that best describes your current mood
:pray: