Only issue with CTAS approach is Table/column constraints. Constraints are not copied and it can cause issues in the target system(s). For example, if you have auto increment column, CTAS will not copy the constraint. To keep the table definition as is, use CREATE TABLE LIKE <source table> and then copy the data using insert/insert overwrite.