QuestionQ24

VerifiedOfficial exam objectives/topics

A Data Engineer needs to create a new, empty table named CURRENT_STUDENT_COPY_DATA with the same structure as the CURRENT_STUDENT table.

Which statement should be used?

Explanation

In Snowflake, CREATE TABLE <new_table> LIKE <source_table> creates an empty table with the same column definitions as the source table, without copying its data. A CLONE includes the source table’s existing data.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!