Migrating system metadata between YCQL Universes can be challenging since system keyspaces, such as system_schema, cannot be transferred using simple INSERT INTO […]
Read MoreExtract YCQL Roles and Grants Into DDL Commands
In the YBA Platform, only user-created YCQL keyspaces can currently be backed up and restored; system keyspaces and tables, including roles and […]
Read MoreBoost Performance by Splitting and Distributing Massive UPDATE Operations
The UPDATE statement modifies the values of specified columns in all rows that meet certain conditions. When no conditions are specified in […]
Read MoreChange the Owner of a View in YSQL
When a CREATE VIEW statement is issued in a session, the view’s ownership is assigned to the current session user. Example: yugabyte=# […]
Read MoreChange the Owner of a Sequence in YSQL
When you issue a CREATE SEQUENCE statement in a session, the current session user becomes the owner of the seqeunce. Example: yugabyte=# […]
Read More