[Bug] Glue CLDB is breaking with incremental run

### Is this a new bug?

- [x] I believe this is a new bug
- [x] I have searched the existing issues, and I could not find an existing issue for this bug

### Which packages are affected?

- [x] dbt-adapters
- [ ] dbt-tests-adapter
- [ ] dbt-athena
- [ ] dbt-athena-community
- [ ] dbt-bigquery
- [ ] dbt-postgres
- [ ] dbt-redshift
- [x] dbt-snowflake
- [ ] dbt-spark

### Current Behavior

Hi All,
I am uploading manifest from main branch and compare with feature branch pull request . however, it is failing with Glue snowflake CLD with below error.

Error:
Runtime Error
Compilation Error in model curated_gs_end_of_day_rates (models/crd/gs/curated_gs_end_of_day_rates.sql)
When searching for a relation, dbt found an approximate match. Instead of guessing
which relation to use, dbt will move on. Please delete "ID_DEV_CDAT"."idap_brefcv_dev_curated_gs"."clean_brefcv_gs_end_of_day_rates", or rename it to be less ambiguous.
Searched for: ID_DEV_CDAT.ID_DEV_CURATED_GS.CLEAN_GS_END_OF_DAY_RATES
Found: "ID_DEV_CDAT"."id_dev_curated_gs"."clean_gs_end_of_day_rates"

Command:

dbt compile \
--select state:modified+ \
--defer \
--state dbt_state

### Expected Behavior

It should run and find the modified tables .

### Steps To Reproduce

Reproduce steps:

All tables are iceberge snowflake glue catalog integrated feature

1. Upload file manifest to s3
2. Import manifest to dbt_state folder
3. Run below commands

dbt compile \
--select state:modified+ \
--defer \
--state dbt_state

### Relevant log output

```shell

```

### Environment

```markdown
Library version :
python 3.12
pip install dbt-core==1.10.8 dbt-snowflake==1.10.0
```

### Additional Context

_No response_