[CT-1775] Convert remaining integration tests (dbt-snowflake)

[Fleid]

The integration folder should be emptied, all remaining tests should be converted to the new framework in the functional folder.

Most conversions should be ports from the core repo, others will be specific to Snowflake.

[bennylu2]

Why is it being moved from integration to functional?

[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 remove the stale label or comment on the issue, or 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.