Readds the external type. This is slightly confusing because EXTERNAL as a type in Databricks just means that table is stored in the customers storage location, but from the attached bug, it sounds like not having it as a materialization type can cause some adapter compliance issues.
Checklist
[x] I have run this code in development and it appears to resolve the stated issue
[x] This PR includes tests, or tests are not required/relevant for this PR
[x] I have updated the CHANGELOG.md and added information about my change to the "dbt-databricks next" section.
Resolves #721
Description
Readds the external type. This is slightly confusing because EXTERNAL as a type in Databricks just means that table is stored in the customers storage location, but from the attached bug, it sounds like not having it as a materialization type can cause some adapter compliance issues.
Checklist
CHANGELOG.mdand added information about my change to the "dbt-databricks next" section.