HN Explorer

Two new Amazon Redshift versions out (system table diffs)

3 points by Max-Ganz-II ↗ HN
Two new RS versions out - 1.0.49676, which is now in two regions only, and 1.0.49780, which is in all the other regions.

Quite a lot of change (new function user_is_member_of_role() in 49676 looks particularly interesting), but also 49676 has introduced quite a bit of new stuff which 49780 has removed (including that new function).

https://www.redshiftresearchproject.org/system_table_tracker/1.0.49087_to_1.0.49676/index.html

https://www.redshiftresearchproject.org/system_table_tracker/1.0.49676_to_1.0.49780/index.html

3 comments

[ 2.2 ms ] story [ 18.6 ms ] thread
scrum-treats
Some new functions aren't loading (e.g., user_is_member_of_role, txid_status, last_user_query_id).

They do load here (https://www.redshiftresearchproject.org/system_table_tracker...).

Max-Ganz-II
Yes. The function links do not yet work. I improve the diffs every now and then - I added the list of function diffs a month or so ago, but getting the links to work is a second round of work, because right now functions are linked to in the URL by their OID, but the OID varies between Redshift version, so I need to link via their name and arguments.

The dense paragraph of explanation at the of the the page, at its very end, says the function links are not yet working. I was thinking to convert the list to a few bullet points, to improve clarity.

What I will probably add next though is permissions - who has access to the object (view, table, function). Mainly they're rdsdb only, but actually knowing is useful (and it lets you spot any slip ups).

Max-Ganz-II
Funny though the function is "member_of_role". You're supposed to be granting roles :-) but in RS roles are not really roles, as they are in Postgres, you still have normal groups and normal users, as they were before. Roles in RS are really enhanced groups.