https://community.databricks.com/t5/data-engineering/shallow-copy-in-databricks/m-p/4393#M1134 <P>Hi, I am new to Databricks. I need to setup a non-prod environment for which I need data of prod to be cloned in non-prod. Explored some and got to know about shallow copy. Is it possible to do shallow copy across environments? or Is it possible to do shallow clonning across different databricks instances?</P> Mon, 15 May 2023 06:38:52 GMT _deepak_ 2023-05-15T06:38:52Z https://community.databricks.com/t5/data-engineering/shallow-copy-in-databricks/m-p/4393#M1134 <P>Hi, I am new to Databricks. I need to setup a non-prod environment for which I need data of prod to be cloned in non-prod. Explored some and got to know about shallow copy. Is it possible to do shallow copy across environments? or Is it possible to do shallow clonning across different databricks instances?</P> Mon, 15 May 2023 06:38:52 GMT https://community.databricks.com/t5/data-engineering/shallow-copy-in-databricks/m-p/4393#M1134 _deepak_ 2023-05-15T06:38:52Z https://community.databricks.com/t5/data-engineering/shallow-copy-in-databricks/m-p/4394#M1135 <P>@deepak prasad​&nbsp;</P><P>I'm not sure it's possible to do that. Even with Unity Catalog enabled, you cannot use shallow clone.</P><P>You can do two things here:</P><P>Without UC - just simply recreate an empty table in your non-prod environment and do SELECT * from prod storage,</P><P>With UC - make sure that two workspaces are in the same metastore and you can either create views based on prod data or do a deep clone from prod to non-prod</P> Tue, 16 May 2023 05:50:30 GMT https://community.databricks.com/t5/data-engineering/shallow-copy-in-databricks/m-p/4394#M1135 daniel_sahal 2023-05-16T05:50:30Z