Releases · Sage-Bionetworks/snowflake

What's Changed

[SNOW-19] Create certified quiz snapshot tables by @thomasyu888 in #7
[SNOW-31] update certified quiz latest tables by @thomasyu888 in #8
[SNOW-31] update certified quiz tasks by @thomasyu888 in #9
[SNOW-20] Add created_on to user profile by @thomasyu888 in #10
[SNOW-32] Fix certified quiz question tasks by @thomasyu888 in #11
Update code that pushes portal tables by @thomasyu888 in #12
[SNOW-34] Add in file inventory data by @thomasyu888 in #14
[SNOW-42] Append to file inventory task by @thomasyu888 in #15
[SNOW-43] Fix permissions for data engineer role by @thomasyu888 in #16
[SNOW-52] re-ingest userprofile tables by @thomasyu888 in #17
[SNOW-53, SNOW-37] reprocess nodeshapshot and update nodesnapshot task by @thomasyu888 in #18
[SNOW-55] Add effective AR by @thomasyu888 in #20
[SNOW-38] Add session id for file download records by @thomasyu888 in #19
Update permissions for data engineer role by @thomasyu888 in #21
[SNOW-54] Re-process filesnapshot tables by @thomasyu888 in #22
Alter filesnapshot task and fix filedownload task by @thomasyu888 in #24
[SNOW-56] Add and remove users by @thomasyu888 in #23
[SNOW-57] re-process fileinventory tables by @thomasyu888 in #25
[SNOW-57] Add snapshot date by @thomasyu888 in #26
Add in cnb users by @thomasyu888 in #28
[SNOW-59] Add annotations by @thomasyu888 in #29
[SNOW-61] Escape new line for annotations by @thomasyu888 in #30
[IBCDPE-832] Add script to get data size for Synapse entity by @danlu1 in #32
Create GENIE tables by @thomasyu888 in #13
Unify tasks by @thomasyu888 in #35
[SNOW-72, SNOW-67] add revoke fields to certification quiz snapshot / latest by @thomasyu888 in #36
[SNOW-68] Add stack env variable and fileassociation tables by @thomasyu888 in #37
[SNOW-30] Create team and filehandle association latest tables by @thomasyu888 in #39
[SYNSD-893] Add query for disjointed name by @BryanFauble in #31
[SNOW-28] Add in ACL latest table by @thomasyu888 in #40
[SNOW-74] Add extra node columns by @thomasyu888 in #38
Create governance role by @thomasyu888 in #41
Extract ip addresses by @thomasyu888 in #34
[SNOW-79] Add comments to the columns of the file_latest table by @BryanFauble in #43
Revert "[SNOW-79] Add comments to the columns of the file_latest table" by @thomasyu888 in #45
[SNOW-79] Create V2.19.0__add_table_file_latest_comments.sql by @BryanFauble in #46
[SNOW-80] Adds table and column comments for TEAMMEMBER_LATEST table by @BWMac in #44
[SNOW-77] Add comments to certifiedquizquestion_latest table by @danlu1 in #47
Add permission to execute procedure to GOVERNANCE by @xschildw in #49
[SNOW-81] Add comments to certifiedquiz_latest table and columns by @philerooski in #48
[SNOW-78] Add comments to userprofile_latest synapse table by @rxu17 in #50
[SNOW-71] Updating FILEUPLOAD table in synapse_raw schema by @jaymedina in #52
[SNOW-71] hotfix: Update schema change history to 2.19.5 by @jaymedina in #53
[SNOW-78] Add evolve schema permission for tables by @thomasyu888 in #51
Update FILEUPLOAD table in synapse_raw by @jaymedina in #55
Update syntax V2.19.5__add_file_upload_comments.sql by @jaymedina in #56
[SNOW-21] Adds accessrequirementsnapshots Table by @BWMac in #54
Removes accessrequirementssnapshot ingestion by @BWMac in #57
[Issue-59] Correct description of userprofile latest by @BryanFauble in #60
[SNOW-33] Introduce repeatable scripts for projectsettingsnapshots table by @jaymedina in #61
Remove LOCATIONS column from projectsnapshots by @jaymedina in #63
Delete projectsettingsnapshots_append_task.sql by @jaymedina in #64
[SNOW-92] Lock numpy and pandas vers in ci.yaml by @jaymedina in #65
[SNOW-33] reintroduce projectsettingsnapshots task by @jaymedina in #66
[SNOW-33] New ingest to projectsettingsnapshots table by @jaymedina in #62
Add policies to resolve trust center scans by @thomasyu888 in #67
[SNOW-103] Create a streamlit app template by @jaymedina in #68
[SNOW-103] Streamlit App Validation Feedback by @jaymedina in #70
Revert streamlit changes by @jaymedina in #71
[SNOW-116] Migrate out streamlit_template/ by @jaymedina in #72
[SNOW-86] Fix deduplication logic for acl_latest by @jaymedina in #74
[SNOW-107] Add deduplication logic for filehandleassociation_latest by @jaymedina in #73
(WIP) Add GX data validation for synapse data warehouse by @thomasyu888 in #42
Structure users by team and remove some users by @thomasyu888 in #75
[SNOW-132] add more users by @thomasyu888 in #76
Create authentication policies by @thomasyu888 in #77
[SNOW-135] Add query to extract unique downloads per email domain by @danlu1 in #79
Remove sage.portal_raw grants, and add users to GENIE_ADMIN by @thomasyu888 in #80
[SNOW-29] Initialize dynamic table: verificationsubmission_latest by @jaymedina in #83
[SNOW-27] add version script to populate usergroup_latest table by @danlu1 in #82
[SNOW-151] Initialize dynamic table: accessrequirement_latest by @jaymedina in #84
[SNOW-82] Initialize dynamic table: projectsetting_latest by @jaymedina in #87