DATADA.AI
Online v0.9.0
data_entities 791 records
Home
model_id color physical_name origin use_type entity_type materialization_type business_domain scd_type file_type dialect dwh_use_type schema_name database_name id name description created_by_id updated_by_id created_at updated_at version deleted x y
a839408e-945c-4e00-8c60-6912191c0ae5 null order_items null UseType.OUTPUT EntityType.VIEW null null null null snowflake null jaffle DBT_TEST 08218a50-ea53-49d7-b3eb-bbc15c833024 order_items 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:39 2026-01-03 15:16:39 2 -260 -126
a839408e-945c-4e00-8c60-6912191c0ae5 null metricflow_time_spine null UseType.OUTPUT EntityType.VIEW null null null null snowflake null jaffle DBT_TEST d7a19ded-d932-41c0-9ad8-d129b6ac1245 metricflow_time_spine 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:39 2026-01-03 15:16:39 2 337 109
a839408e-945c-4e00-8c60-6912191c0ae5 null orders null UseType.OUTPUT EntityType.VIEW null null null null snowflake null jaffle DBT_TEST 25733b02-0b90-44cb-9f09-4c32e3e96461 orders Order overview data mart, offering key details for each order inlcluding if it's a customer's first ... 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:39 2026-01-03 15:16:39 2 -260 -727
a839408e-945c-4e00-8c60-6912191c0ae5 null customers null UseType.OUTPUT EntityType.VIEW null null null null snowflake null jaffle DBT_TEST ce31881f-4e2d-49ac-8df6-4c58d10a3941 customers Customer overview data mart, offering key details for each unique customer. One row per customer. 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:39 2026-01-03 15:16:39 2 84 243
a839408e-945c-4e00-8c60-6912191c0ae5 null products null UseType.OUTPUT EntityType.VIEW null null null null snowflake null jaffle DBT_TEST f5127610-f844-47ad-830c-c7d57846b9f7 products 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:39 2026-01-03 15:16:39 2 -478 -329
a839408e-945c-4e00-8c60-6912191c0ae5 null supplies null UseType.OUTPUT EntityType.VIEW null null null null snowflake null jaffle DBT_TEST a728a5a1-873e-49a8-ae9c-cf352c56cdfb supplies 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:39 2026-01-03 15:16:39 2 277 -246
a839408e-945c-4e00-8c60-6912191c0ae5 null stg_locations null UseType.TRANSFORM EntityType.TABLE MaterializationType.VIEW null null null snowflake null jaffle DBT_TEST 3954e987-8f57-457e-a057-d4ea58242f4d stg_locations List of open locations with basic cleaning and transformation applied, one row per location. 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:39 2026-01-03 15:16:39 2 -182 212
a839408e-945c-4e00-8c60-6912191c0ae5 null stg_order_items null UseType.TRANSFORM EntityType.TABLE MaterializationType.VIEW null null null snowflake null jaffle DBT_TEST c7902b71-d3b0-4722-b542-b109e0c2e5b1 stg_order_items Individual food and drink items that make up our orders, one row per item. 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:39 2026-01-03 15:16:39 2 -545 -45
a839408e-945c-4e00-8c60-6912191c0ae5 null stg_orders null UseType.TRANSFORM EntityType.TABLE MaterializationType.VIEW null null null snowflake null jaffle DBT_TEST 187d6bdc-2248-4610-842b-645ebfb65906 stg_orders Order data with basic cleaning and transformation applied, one row per order. 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:39 2026-01-03 15:16:39 2 88 -627
a839408e-945c-4e00-8c60-6912191c0ae5 null stg_supplies null UseType.TRANSFORM EntityType.TABLE MaterializationType.VIEW null null null snowflake null jaffle DBT_TEST 7781efd9-d4e5-4695-8371-dc2ecbe38232 stg_supplies List of our supply expenses data with basic cleaning and transformation applied. One row per supply ... 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:39 2026-01-03 15:16:39 2 -59 -289
a839408e-945c-4e00-8c60-6912191c0ae5 null stg_customers null UseType.TRANSFORM EntityType.TABLE MaterializationType.VIEW null null null snowflake null jaffle DBT_TEST 81fa2196-4f15-46f7-be15-6ff76f63bfa4 stg_customers Customer data with basic cleaning and transformation applied, one row per customer. 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:39 2026-01-03 15:16:39 2 -190 434
a839408e-945c-4e00-8c60-6912191c0ae5 null stg_products null UseType.TRANSFORM EntityType.TABLE MaterializationType.VIEW null null null snowflake null jaffle DBT_TEST c5b5ad9e-1ccd-4c78-8cf7-bd4a018ba780 stg_products Product (food and drink items that can be ordered) data with basic cleaning and transformation appli... 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:39 2026-01-03 15:16:39 2 19 -42
00000000-demo-enrg-mod1-000000000002 null null null UseType.SOURCE EntityType.TABLE null Grid Operations null null null null null null 00000000-demo-enrg-ent2-000000000006 GridEvent Grid event/outage record 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:39 2 -53 -258
00000000-demo-enrg-mod1-000000000002 null null null UseType.SOURCE EntityType.TABLE null Grid Operations null null null null null null 00000000-demo-enrg-ent2-000000000005 PowerFlow Power flow measurement 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:39 2 273 -152
00000000-demo-enrg-mod1-000000000002 null null null UseType.SOURCE EntityType.TABLE null Grid Operations null null null null null null 00000000-demo-enrg-ent2-000000000004 GridCapacity Grid capacity and constraints 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:39 2 46 136
00000000-demo-enrg-mod1-000000000002 null null null UseType.SOURCE EntityType.TABLE null Grid Operations null null null null null null 00000000-demo-enrg-ent2-000000000003 Substation Electrical substation 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:39 2 -530 -264
00000000-demo-enrg-mod1-000000000002 null null null UseType.SOURCE EntityType.TABLE null Grid Operations null null null null null null 00000000-demo-enrg-ent2-000000000002 TransmissionLine Power transmission line 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:39 2 -245 -35
00000000-demo-enrg-mod1-000000000002 null null null UseType.SOURCE EntityType.TABLE null Grid Operations null null null null null null 00000000-demo-enrg-ent2-000000000001 GridNode Grid connection point/node 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:39 2 -311 -444
00000000-demo-enrg-mod1-000000000004 null null null UseType.SOURCE EntityType.TABLE null Energy Storage null null null null null null 00000000-demo-enrg-ent4-000000000006 StorageOptimization Storage optimization and dispatch schedule 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 -203 117
00000000-demo-enrg-mod1-000000000004 null null null UseType.SOURCE EntityType.TABLE null Energy Storage null null null null null null 00000000-demo-enrg-ent4-000000000005 StorageState Real-time storage state measurements 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 176 -283
00000000-demo-enrg-mod1-000000000004 null null null UseType.SOURCE EntityType.TABLE null Energy Storage null null null null null null 00000000-demo-enrg-ent4-000000000004 ChargeDischarge Charge and discharge cycle records 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 -118 -203
00000000-demo-enrg-mod1-000000000004 null null null UseType.SOURCE EntityType.TABLE null Energy Storage null null null null null null 00000000-demo-enrg-ent4-000000000003 StorageTechnology Storage technology type (battery chemistry, pumped hydro, etc.) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 -433 -75
00000000-demo-enrg-mod1-000000000004 null null null UseType.SOURCE EntityType.TABLE null Energy Storage null null null null null null 00000000-demo-enrg-ent4-000000000002 StorageUnit Individual storage unit/battery module 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 110 -51
00000000-demo-enrg-mod1-000000000004 null null null UseType.SOURCE EntityType.TABLE null Energy Storage null null null null null null 00000000-demo-enrg-ent4-000000000001 StorageFacility Energy storage facility 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 -339 -510
00000000-demo-enrg-mod1-000000000001 null null null UseType.SOURCE EntityType.TABLE null Energy Production null null null null null null 00000000-demo-enrg-ent1-000000000006 WeatherData Weather data for production forecasting 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 -424 -46
00000000-demo-enrg-mod1-000000000001 null null null UseType.SOURCE EntityType.TABLE null Energy Production null null null null null null 00000000-demo-enrg-ent1-000000000005 ProductionActual Actual energy production measurement 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 -147 -207
00000000-demo-enrg-mod1-000000000001 null null null UseType.SOURCE EntityType.TABLE null Energy Production null null null null null null 00000000-demo-enrg-ent1-000000000004 ProductionForecast Energy production forecast 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 -106 149
00000000-demo-enrg-mod1-000000000001 null null null UseType.SOURCE EntityType.TABLE null Energy Production null null null null null null 00000000-demo-enrg-ent1-000000000003 EnergySource Energy source type (solar, wind, hydro, etc.) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 -475 -384
00000000-demo-enrg-mod1-000000000001 null null null UseType.SOURCE EntityType.TABLE null Energy Production null null null null null null 00000000-demo-enrg-ent1-000000000002 GenerationUnit Individual generation unit/turbine 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 172 -188
00000000-demo-enrg-mod1-000000000001 null null null UseType.SOURCE EntityType.TABLE null Energy Production null null null null null null 00000000-demo-enrg-ent1-000000000001 PowerPlant Power generation facility 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 95 -558
00000000-demo-enrg-mod2-000000000001 null fact_emissions null UseType.SOURCE EntityType.TABLE null DWH - Facts null null null null null null 00000000-demo-enrg-phys-000000000006 fact_emissions Emissions fact table - grain: one row per facility per time interval 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 -709 232
00000000-demo-enrg-mod2-000000000001 null fact_consumption null UseType.SOURCE EntityType.TABLE null DWH - Facts null null null null null null 00000000-demo-enrg-phys-000000000005 fact_consumption Energy consumption fact table - grain: one row per consumer per time interval 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 -452 779
00000000-demo-enrg-mod2-000000000001 null fact_production null UseType.SOURCE EntityType.TABLE null DWH - Facts null null null null null null 00000000-demo-enrg-phys-000000000004 fact_production Energy production fact table - grain: one row per facility per time interval 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 -418 426
00000000-demo-enrg-mod2-000000000001 null dim_time null UseType.SOURCE EntityType.TABLE null DWH - Dimensions null null null null null null 00000000-demo-enrg-phys-000000000003 dim_time Time dimension with 15-minute interval granularity 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 292 -1056
00000000-demo-enrg-mod2-000000000001 null dim_energy_source null UseType.SOURCE EntityType.TABLE null DWH - Dimensions null null null null null null 00000000-demo-enrg-phys-000000000002 dim_energy_source Energy source dimension with characteristics and emissions data 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 -126 -518
00000000-demo-enrg-mod2-000000000001 null dim_facility null UseType.SOURCE EntityType.TABLE null DWH - Dimensions null null null null null null 00000000-demo-enrg-phys-000000000001 dim_facility Facility dimension (plants, storage, substations) with SCD Type 2 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 550 -955
00000000-demo-enrg-mod1-000000000005 null null null UseType.SOURCE EntityType.TABLE null Emissions & Sustainability null null null null null null 00000000-demo-enrg-ent5-000000000006 SustainabilityReport Sustainability and ESG reporting metrics 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 242 -393
00000000-demo-enrg-mod1-000000000005 null null null UseType.SOURCE EntityType.TABLE null Emissions & Sustainability null null null null null null 00000000-demo-enrg-ent5-000000000005 RegulatoryCompliance Emissions regulatory compliance tracking 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 -11 -81
00000000-demo-enrg-mod1-000000000005 null null null UseType.SOURCE EntityType.TABLE null Emissions & Sustainability null null null null null null 00000000-demo-enrg-ent5-000000000004 CarbonCredit Carbon credits and offsets inventory 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 -291 -182
00000000-demo-enrg-mod1-000000000005 null null null UseType.SOURCE EntityType.TABLE null Emissions & Sustainability null null null null null null 00000000-demo-enrg-ent5-000000000003 EmissionRecord Recorded emissions from power generation facilities 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 -89 -413
00000000-demo-enrg-mod1-000000000005 null null null UseType.SOURCE EntityType.TABLE null Emissions & Sustainability null null null null null null 00000000-demo-enrg-ent5-000000000002 CarbonIntensity Grid carbon intensity measurements and forecasts 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 -302 209
00000000-demo-enrg-mod1-000000000005 null null null UseType.SOURCE EntityType.TABLE null Emissions & Sustainability null null null null null null 00000000-demo-enrg-ent5-000000000001 EmissionFactor Emission factors for different energy sources and pollutants 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 -393 -422
00000000-demo-enrg-mod1-000000000003 null null null UseType.SOURCE EntityType.TABLE null Energy Consumption null null null null null null 00000000-demo-enrg-ent3-000000000006 Tariff Energy tariff/pricing 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 83 49
00000000-demo-enrg-mod1-000000000003 null null null UseType.SOURCE EntityType.TABLE null Energy Consumption null null null null null null 00000000-demo-enrg-ent3-000000000005 DemandForecast Energy demand forecast 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 -192 -531
00000000-demo-enrg-mod1-000000000003 null null null UseType.SOURCE EntityType.TABLE null Energy Consumption null null null null null null 00000000-demo-enrg-ent3-000000000004 ConsumptionReading Energy consumption reading 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 -236 132
00000000-demo-enrg-mod1-000000000003 null null null UseType.SOURCE EntityType.TABLE null Energy Consumption null null null null null null 00000000-demo-enrg-ent3-000000000003 MeterPoint Metering point/smart meter 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 -168 -207
00000000-demo-enrg-mod1-000000000003 null null null UseType.SOURCE EntityType.TABLE null Energy Consumption null null null null null null 00000000-demo-enrg-ent3-000000000002 ConsumerCategory Consumer category (residential, commercial, industrial) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 156 -246
00000000-demo-enrg-mod1-000000000003 null null null UseType.SOURCE EntityType.TABLE null Energy Consumption null null null null null null 00000000-demo-enrg-ent3-000000000001 Consumer Energy consumer/customer 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 -493 -167
00000000-demo-ecom-mod1-000000000001 null null null UseType.SOURCE EntityType.TABLE null Product Catalog null null null null null null 00000000-demo-ecom-ent1-000000000008 ProductImage Product images gallery 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 -182 100
00000000-demo-ecom-mod1-000000000001 null null null UseType.SOURCE EntityType.TABLE null Product Catalog null null null null null null 00000000-demo-ecom-ent1-000000000007 Warehouse Warehouse/fulfillment center 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 2 -218 -479