仅克隆雪花元数据 [英] Clone Snowflake metadata only

问题描述

我想克隆一个Snowflake数据库的外壳(仅元数据，没有数据).这可能吗?我已经检查了文档，但没有找到解决方案.

I want to clone the shell of a Snowflake database (metadata only, no data). Is this possible? I have checked the documentation and haven't found a solution.

推荐答案

如果您只是想获取现有数据库的空外壳，则可以克隆整个数据库，然后对所有数据库进行截断数据库中存在的表.克隆不添加任何数据，并且在克隆上截短将非常快(同时不影响原始表).

If you're just trying to get an empty shell of an existing database, you could clone the entire database, and then script out a truncate of all of the tables that exist in the database. The clone doesn't add any data, and the truncate would be very quick on the clone (while not affecting the original tables).

这篇关于仅克隆雪花元数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！