Add integration test for source node rendering

[pankajastro]

Description

Add example DAG to run integration tests for source node rendering feature

Success Run: https://github.com/astronomer/astronomer-cosmos/actions/runs/11853052767/job/33032439737?pr=1327#step:7:449

Failed Run For Dbt < 1.5 https://github.com/astronomer/astronomer-cosmos/actions/runs/11852864026/job/33031862113?pr=1327

Related Issue(s)

closes: https://github.com/astronomer/astronomer-cosmos/issues/1155 closes: https://github.com/astronomer/astronomer-cosmos/issues/1229

Breaking Change?

Checklist

• [x] I have made corresponding changes to the documentation (if required)
• [x] I have added tests that prove my fix is effective or that my feature works

[cloudflare-workers-and-pages[bot]]

Deploying astronomer-cosmos with    Cloudflare Pages

Latest commit:	42e485d
Status:	✅  Deploy successful!
Preview URL:	https://2f437abe.astronomer-cosmos.pages.dev
Branch Preview URL:	https://source-rendering-test.astronomer-cosmos.pages.dev

View logs

[codecov[bot]]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 96.03%. Comparing base (8ec46d2) to head (42e485d). Report is 1 commits behind head on main.

Additional details and impacted files

```diff @@ Coverage Diff @@ ## main #1327 +/- ## ========================================== + Coverage 95.85% 96.03% +0.17% ========================================== Files 67 67 Lines 3983 3983 ========================================== + Hits 3818 3825 +7 + Misses 165 158 -7 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.