Drop staging table
In my legacy system, we use oracle and i need to support for operational reporting.
i am creating tables which will be dropped after used.
Note : i dont need to create permanent table as requiment always change in daily basis. (kind of ad-hoc reporting) but we are suppoting lots of report like these.
Is it best practice in vertica to create then drop table everyday ?