Migrating system metadata between YCQL Universes can be challenging since system keyspaces, such as system_schema, cannot be transferred using simple INSERT INTO […]
Read More
Extract 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 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 MoreErase Statistics
The ANALYZE command collects statistics about the contents of tables in the database, and stores the results in the pg_statistic system catalog. These […]
Read More