Kevin Wilkie makes a smaller clone:
One table at a time. Now I know what you’re thinking “Copying some of my databases would take forever…”
Well, don’t fret, my friends! Snowflake has a way!
Click through to see how you can clone an entire schema, including relevant tables, views, functions, procedures, etc. Kevin also specifies what types of objects do not copy, so check that out.