I am trying to create standard glue external tables with terraform, replacing a number of lake formation governed tables. The original lake governed tables had no table specific permissions granted and where dropped from the control panel.
Any attempt to create a standard external table from any means (cli, boto3, glue console, lake formation console, terraform) I receive a AlreadyExistsException on that table. When calling the table from the cli or with boto3 it can't find the corresponding table (EntityNotFound or similar)
If in either terraform or the control panel the table type is changed to governed, the table is created successfully (so with all the same settings as before i.e. region, path, classification etc).
We would like to be able to create these tables as standard external tables, but seem completely unable to with no idea whether this is a bug of some sort (likely in lake formation?) or we're missing something?
Any help is appreciated
AWS OFFICIALAktualisiert vor 2 Jahren