clone_schema()#
relationalai.app
#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.
Parameters#
| Name | Type | Description |
|---|---|---|
<target_schema_name> | STRING | The name of the new schema to create (case-sensitive). |
<source_schema_name> | STRING | The name of the existing schema to clone (case-sensitive). |
Example#
Use clone_schema() to clone an existing RAI schema into a new schema:
#-- NOTE: RAI schema names are case-sensitive
CALL relationalai.app.clone_schema('my_target_schema', 'my_source_schema');