To duplicate a table, we have various methods. As per our intent, we will use the method.
Copy both the data and table structure include:
create table sessions1_copy clone sessions1;
create table sessions1_copy as select * From sessions1;
Copy only specific columns into the fresh table along with the specific data set:
Create table sessions1_dm_2_copy as select id1, start_date1, end_date1 from sessions_dm_1 where category = 2;
Copy only specific columns from multiple tables into the latest table with specific data set:
create table users1_sessions12_rpt as select* u1.name, s.start_date1 as session_start_date, s.end_date1 as session.end_date1, from sessions1 s left join user_sessions us on s.id1 = us. session.id1 left join users_1 u on us. user_id1 = u.id1 where u1.active = true;
Copy only table structure, not data
create table users1_copy like users1;
Cloning the data objects will replicate the data, structure, and particular properties of source table. The cloned table will not have the loading history of source table. I hope this blog provides you with the information about Duplicating tables.
Snowflake Related Articles
If you have any queries, let us know by commenting below.
Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!
|Snowflake Training||Oct 03 to Oct 18||View Details|
|Snowflake Training||Oct 07 to Oct 22||View Details|
|Snowflake Training||Oct 10 to Oct 25||View Details|
|Snowflake Training||Oct 14 to Oct 29||View Details|
Keerthi Sai is a Senior Writer at Mindmajix with tons of content creation experience in the areas of cloud computing, BI, Perl Scripting. She also creates content on Salesforce, Microstrategy, and Cobit.
Copyright © 2013 - 2023 MindMajix Technologies