[Bug] Improve dbt-spark table listing

### 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
- [ ] dbt-athena
- [ ] dbt-athena-community
- [ ] dbt-bigquery
- [ ] dbt-postgres
- [ ] dbt-redshift
- [ ] dbt-snowflake
- [x] dbt-spark

### Current Behavior

Spark is coming out with support for `show tables extended` which will improve performance of the dbt-spark adapter. This is a reminder to hook this new functionality into the dbt-spark adapter.

Particularly for Iceberg tables. https://github.com/apache/iceberg/issues/5782

### Expected Behavior

use new api

### Steps To Reproduce

in this environment

### Relevant log output

```shell

```

### Environment

```markdown
- OS:
- Python:
- dbt-spark:
- :
```

### Additional Context

_No response_