[x] I have run this code in development and it appears to resolve the stated issue
[x] This PR includes tests, or tests are not required/relevant for this PR
[x] This PR has no interface changes (e.g. macros, cli, logs, json artifacts, config files, adapter interface, etc) or this PR has already received feedback and approval from Product or DX
resolves #1031
Problem
The rename macro for tables and views uses only the identifier. It's expected to use the fully qualified name.
Solution
Update these macros to incorporate the new name into the source relation, thereby preserving the database and schema.
Checklist