Snowflake - Zero-Copy Cloning - Working Session

[@saddusumi6805]

Good explanation

[@sudhakarreddys8172]

Thanks for the video and nice explanation

[@anudavuluri835]

Thank you so much for the video & quick response a well.

[@divyagouda5285]

Super explanation. Thank you

[@aamirqureshi9058]

good info

[@Ajjeshh]

Thanks for the detailed explanation. I have a question - Can we clone databases across virtual warehouses under same account? bcz, i am assuming, in real time we use one VW for dev/test and separate VW for prod?

[@mrjana520]

Virtual Warehouses are granted to Users not database wise, if the user has write privileges to databases on that databases you can do what ever you want not only cloning

[@yamuna-p4u]

Bro you told cost associated for cloned table after retention period that means after retention period it goes to fail safe period know for that cost associated you are telling bro

[@mrjana520]

Not like that, if you are creating a clone on history data of any table, in that case once the retention period is over for the original table, there will be storage cost for the cloned table. There is no link to fail safe period here.

[@kpfgf2361]

Thanks for your explanation. How do they identify whether the database table is created as clone object or as select * from any table bcoz you mentioned if we create the copy the data by using as select * they will charge and no charge if we use clone.. I mean by looking at the table would there be any reference how the data copy or clone executed? Or do they have any sql query execution logs. Pls answer..

[@mrjana520]

Have a look at INFORMATION_SCHEMA.TABLES_STORAGE_METRICS, there are 2 fields, ID and CLONE_GROUP_ID. If CLONE_GROUP_ID is different from ID then that table is Cloned table, if both are same then that is original table..

[@kpfgf2361]

Excellent, i got your point. Yes both the filelds contain different value incase of clonned object. Thanks alot!!!!

[@ks97626]

Hello Sir. First of all Thank you so much for the excellent sessions. One quick question. Cloning works only with in a Account only i.e. Dev, Test, Prod dbs are in same account. What if Dev & Test are in one account and Prod in another environment. (assumption - prod has High configurations and Dev & Test have bit low configurations). How can we clone from Prod to Dev/Test then. Hope my question is clear. Thank you so much sir.

[@mrjana520]

What if Dev & Test are in one account and Prod in another environment. -- This will not happen in Real-time, no one tries to increase their billing. assumption - prod has High configurations and Dev & Test have bit low configurations -- You can't assume without knowing how the cost is calculated in Snowflake, configurations are dependent on environment but not based on account, in single account you can maintain different databases and different configuration. And the thing is Cloning will never happen acroos different accounts as their storage layers are completely different/

[@ks97626]

@@mrjana520 Thank you sir. Its clear now.

[@deepthikotipalli]

hi sir, in prod to dev environment we use real time data.then cloning how will work.please explain.this is one of my interview question.

[@mrjana520]

If your Prod data is sensitive then you shouldn't clone it to Dev or Test, in that case we can ask users to provide sample data for testing or you can set up your own dummy data..

[@rohitmanderwad6034]

can we clone transient tables?

[@mrjana520]

yes, we can

[@sasisai-wk6iu]

when we delate a source table any effect in clone table

[@mrjana520]

data wise no changes but space wise yes, after deleting the original table, space will be allocated to cloned table

[@deepthikotipalli]

hi sir,can we share cloned objects to different accounts.

[@mrjana520]

cloned objects are independent of original table after cloning , so we can do what ever we want, I mean sharing, add data, delete data, create views etc..