While trying to change ownership of a couple tables or hypertables, it is important to note that ALTER TABLE is blocked due to super use credentials on Timescale Cloud.
You will see the following:
ERROR: permission denied for schema _timescaledb_internal
Instead, we recommend using the REASSIGN command:
REASSIGN OWNED BY current_role TO desired_role