How do I find the owner of a redshift table?

Check the current owner of the table using the below query where table_name is the name of your table and schema_name is the name of the schema in lower case. ALTER TABLE schemaname. tablename OWNER TO new_owner; commit; Verify the change by running the select command again.

Related posts: