Cannot drop Iceberg table

When I attempt to remove Iceberg table created as ‘CREATE TABLE myschema.mytable as SELECT …’ on NAS data source.
I am getting following explanation:
Cannot drop table [myschema.mytable] since it has child tables

How can I drop/remove such table ?

Thank you

You are hitting a quirky Dremio’s feature that is called “child tables” which we are planning to deprecate. Essentially tables within the tables. Those have some issues associated with them - you are hitting one of them (obscurity).

Can you run this and see if there are other tables under [myschema.mytable]?

If yes - delete child tables first.