snowflake schema - Future data is not yet available for table error when running Create or replace table CLONE

Question

Recently, in the last few days, we're having lot's of errors about "Future data is not yet available for table " when running a

CREATE OR REPLACE TABLE <tbl name> CLONE <db>.<schema>.tmp_<tbl name> COPY GRANTS

query. This was happening out-of-the-blue and there's no any indication about this specific error in the documentation or in the knowledge base.

What's the error in here? To what is it referring to and how can we avoid it?

Thanks!

Answer 1

The tables you want to clone seem to be marked as dropped. Probably undropping your table is helping: https://docs.snowflake.com/en/sql-reference/sql/undrop-table.html