v0.5.0

Highlights

• Introduced a new proxy admin role to centralize ownership and management of dynamic tables and tasks
• Improved access control and authentication policies for service accounts and users
• Converted the teammember_latest table to a dynamic table for simplified data management
• Enhanced data quality by filtering out deleted ACLs from the ACL_LATEST table

Features

• [SNOW-218] Created a proxy admin role and granted necessary privileges for task execution and dynamic table management (#131, #151)
• [SNOW-89] Created admin and developer service users with appropriate roles and authentication policies (#143, #144, #146, #148)
• [SNOW-177] Converted the teammember_latest table to a dynamic table (#149)

Bug Fixes

• [SNOW-147] Filtered out deleted ACLs from the ACL_LATEST table (#140)
• [SNOW-204] Granted DATA_ENGINEER role read-only privileges on dynamic tables (#155)

Tech Debt

• [SNOW-239] Converted the admin/policies.sql script to a versioned script (#148)
• [SNOW-224] Resolved a CI race condition by enforcing the order of script execution (#156)
• Removed unused roles, tables, and grants (#133, #134)

Other

• [SNOW-253] Updated table comments for userprofile_latest, file_latest, and teammember_latest dynamic tables (#158)
• Created a SECURITY.md file (#145)
• Bumped version of previous PR's files (#147)
• [SNOW-246] Renamed the proxy admin role (#152)

Full Changelog: 0.4.0...0.5.0