Clone Statement Builders

SQLAlchemy-style statement builders for clone operations.

Top-Level Functions

matrixone.clone_builder.clone_table(target_table: str | Type) CloneTable[source]

Build a CREATE TABLE … CLONE statement.

Example:

stmt = clone_table('users_copy').from_table('users')
client.execute(str(stmt))
matrixone.clone_builder.clone_database(target_db: str) CloneDatabase[source]

Build a CREATE DATABASE … CLONE statement.

Example:

stmt = clone_database('dev_db').from_database('prod_db')
client.execute(str(stmt))

Statement Classes

class matrixone.clone_builder.CloneStatement[source]

Base class for clone statements.

These produce raw SQL strings via compile() and should be executed as: client.execute(str(stmt))

compile() str[source]
class matrixone.clone_builder.CloneTable(target_table: str | Type)[source]

CREATE TABLE … CLONE statement builder.

__init__(target_table: str | Type)[source]
from_table(source: str | Type, snapshot: str | None = None) CloneTable[source]

Set source table and optional snapshot.

if_not_exists() CloneTable[source]

Add IF NOT EXISTS clause.

to_account(account: str) CloneTable[source]

Set target account for cross-tenant cloning (sys tenant only).

compile() str[source]
class matrixone.clone_builder.CloneDatabase(target_db: str)[source]

CREATE DATABASE … CLONE statement builder.

__init__(target_db: str)[source]
from_database(source: str, snapshot: str | None = None) CloneDatabase[source]

Set source database and optional snapshot.

if_not_exists() CloneDatabase[source]

Add IF NOT EXISTS clause.

to_account(account: str) CloneDatabase[source]

Set target account for cross-tenant cloning (sys tenant only).

compile() str[source]