Investigate and document data warehouse download records

Description

From: https://sagebionetworks.jira.com/browse/PLFM-5983?focusedCommentId=104912&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-104912.

The data warehouse have two tables, FILE_DOWNLOAD_RECORD and FILE_HANDLE_DOWNLOAD_RECORD. The data that is stored in this two tables is different but lacks documentation. Moreover the data warehouse documentation still refers to deprecated endpoints in the examples.

From the initial findings it seems that the latter table is the new way to analyze downloads and the former could be even removed.

This statement needs to be verified, in particular we need to make sure that the FILE_HANDLE_DOWNLOAD_RECORD is a super set of FILE_DOWNLOAD_RECORD.

Environment

None

Assignee

Marco Marasca

Reporter

Marco Marasca

Labels

None

Validator

Bruce Hoff

Development Area

Synapse Core Infrastructure

Release Version History

None

Priority

Major
Configure