spark
employee
98f11b7a7880169c
Normalized: spark
github
linear
moreland_dashboard
toggl
Entity Properties (gold employee table)
employee_id
98f11b7a7880169c
name
spark
email
—
nickname
—
doer
—
squad
—
loaded_cost_hr
—
canonical_metadata
—
created_at
2026-02-12 05:22:47.072254+00:00
updated_at
2026-02-12 05:22:47.072254+00:00
71%
Separation Confidence
How distinct this entity is from others. Higher means no close matches existed when it was created. Lower means a near-match was rejected just below the 80% threshold — worth reviewing.
Clearly distinct from other entities
98%
Avg Match Confidence
The average confidence score across all active source mappings. Shows overall quality of linkage between source records and this canonical entity.
Strong source linkage
Source Mappings (11)
| Source | Source ID | Display Name | Confidence | Method | Status | Actions | |
|---|---|---|---|---|---|---|---|
| github | 1017625912 | spark | 1.00 | exact | Active |
|
|
| github | 223314899 | spark-247 | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_github_pull_requests
id
3339865659
number
9
state
open
title
feat(moreland): add JSONPlaceholder posts & comments pipeline
body
## JSONPlaceholder Pipeline
Adds a full data pipeline for [JSONPlaceholder](https://jsonplaceholder.typicode.com/) extracting `posts` and `comments`.
### Connection
- **Type:** `rest_api_none` (public API, no auth)
- **Base URL:** `https://jsonplaceholder.typicode.com`
- **Connection ID:** `c44afe84-ae3d-4fb6-bf10-6168a03cf214`
### Files Added
| Layer | File |
|---|---|
| Connector | `connectors/jsonplaceholder/pipeline.py` |
| Bronze | `dbt/models/bronze/bronze_jsonplaceholder_posts.sql` |
| Bronze | `dbt/models/bronze/bronze_jsonplaceholder_comments.sql` |
| Silver | `dbt/models/silver/silver_jsonplaceholder_posts.sql` |
| Silver | `dbt/models/silver/silver_jsonplaceholder_comments.sql` |
| Gold | `dbt/models/gold/jsonplaceholder_posts.sql` |
| Gold | `dbt/models/gold/jsonplaceholder_comments.sql` |
| Gold | `dbt/models/gold/schema.yml` |
| Cube | `cube/model/cubes/jsonplaceholder_posts.cube.yml` |
| Cube | `cube/model/cubes/jsonplaceholder_comments.cube.yml` |
| Entity Config | `entity_configs/post.yaml` |
| Entity Config | `entity_configs/comment.yaml` |
| Skill | `skills/jsonplaceholder-content/SKILL.md` |
### Test Results
- ✅ **Validate:** 13/13 files passed (25ms)
- ✅ **Extract:** 100 posts + 500 comments loaded successfully (2.9s)
### Notes
- Uses `_get_destination()` helper — auto-selects pg_lake (Iceberg) in production, falls back to postgres in sandbox
- `dataset_name` read from `DATASET_NAME` env var
created_at
2026-03-01 03:20:47+00:00
updated_at
2026-03-19 05:07:18+00:00
closed_at
—
merged_at
—
author_id
223314899
author_login
spark-247
repo_name
moreland-connect/foundation-data-platform
repo_full_name
—
base_ref
—
head_ref
—
additions
—
deletions
—
changed_files
—
_dlt_meta
—
|
|||||||
| linear | 9a181233-8607-4e08-8faa-fb5d0a9a2e32 | Spark | 1.00 | exact | Active |
|
|
|
Source Record
bronze_linear_projects
id
9a181233-8607-4e08-8faa-fb5d0a9a2e32
name
Spark
description
—
team_id
—
team_name
—
state
—
created_at
—
updated_at
—
_dlt_meta
—
|
|||||||
| linear | b39fecdc-4900-48c6-9a30-4ecaa35126e9 | - | 1.00 | exact | Active |
|
|
|
Source Record
bronze_linear_users
id
b39fecdc-4900-48c6-9a30-4ecaa35126e9
name
Spark
display_name
spark
email
spark@morelandconnect.com
active
—
created_at
—
_dlt_meta
—
|
|||||||
| moreland_dashboard | oJVeF5Ji1g1scg | Spark | 1.00 | exact | Active |
|
|
| moreland_dashboard | rQ+Se7mCzKzRiQ | Spark | 1.00 | exact | Active |
|
|
| moreland_dashboard | 6tQlq1K6bRePRQ | Spark | 1.00 | exact | Active |
|
|
| moreland_dashboard | /eBGFVDgPDfgDw | Spark | 1.00 | exact | Active |
|
|
| moreland_dashboard | ZssNJVE9FTmsHg | Spark | 1.00 | exact | Active |
|
|
| moreland_dashboard | gtLxRNUt8FJKuQ | Spark | 1.00 | exact | Active |
|
|
|
Source Record
bronze_moreland_dashboard_md_timetoqb
toggl
Spark
quickbooks
Unbillable
sg_a_spread
False
project_type
Internal
billing_type
Unbillable
squad
—
qa_partner
—
project_manager
—
lead_dev
—
|
|||||||
| toggl | 212680934 | Spark | 1.00 | fuzzy+embedding | Active |
|
|