clone_schema(<target_schema_name>, <source_schema_name>)

Clones an existing RelationalAI (RAI) schema to a new schema within the RAI Native App for Snowflake. Snapshots of the source schema’s data are cloned, but CDC streams are not. The target schema gets a new set of schema roles. Requires the schema_admin application role.


<target_schema_name>STRINGThe name of the new schema to create (case-sensitive).
<source_schema_name>STRINGThe name of the existing schema to clone (case-sensitive).


Use clone_schema() to clone an existing RAI schema into a new schema:

-- NOTE: RAI schema names are case-sensitive
CALL'my_target_schema', 'my_source_schema');

See Also#