Notes
https://dylanbutler.dev/blog/protect-your-shed/
- https://media.secondbrain.lelouvincx.com/2026/04/65e1fa68872f5012dbebc135a437c0d0.png
- “But looking back on this chapter of my career, I’ve realized something fundamental. The enterprise work taught me how to engineer at scale, but it was the personal projects that kept me an engineer”.
- He said it right. The side project teaches a lot of things enterprise work does not. And furthermore, it’s like a pet thing that you love, you actively put effort, and get motivated.
- Just like how I feel on my side projects.
- Looking back in the past, I think everyone had a pet thing outside of daily days: someone like LEGO, drawing, guitaring. If I were a man in renaissance period, I may obsess with sculpture and mechanics.
NOTE Top priority this week is transfering tasks from anh Hieu to team (me, anh Dong, Thuan). Don’t let it get crowded out by carry-over work.
Regarding workload between projects get context overhead
- There are many projects those are always default: [[Internal]], [[Presales]], [[Docs]], [[Personal]], [[Teaching]]. Should consider methods like Focus Days (or what else I need to research more) to reduce.
- Right now I don’t feel context-switching cost is high because I’m still happy with exploring and learning new things.
((69dc57a1-6e2d-411c-a00e-a7cbdbcbfcec))
- https://docs.getdbt.com/docs/cloud/canvas?version=1.12
- https://media.secondbrain.lelouvincx.com/2026/04/1aa39421d0986f25112eb3229828a48a.png
- Pretty cool stuff from [[dbt Cloud]]: canvas.
- From the image, I can see that not only models are presented, but also CTEs get transformed from upstream models.
- For example, Join CTE, Order CTE, Filter CTE, etc.
- https://docs.getdbt.com/docs/cloud/canvas?version=1.12
((69dc57a1-7a1a-4b94-a0cd-c4232453176a))
- The article is biased by Fivetran. Best data ingestion tools to me are: dlt/Fivetran/Airbyte. Each comes with pros and cons. While dlt and Airbyte are free for self-hosted, Fivetran is general better low-code tool to ingest SaaS data such as HubSpot, Calendly, Stripe, Zoho, etc.
https://nickbes.github.io/meta-sql/
- https://media.secondbrain.lelouvincx.com/2026/04/b107fb43a57af1d4224fcd98e6d8bade.png
- Found a data lineage graph that presents dependency lineage pretty cool to learn from to improve [[dblineage]]
From ((69dc57a1-995c-40e5-bad4-44714b826fb0))
- The article is a bit AI-like but spot on something at Holistics we’re building. This is worth looking at to improve my embed demo app, when proposing it as a presales toolbox for trying Holistics embedding solution.
- For a prospect coming for embedding solution, they look for:
- UIUX experience
logseq.order-list-type:: number
- Branding logseq.order-list-type:: number
- White-labelling logseq.order-list-type:: number
- Security
logseq.order-list-type:: number
- JWT-based context that passes: tenant, user, role. logseq.order-list-type:: number
- Row-level and column-level permissions. logseq.order-list-type:: number
- Seamless user provisioning: new users, new tenants, and role changes inherit the right analytics access the moment they authenticate – with no manual setup inside the BI tool. No syncing. No drift. No risk of users seeing too much (or too little). Innerspace asked for a similar one. logseq.order-list-type:: number
- Embedding
logseq.order-list-type:: number
- Embedding: a single dashboard (with full interactivity), dataset, AI. logseq.order-list-type:: number
- Save to shared/personal workspace. logseq.order-list-type:: number
- Two-way communication and event handling. logseq.order-list-type:: number
- Self-serve exploration
logseq.order-list-type:: number
- Easy-to-use explore UI that users can feel confident (they won’t break anything) and contextful. logseq.order-list-type:: number
- Drill through, drill/break down, view underlying data. logseq.order-list-type:: number
- Writeback
logseq.order-list-type:: number
- Persistent annotations. logseq.order-list-type:: number
- Secure writeback directly into warehouse. logseq.order-list-type:: number
- Governance
logseq.order-list-type:: number
- SQL lineage that shows exactly how every metric is calculated. logseq.order-list-type:: number
- Version-controlled semantic logic. logseq.order-list-type:: number
- Audit logs for access, change, usage behavior (Embedded Usage Monitoring). logseq.order-list-type:: number
- Event tracking system to understand how users interact with analytics enabling true product analytics and upsell opportunity. logseq.order-list-type:: number
- Delivery
logseq.order-list-type:: number
- Export: PDF, PPT, Excel, CSV which respect security, branding, data format. logseq.order-list-type:: number
- Subscription: email, slack, webhook. logseq.order-list-type:: number
- Alert. logseq.order-list-type:: number
- AI
logseq.order-list-type:: number
- Exploration
logseq.order-list-type:: number
- Dataset logseq.order-list-type:: number
- Dashboard logseq.order-list-type:: number
- Widget logseq.order-list-type:: number
- AI smart insight in widget. logseq.order-list-type:: number
- Exploration
logseq.order-list-type:: number
- UIUX experience
logseq.order-list-type:: number
- [[Data Application]]
Tasks
Partly today
DONE Transfer MRR and exchange rate project with anh Hieu
Read the document DE 187 first, prepare question list to ask on tuesday.
In general the most blocking projects are:
- Customer identity resolution
- Progress: already refactored dbt logic to be more clear, handle edge cases. The root cause still remains: domain mapping is not reliable.
- Exchange rate
- Progress: Understand finance team’s demand. The exchange rate configured in Zoho is currently static to protect customers don’t see their payment fluctuate over time, but it comes with a trade-off: does always reflect correct exchange rate at the purchase time.
- Finance team pivot to bi.holistics.io as the source of truth for MRR - main use case is monitor subscription health.
- NOTE Be clear from the business definition first.
- Customer identity resolution
Other projects are:
- dbt monitoring flow: DE 176
- Progress: suspended due to low priority. Probably revamp after cleaning up BI and dbt layer.
- Increase frequency of Impersonation Lookup
- dbt monitoring flow: DE 176
Exchange rate from https://holistics.slack.com/archives/C79QB3FEV/p1773810885213959
DONE Write 1-on-1 report
- Partly okay. Will complete in wednesday.
Done