test: consolidate duplicate hourly test PRs into single PR

[anandgupta42]

Multiple hourly test-discovery PRs (#499, #502, #504, #506, #507, #508, #510, #511, #512) were created with heavily overlapping test coverage for MongoDB driver, SSH tunnel, env var loading, and dbt profiles. Most of this coverage was already merged to main via earlier PRs. Additionally, PR #494 adds sanity suite expansion that should be included.

This issue tracks consolidating the genuinely new tests from these PRs into a single clean PR and closing the redundant ones.