DegreeWorks Bronze Lakehouse Access Request
How to get access?
To access DegreeWorks Bronze Lakehouse, please submit a ticket to it-analytics@usf.edu with the following information
Tables:
Reason for Access:
How to access DegreeWorks Lakehouse in Bronze layer?
Enter the Server and Database details in the SQL Server Management Studio as below:
Prod Server : 333rw5hf4lpundlhqjqh36o6vi-pffe3s34ldtetjhyxxptkh4ezq.datawarehouse.fabric.microsoft.com
UAT Server : 333rw5hf4lpundlhqjqh36o6vi-qv43gvttthjefisuurplmaif3i.datawarehouse.fabric.microsoft.com
Database: DegreeWorksBronze (Please type in the database name and do not use the dropdown)
Authentication Type: Microsoft Entra MFA.
Once Connected, you will be able to see all the tables you have access to
Tables
TableName |
DAP_APPLICNT_MST |
DAP_AUDIT_DTL |
DAP_EXCEPT_DTL |
DAP_GPA_HISTORY |
DAP_NEXT_ID_MST |
DAP_NOTE_DTL |
DAP_NOTE_TXT_DTL |
DAP_REQ_BLOCK |
DAP_REQ_CRS_DTL |
DAP_REQ_LINK_DTL |
DAP_REQ_TREE |
DAP_RESCLASS_DTL |
DAP_RESNONCR_DTL |
DAP_RESULT_DTL |
DAP_STUDENT_MST |
DATA_BASES |
RAD_AID_DTL |
RAD_AID_HSH |
RAD_APPLICNT_HSH |
RAD_ATTR_DTL |
RAD_ATTR_HSH |
RAD_CLASS_DTL |
RAD_CLASS_HSH |
RAD_COURSE_MST |
RAD_CRS_ATTR_DTL |
RAD_CURRRULE_DTL |
RAD_CUSTOM_DTL |
RAD_CUSTOM_HSH |
RAD_ETS_MST |
RAD_GOALDATA_DTL |
RAD_GOALDATA_HSH |
RAD_GOAL_DTL |
RAD_GOAL_HSH |
RAD_HASH_MST |
RAD_LOG_DTL |
RAD_NEXT_ID_MST |
RAD_NONCRSE_DTL |
RAD_NONCRSE_HSH |
RAD_PREVINST_DTL |
RAD_PREVINST_HSH |
RAD_PRIMARY_MST |
RAD_REPORT_DTL |
RAD_REPORT_HSH |
RAD_STUDENT_HSH |
RAD_STUDENT_MST |
RAD_TERM_DTL |
RAD_TERM_HSH |
RAD_TEST_DTL |
RAD_TEST_HSH |
RAD_TRANSFER_DTL |
RAD_TRANSFER_HSH |
SEP_PLAN |
SEP_PLAN_CLASS |
SEP_PLAN_CLASS_NOTE |
SEP_PLAN_GPA |
SEP_PLAN_GPA_NOTE |
SEP_PLAN_GROUP |
SEP_PLAN_GROUP_NOTE |
SEP_PLAN_NONCOURSE |
SEP_PLAN_NONCOURSE_NOTE |
SEP_PLAN_NOTE |
SEP_PLAN_PLACEHOLDER |
SEP_PLAN_PLACEHOLDER_NOTE |
SEP_PLAN_TERM |
SEP_PLAN_TERM_NOTE |
SEP_TMPL_CLASS |
SEP_TMPL_CLASS_NOTE |
SEP_TMPL_GPA |
SEP_TMPL_GPA_NOTE |
SEP_TMPL_GROUP |
SEP_TMPL_GROUP_NOTE |
SEP_TMPL_MST |
SEP_TMPL_PLACEHOLDER |
SEP_TMPL_PLACEHOLDER_NOTE |
SEP_TMPL_TAG |
SEP_TMPL_TERM |
SHP_ATTRIB_HSH |
SHP_COMPOSER_MST |
SHP_GROUP_MST |
SHP_LOG_DTL |
SHP_RESOURCE_MST |
SHP_SESSION |
SHP_SETTINGS_MST |
SHP_USER_MST |
TOKEN_REVOCATION_MST |
UCX_AUD012 |
UCX_AUD013 |
UCX_AUD014 |
UCX_AUD015 |
UCX_AUD027 |
UCX_AUD029 |
UCX_AUD031 |
UCX_AUD032 |
UCX_AUD034 |
UCX_AUD047 |
UCX_BAN080 |
UCX_CFG020 |
UCX_CFG071 |
UCX_CST001 |
UCX_CST002 |
UCX_CST003 |
UCX_CST004 |
UCX_RPT036 |
UCX_RPT050 |
UCX_RPT052 |
UCX_RPT054 |
UCX_RPT056 |
UCX_SCR001 |
UCX_SCR002 |
UCX_SCR003 |
UCX_SCR004 |
UCX_SCR007 |
UCX_SCR008 |
UCX_SCR044 |
UCX_SCR045 |
UCX_SEP001 |
UCX_SEP002 |
UCX_SEP003 |
UCX_SEP004 |
UCX_SEP005 |
UCX_SEP006 |
UCX_SEP007 |
UCX_SEP008 |
UCX_SEP009 |
UCX_SEP011 |
UCX_SHP078 |
UCX_SHP080 |
UCX_STU016 |
UCX_STU023 |
UCX_STU024 |
UCX_STU035 |
UCX_STU050 |
UCX_STU305 |
UCX_STU306 |
UCX_STU307 |
UCX_STU316 |
UCX_STU350 |
UCX_STU352 |
UCX_STU355 |
UCX_STU356 |
UCX_STU385 |
UCX_STU560 |
UCX_STU563 |
UCX_STU576 |
UCX_SYS001 |
UCX_SYS098 |
UCX_SYS100 |
UCX_SYS933 |
UCX_SYS935 |
UCX_SYS998 |
UCX_SYS999 |
UCX_TRQ060 |
UCX_TRQ061 |
UCX_TRQ062 |
UCX_TRQ063 |
UCX_TRQ065 |