Online
v0.9.0
Tables
data_attributes 9849 records
| entity_id | physical_name | origin | data_type | dialect_type | dialect | business_type | business_type_params | data_type_info | order | scale | is_primary_key | is_foreign_key | is_unique | is_nullable | is_autoincrement | is_surrogate_key | is_business_key | is_audit_column | is_scd_column | audit_role | scd_role | pii_level | pcidss_attribute | hipaa_identifier | id | name | description | created_by_id | updated_by_id | created_at | updated_at | version | deleted |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 00000000-demo-enrg-phys-000000000003 | null | null | INTEGER | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-enrg-p003-000000000007 | DAY_OF_WEEK | Day of week (1-7) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000003 | null | null | INTEGER | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-enrg-p003-000000000006 | INTERVAL_15MIN | 15-minute interval of day (1-96) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000003 | null | null | INTEGER | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-enrg-p003-000000000005 | MINUTE | Minute (0, 15, 30, 45) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000003 | null | null | INTEGER | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-enrg-p003-000000000004 | HOUR | Hour (0-23) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000003 | null | null | DATE | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-enrg-p003-000000000003 | DATE_VALUE | Date value | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000003 | null | null | STRING | TIMESTAMP_NTZ | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-enrg-p003-000000000002 | DATETIME_VALUE | Datetime value | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000003 | null | null | STRING | BIGINT | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-enrg-p003-000000000001 | TIME_SK | Surrogate key (YYYYMMDDHHmm) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000002 | null | null | CHAR | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-enrg-p002-000000000011 | COLOR_CODE | Color code for visualization | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000002 | null | null | DECIMAL | null | null | null | null | null | 9 | 2 | null | null | null | null | null | 00000000-demo-enrg-p002-000000000010 | LEVELIZED_COST_USD_MWH | Levelized cost of energy (USD/MWh) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000002 | null | null | DECIMAL | null | null | null | null | null | 8 | 2 | null | null | null | null | null | 00000000-demo-enrg-p002-000000000009 | EMISSION_FACTOR_KG_CO2_MWH | CO2 emission factor per MWh | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000002 | null | null | DECIMAL | null | null | null | null | null | 7 | 4 | null | null | null | null | null | 00000000-demo-enrg-p002-000000000008 | TYPICAL_CAPACITY_FACTOR | Typical capacity factor (0-1) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000002 | null | null | BOOLEAN | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-enrg-p002-000000000007 | IS_DISPATCHABLE | Dispatchable flag | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000002 | null | null | BOOLEAN | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-enrg-p002-000000000006 | IS_RENEWABLE | Renewable flag | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-enrg-p002-000000000005 | CATEGORY | Category (Renewable, Fossil, Nuclear, Storage) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-enrg-p002-000000000004 | SOURCE_NAME | Source name | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-enrg-p002-000000000003 | SOURCE_CODE | Source code (SOLAR, WIND, COAL, etc.) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-enrg-p002-000000000002 | ENERGY_SOURCE_BK | Business key (energy_source_id) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000002 | null | null | INTEGER | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-enrg-p002-000000000001 | ENERGY_SOURCE_SK | Surrogate key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000001 | null | null | BOOLEAN | null | null | null | null | null | 21 | null | null | null | null | null | null | 00000000-demo-enrg-p001-000000000022 | IS_CURRENT | Current record flag | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000001 | null | null | STRING | TIMESTAMP_NTZ | null | null | null | null | 20 | null | null | null | null | null | null | 00000000-demo-enrg-p001-000000000021 | EFFECTIVE_TO | SCD2 effective to | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000001 | null | null | STRING | TIMESTAMP_NTZ | null | null | null | null | 19 | null | null | null | null | null | null | 00000000-demo-enrg-p001-000000000020 | EFFECTIVE_FROM | SCD2 effective from | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 18 | null | null | null | null | null | null | 00000000-demo-enrg-p001-000000000019 | STATUS | Facility status (Active, Inactive, Maintenance) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000001 | null | null | DATE | null | null | null | null | null | 17 | null | null | null | null | null | null | 00000000-demo-enrg-p001-000000000018 | COMMISSIONING_DATE | Commissioning date | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 16 | null | null | null | null | null | null | 00000000-demo-enrg-p001-000000000017 | OPERATOR_COMPANY | Operator company name | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 15 | null | null | null | null | null | null | 00000000-demo-enrg-p001-000000000016 | OWNER_COMPANY | Owner company name | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000001 | null | null | DECIMAL | null | null | null | null | null | 14 | 7 | null | null | null | null | null | 00000000-demo-enrg-p001-000000000015 | LONGITUDE | Longitude coordinate | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000001 | null | null | DECIMAL | null | null | null | null | null | 13 | 7 | null | null | null | null | null | 00000000-demo-enrg-p001-000000000014 | LATITUDE | Latitude coordinate | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-enrg-p001-000000000013 | COUNTRY_NAME | Country name | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000001 | null | null | CHAR | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-enrg-p001-000000000012 | COUNTRY_CODE | Country code | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-enrg-p001-000000000011 | STATE | State or province | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-enrg-p001-000000000010 | CITY | City | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-enrg-p001-000000000009 | GRID_ZONE | Grid zone identifier | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000001 | null | null | DECIMAL | null | null | null | null | null | 7 | 2 | null | null | null | null | null | 00000000-demo-enrg-p001-000000000008 | INSTALLED_CAPACITY_MW | Installed capacity in megawatts | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000001 | null | null | BOOLEAN | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-enrg-p001-000000000007 | IS_RENEWABLE | Renewable energy flag | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-enrg-p001-000000000006 | ENERGY_SOURCE | Primary energy source | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-enrg-p001-000000000005 | FACILITY_TYPE | Facility type (Plant, Storage, Substation) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-enrg-p001-000000000004 | FACILITY_NAME | Facility name | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-enrg-p001-000000000003 | FACILITY_CODE | Facility code | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-enrg-p001-000000000002 | FACILITY_BK | Business key (facility_id) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-phys-000000000001 | null | null | INTEGER | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-enrg-p001-000000000001 | FACILITY_SK | Surrogate key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent5-000000000006 | null | null | DATETIME | null | null | null | null | null | 21 | null | null | null | null | null | null | 00000000-demo-enrg-a506-000000000022 | updated_at | Record last update timestamp | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent5-000000000006 | null | null | DATETIME | null | null | null | null | null | 20 | null | null | null | null | null | null | 00000000-demo-enrg-a506-000000000021 | created_at | Record creation timestamp | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent5-000000000006 | null | null | STRING | null | null | null | null | null | 19 | null | null | null | null | null | null | 00000000-demo-enrg-a506-000000000020 | framework | Reporting framework (GRI, CDP, TCFD, SASB) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent5-000000000006 | null | null | STRING | null | null | null | null | null | 18 | null | null | null | null | null | null | 00000000-demo-enrg-a506-000000000019 | verifier_name | Third-party verifier name | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent5-000000000006 | null | null | STRING | null | null | null | null | null | 17 | null | null | null | null | null | null | 00000000-demo-enrg-a506-000000000018 | verification_status | Verification status (verified, unverified, pending) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent5-000000000006 | null | null | DATE | null | null | null | null | null | 16 | null | null | null | null | null | null | 00000000-demo-enrg-a506-000000000017 | report_date | Report publication date | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent5-000000000006 | null | null | DECIMAL | null | null | null | null | null | 15 | 3 | null | null | null | null | null | 00000000-demo-enrg-a506-000000000016 | emission_intensity_kg_mwh | Emission intensity (kg CO2/MWh) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent5-000000000006 | null | null | DECIMAL | null | null | null | null | null | 14 | 3 | null | null | null | null | null | 00000000-demo-enrg-a506-000000000015 | net_emissions_tonnes | Net emissions after offsets (tonnes) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent5-000000000006 | null | null | DECIMAL | null | null | null | null | null | 13 | 3 | null | null | null | null | null | 00000000-demo-enrg-a506-000000000014 | carbon_offset_tonnes | Carbon offsets purchased/retired (tonnes) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent5-000000000006 | null | null | DECIMAL | null | null | null | null | null | 12 | 2 | null | null | null | null | null | 00000000-demo-enrg-a506-000000000013 | renewable_percentage | Renewable energy percentage | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 |