Note: This only includes IT test for when the external table does not have metadata cache enabled. Since we are moving away from the GCP java-docs-samples-testing, the IT for when metadata cache enabled with be added after the migration due to the need to create BigLake table with external connection.

Thank you for opening a Pull Request! Before submitting your PR, there are a few things you can do to make sure it goes smoothly:

• Make sure to open an issue as a bug/issue before writing your code! That way we can discuss the change, evaluate designs, and agree on the general idea
• Ensure the tests and linter pass
• Code coverage does not decrease (if any source code was changed)
• Appropriate docs were updated (if necessary)

Fixes #3134 ☕️