States Data from state files - POSOCO/wrldc_warehouse_data_migration_python GitHub Wiki

All the states names and their IDS are present in REPORTING_UAT.DIM_SRLDC_STATE table

SELECT x.* FROM REPORTING_UAT.DIM_SRLDC_STATE x
WHERE x.REGION_ID IN (4)

state file hourly data is present in REPORTING_UAT.STG_STATE_DATA_HOURLY table

SELECT x.* FROM REPORTING_UAT.STG_STATE_DATA_HOURLY x

state file daily generation MU data is present in REPORTING_UAT.STATE_ENTITIES_GENERATION table

SELECT x.* FROM REPORTING_UAT.STATE_ENTITIES_GENERATION x
ORDER BY x.DATE_KEY DESC

all the generating stations used in reporting software are stored in REPORTING_UAT.DIM_GENERATING_STATION master table

SELECT x.*,x.ROWID FROM REPORTING_UAT.DIM_GENERATING_STATION x
⚠️ **GitHub.com Fallback** ⚠️