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
66ef7483-9bb0-42aa-87d7-ba64d9f6e612 null order_items null UseType.OUTPUT EntityType.VIEW null null null null snowflake null jaffle DBT_TEST e9128518-a7e8-4afe-98a8-02b300f1a353 order_items 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:31 2026-01-03 15:41:31 2 -247 -266
66ef7483-9bb0-42aa-87d7-ba64d9f6e612 null metricflow_time_spine null UseType.OUTPUT EntityType.VIEW null null null null snowflake null jaffle DBT_TEST 64855201-49f3-440b-b9d6-80251bab5723 metricflow_time_spine 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:31 2026-01-03 15:41:31 2 157 392
66ef7483-9bb0-42aa-87d7-ba64d9f6e612 null orders null UseType.OUTPUT EntityType.VIEW null null null null snowflake null jaffle DBT_TEST 6523419b-95a5-4e7a-9239-befd26484e1e 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:41:31 2026-01-03 15:41:31 2 357 -254
66ef7483-9bb0-42aa-87d7-ba64d9f6e612 null customers null UseType.OUTPUT EntityType.VIEW null null null null snowflake null jaffle DBT_TEST 120058b7-8a53-4a13-80c6-b8e8ef0e8d52 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:41:31 2026-01-03 15:41:31 2 -190 270
66ef7483-9bb0-42aa-87d7-ba64d9f6e612 null products null UseType.OUTPUT EntityType.VIEW null null null null snowflake null jaffle DBT_TEST e6410e0a-6ec8-498b-98bf-09f9cfbcab45 products 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:31 2026-01-03 15:41:31 2 29 -164
66ef7483-9bb0-42aa-87d7-ba64d9f6e612 null supplies null UseType.OUTPUT EntityType.VIEW null null null null snowflake null jaffle DBT_TEST c1fab5e3-b586-41e4-848e-80885d8bcac2 supplies 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:31 2026-01-03 15:41:31 2 244 -422
66ef7483-9bb0-42aa-87d7-ba64d9f6e612 null stg_locations null UseType.TRANSFORM EntityType.TABLE MaterializationType.VIEW null null null snowflake null jaffle DBT_TEST ce2f6e89-a44c-4aa1-911a-fe3769f68718 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:41:31 2026-01-03 15:41:31 2 -197 66
66ef7483-9bb0-42aa-87d7-ba64d9f6e612 null stg_order_items null UseType.TRANSFORM EntityType.TABLE MaterializationType.VIEW null null null snowflake null jaffle DBT_TEST a0581284-1ecf-4fad-9c72-98a8eeb43fdf 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:41:31 2026-01-03 15:41:31 2 -39 -377
66ef7483-9bb0-42aa-87d7-ba64d9f6e612 null stg_orders null UseType.TRANSFORM EntityType.TABLE MaterializationType.VIEW null null null snowflake null jaffle DBT_TEST 01f056e2-6947-4d84-b0a1-700d57a9d0ca 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:41:31 2026-01-03 15:41:31 2 -337 -561
66ef7483-9bb0-42aa-87d7-ba64d9f6e612 null stg_supplies null UseType.TRANSFORM EntityType.TABLE MaterializationType.VIEW null null null snowflake null jaffle DBT_TEST a57f57ff-d4ea-4bd8-881f-bf0b925ec05c 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:41:31 2026-01-03 15:41:31 2 80 101
66ef7483-9bb0-42aa-87d7-ba64d9f6e612 null stg_customers null UseType.TRANSFORM EntityType.TABLE MaterializationType.VIEW null null null snowflake null jaffle DBT_TEST 89c76e55-9458-4d02-b5ae-938cebe7d40f 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:41:31 2026-01-03 15:41:31 2 -447 237
66ef7483-9bb0-42aa-87d7-ba64d9f6e612 null stg_products null UseType.TRANSFORM EntityType.TABLE MaterializationType.VIEW null null null snowflake null jaffle DBT_TEST f15a7625-5605-4e7a-b869-68c0e6b71064 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:41:31 2026-01-03 15:41:31 2 -520 -44
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:41:30 2026-01-03 15:41:31 2 -149 -85
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:41:30 2026-01-03 15:41:31 2 158 -259
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:41:30 2026-01-03 15:41:31 2 -471 58
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:41:30 2026-01-03 15:41:31 2 146 13
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:41:30 2026-01-03 15:41:31 2 -397 -321
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:41:30 2026-01-03 15:41:31 2 -106 -424
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:41:30 2026-01-03 15:41:31 2 -422 -61
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:41:30 2026-01-03 15:41:31 2 -222 223
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:41:30 2026-01-03 15:41:31 2 220 -147
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:41:30 2026-01-03 15:41:31 2 -101 -72
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:41:30 2026-01-03 15:41:31 2 -315 -461
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:41:30 2026-01-03 15:41:31 2 34 -488
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:41:30 2026-01-03 15:41:30 2 -157 -368
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:41:30 2026-01-03 15:41:30 2 -393 210
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:41:30 2026-01-03 15:41:30 2 157 -191
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:41:30 2026-01-03 15:41:30 2 87 -553
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:41:30 2026-01-03 15:41:30 2 -119 -87
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:41:30 2026-01-03 15:41:30 2 -462 -245
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:41:30 2026-01-03 15:41:30 2 -797 -581
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:41:30 2026-01-03 15:41:30 2 -172 -528
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:41:30 2026-01-03 15:41:30 2 -663 -941
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:41:30 2026-01-03 15:41:30 2 240 307
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:41:30 2026-01-03 15:41:30 2 375 85
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:41:30 2026-01-03 15:41:30 2 153 565
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:41:30 2026-01-03 15:41:30 2 247 -373
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:41:30 2026-01-03 15:41:30 2 -19 -74
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:41:30 2026-01-03 15:41:30 2 -293 -191
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:41:30 2026-01-03 15:41:30 2 -80 -410
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:41:30 2026-01-03 15:41:30 2 -321 201
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:41:30 2026-01-03 15:41:30 2 -380 -435
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:41:30 2026-01-03 15:41:30 2 -315 -15
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:41:30 2026-01-03 15:41:30 2 -67 249
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:41:30 2026-01-03 15:41:30 2 161 -411
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:41:30 2026-01-03 15:41:30 2 47 -106
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:41:30 2026-01-03 15:41:30 2 -503 -261
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:41:30 2026-01-03 15:41:30 2 -174 -427
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:41:30 2026-01-03 15:41:30 2 -122 -143
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:41:30 2026-01-03 15:41:30 2 61 -576