You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I created a simple model to verify the configuration.
select
date_time,
json_extract_scalar(message, '$.id') as message_type,
message
from
{{ source("ingress", "ingress_sample") }} LIMIT100
When I run the model the following happens:
It takes a couple of seconds to run
Terminal prints the following error ICEBERG_FILESYSTEM_ERROR: Cannot create a table on a non-empty location: s3://<data_bucket>/<schema>/<model_name>/e563b5ca-acd4-4924-ac79-e48cf5d600e4. You may need to manually clean the data at location 's3://<athena_output_bucket>/tables/ee6f7919-083f-4036-96f5-3ed6e498ffd3' before retrying. Athena will not delete data in your account.
I can see files in s3://<data_bucket>/<schema>/<model_name>/
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
Uh oh!
There was an error while loading. Please reload this page.
-
Hi,
I am transitioning my project from dbt-glue to dbt-athena. I use iceberg tables in AWS.
I configured the following target in my
proiles.yaml
:and my dbt_project.yaml
I created a simple model to verify the configuration.
When I run the model the following happens:
ICEBERG_FILESYSTEM_ERROR: Cannot create a table on a non-empty location: s3://<data_bucket>/<schema>/<model_name>/e563b5ca-acd4-4924-ac79-e48cf5d600e4. You may need to manually clean the data at location 's3://<athena_output_bucket>/tables/ee6f7919-083f-4036-96f5-3ed6e498ffd3' before retrying. Athena will not delete data in your account.
s3://<data_bucket>/<schema>/<model_name>/
s3://<athena_output_bucket>/
is emptyAny ideas where the problem lies?
Beta Was this translation helpful? Give feedback.
All reactions