Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-15-2023 10:50 PM
@deepak prasad
I'm not sure it's possible to do that. Even with Unity Catalog enabled, you cannot use shallow clone.
You can do two things here:
Without UC - just simply recreate an empty table in your non-prod environment and do SELECT * from prod storage,
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