Small setting in MacOS but makes me happy: change color of highlighting to yellow, to make it more like a normal highlighter (default is blue).
{{embed ((694b5e14-1dff-4e10-b325-ed0dae46e467))}}
DONE Colobbo’s use case
explore {
dimensions {
sites.id,
field_values.field_key,
...
}
filters {
// No direct subquery, so use aggregation logic
// Approach: For each site, count how many of the required key/value pairs exist
(
count_distinct(
case(
when: (field_values.field_key == 'A1' and field_values.value == '123') or
(field_values.field_key == 'A2' and field_values.value == '456') or ...,
then: field_values.field_key
)
) == 2
)
}
}
SELECT
wp.id,
wp.name
FROM tblWorkPackage wp
JOIN tblCustomFieldValues cfv ON wp.id = cfv.entity_id
JOIN tblCustomFieldDefs cfd ON cfv.field_def_id = cfd.id
WHERE
-- 1. List ALL conditions in an OR block
(cfd.field_key = 'A1' AND cfv.value_number = 1) OR
(cfd.field_key = 'A2' AND cfv.value_number = 2) OR
(cfd.field_key = 'A3' AND cfv.value_number = 3)
GROUP BY
wp.id, wp.name
HAVING
-- Ensure the site matched exactly 3 distinct criteria
COUNT(DISTINCT cfd.field_key) = 3;
DONE Write a note to #sales-demo to consolidate drill-through dashboards into one.
Joyful morning, new favorite sit at the cups coffee
DONE Load dbdocs tables into BigQuery
DONE Respond Tricia & Clark
DONE Call - requirements gathering Colobbo
DONE Teach Duc Anh
DONE CS Call with Aarki
DONE Write self review 2025H2
DONE Weekly sync #2026-01-16
https://www.1keydata.com/datawarehousing/processes.html
https://www.ssp.sh/blog/diary-of-a-data-engineer/
DONE Help a Thi with the dbx proposal on dblineage
Idea: Takes semantic layer as center, we provide data for other frontend/UI rendering apps via an API. Every business-related data definitions stay inside Holistics.
DONE Develop dashboard 4
retailer_current_pricing concatAdd2Cart Dashboard Implementation Process
DONE Answer Anurag