-
Notifications
You must be signed in to change notification settings - Fork 93
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
external_location
ignored when table_type='hive'
#539
Comments
@TassOlympus do you use a workgroup with enforced "configurations"? If that's the case external_location is fully ignored. |
@nicor88 there is a location specified in the work group being used but specifying "external_location" works for iceberg tables regardless of the workgroup location, it's just hive tables where it is ignored. I would imagine that should a location be specified at the model level that it would override the workgroup location? Is there a reason why it is different across table types? |
Iceberg table are managed tables, therefore the workgroup location is not used.
|
Thanks @nicor88, this is useful and helped resolve our issue (we went for the separate work group approach), could documentation perhaps be updated to articulate this information under https://github.com/dbt-athena/dbt-athena#table-location? The note was misleading since it did not apply to iceberg tables and seems to speak directly to "s3_data_naming" alone |
@TassOlympus good catch, docs must be updated indeed. Feel free to submit a PR to address this. |
Using the latest version 1.7.0 with a model that has a hive table type used to allow the specification and enforcement of the
external_location
configuration within the models, it appears it is now being ignored in the latest version when new hive tables are createdThe text was updated successfully, but these errors were encountered: