When I create a table using a SELECT statement to copy data from another table in Snowflake, the system doesn’t automatically capture this dependency in the OBJECT_DEPENDENCIES view. Hence, would like to confirm is this happening is due to Snowflake doesn’t maintain dependencies between tables based on data copying operations like SELECT INTO or CREATE TABLE AS SELECT (CTAS)?
Is it because the data in the new table may be derived from another table, but Snowflake will treat the new table as an independent object without explicit dependencies on the source table’s data?
Yi Tian Lai is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.