Move current AWS integration test to separate group and add mock based tests in CI pipeline

[lliangyu-lin]

Feature Request / Improvement

The current AWS integration tests are not well maintained because they are not enabled in the CI pipeline and can only be executed locally when specific AWS environment variables are set.

To improve test coverage and maintainability, ideally AWS integration tests should be split into two separate groups:

• Mock-based integration tests (e.g., using Moto or MinIO):
  These tests simulate AWS services and can run safely in CI without requiring AWS credentials.

• Real AWS service integration tests:
  These tests interact with actual AWS services and should be run optionally, based on a configuration (e.g., test properties or profile-based settings), rather than relying on local environment variables.

Query engine

None

Willingness to contribute

• I can contribute this improvement/feature independently
• I would be willing to contribute this improvement/feature with guidance from the Iceberg community
• I cannot contribute this improvement/feature at this time