Question

A data engineer creates a table named ORDERS in the SALES schema of the ANALYTICS database. Later, another team creates a table also named ORDERS in the MARKETING schema of the same ANALYTICS database. When troubleshooting, the engineer asks whether these two tables conflict. Based on Snowflake's object hierarchy, which statement is correct?

Accepted Answer

The two tables coexist without conflict because a table is a schema-scoped object, and names only need to be unique within a schema.

Answer

The two tables cannot coexist because table names must be unique within a database.

Answer

The two tables cannot coexist because table names must be unique across the entire Snowflake account.

Answer

The second CREATE TABLE statement will silently overwrite the first table since they share the same name.