Improve debug logging in Airbyte provider

[rawwar]

Description

related to #43186

Use case/motivation

Review existing code, add any additional debug logging that can be helpful to fix failure scenarios'

Related issues

No response

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[pierceroberts]

Hello @rawwar, is it possible if I put a draft PR for this work? Thanks!

[pierceroberts]

@rawwar Any chance you can take a peak at the PR I have up for review please? Thanks!

[eladkal]

Fixed in #51503