[Bug] Error running dbt docs generate with Federated Query database

### 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?

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

### Current Behavior

I'm trying to run dbt docs generate with Federated Query data using the Mysql Connector and it returns the following error:

```
04:02:06 Concurrency: 5 threads (target='doc')
04:02:06
04:07:13 Building catalog
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:10 dbt encountered 13 failures while writing the catalog
```
It seems that AthenaCatalogType does not support FEDERATED
```
class AthenaCatalogType(Enum):
GLUE = "GLUE"
LAMBDA = "LAMBDA"
HIVE = "HIVE"
```

### Expected Behavior

I'm trying to run dbt docs generate with Federated Query data using the Mysql Connector and it returns the following error:

```
04:02:06 Concurrency: 5 threads (target='doc')
04:02:06
04:07:13 Building catalog
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:10 dbt encountered 13 failures while writing the catalog
```

### Steps To Reproduce

1 Environment
```
dbt-adapters 1.16.3
dbt-athena 1.9.4
dbt-clickhouse 1.8.5
dbt-common 1.27.1
dbt-core 1.8.8
dbt-extractor 0.6.0
dbt-protos 1.0.348
dbt-semantic-interfaces 0.5.1
dbt-snowflake 1.8.4
```
2 run dbt docs generate with Federated Query data using the Mysql Connector

### Relevant log output

```shell
04:02:06 Concurrency: 5 threads (target='doc')
04:02:06
04:07:13 Building catalog
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:03 Encountered an error while generating catalog: 'FEDERATED' is not a valid AthenaCatalogType
04:49:10 dbt encountered 13 failures while writing the catalog
```

### Environment

```markdown
- OS:Ubuntu 20.04
- Python: 3.10.12
- dbt-adapters:
- :
dbt-adapters 1.16.3
dbt-athena 1.9.4
dbt-clickhouse 1.8.5
dbt-common 1.27.1
dbt-core 1.8.8
dbt-extractor 0.6.0
dbt-protos 1.0.348
dbt-semantic-interfaces 0.5.1
dbt-snowflake 1.8.4
```

### Additional Context

_No response_