Daniël Heres

> hey, can I have this issue? > I'm quite new to this so I might need some guidance Would be great! @houqp can you assing this to @akbhuker ?...

It might also be wise/a good start to utilize the storage APIs better, e.g. such as using multi object delete which does up to 1000 deletes in one call: https://docs.aws.amazon.com/AmazonS3/latest/API/API_DeleteObjects.html

Hi @dmateusp Thanks for opening the issue! I think `seed` is not working now yet. We have to do some analysis to see what changes are needed to make it...

Thanks, interesting find! It would be good to find out in what cases Athena does support CTEs. Maybe we need to wrap the inner query in a ```select * from(with...```?...

Yeah, that makes sense, that's also how I use dbt generally. We could likely change the adapter to wrap all queries in a select to workaround this issue.

Maybe something that should be added to the docs while we don't workaround that Athena doesn't support it in a create table/view as statement?

I believe we should just change the create_view_as and create_table_as macro's to generate a view starting with `SELECT *`. Original macro's are here: https://github.com/fishtown-analytics/dbt/blob/dev/marian-anderson/core/dbt/include/global_project/macros/adapters/common.sql Help welcome!

Thank you for this PR! Will try looking into it soon.

Does seed insertion work for you now? I get the error: ` An error occurred (InvalidRequestException) when calling the StartQueryExecution operation: No location was specified for table. An S3 location...

Nice idea - seems like a missing piece indeed. I think we should also revisit the kernels themselves, as we want to write the results to the input array instead...