Use print instead of log

[ehmartens]

Describe the feature

Rather than using the log Jinja function to output generated code, use the print Jinja function added in PR-4701

Describe alternatives you've considered

Leave as-is.

Additional context

This isue is based on a suggestion from @emmyoop (here) to allow for cleaner output from the macros using the new global --quiet flag in dbt.

@jaypeedevlin and I worked on PR-4701 together to implement the solution she outlined in dbt-core, and would like to complete this next part of it as well.

Who will this benefit?

Users who would like to copy the output from dbt run-operation directly into a file without having to remove info and warnings.

Are you interested in contributing this feature?

Yep!

[github-actions]

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.

[github-actions]

Although we are closing this issue as stale, it's not gone forever. Issues can be reopened if there is renewed community interest. Just add a comment to notify the maintainers.

[pdfrod]

Can this be re-opened? As far as I can tell there's still no easy way to feed the output of dbt run-operation directly into a file without the logging noise.

[jaypeedevlin]

@pdfrod there's actually an open PR (linked above) which actions this which I'm trying to nudge towards a merge/release!