Starlight Insights | Carlsson

@starlightinsights
0 Followers
0 Following
21 Posts
Starlight Insights data management made easy

> Okay, great, I get that. But how do you achieve it?

The key steps are to follow a clear level of detail, split code into CTEs, and avoid macros.

Your feedback would be amazing! It's brand new, so it's still a bit rough around the edges, and I would love to improve it ❤️🎉

As data professionals, we need to move a lot faster and spend more time engaging with the business. The only way to do that is by being more productive when handling technical work—and the easiest way to achieve that is by outsourcing it to AI.

Yes, one of the main focuses has been to write code that is both human-readable and easy for large language models to analyze.

> But why is that important?

I just put the finishing touches on my new modern SQL style guide.

🔗 https://starlightinsights.com/starlight-data-framework/style-guide

> Modern, you say?

SQL Style Guide

My personal SQL style guide focuses on making complex analytic queries easier to write and maintain as projects grow. It helps avoid common pitfalls, keeps code readable for both new developers and your future self, and makes performance optimization in Snowflake easier.

The Starlight Data Framework is a starting point for great data management. How do you define ownership in your data org? Suggestions & feedback are highly appreciated!

🔗 https://starlightinsights.com/starlight-data-framework/data-contracts

Data Contracts

Data Contracts are detailed documents that support the joint development of data platforms, promoting clarity and consistency among teams.

✅ Align business and technical definitions
✅ Start small—focus on source & model contracts first
✅ Assign both primary and backup owners
✅ Adapt and evolve contracts as your organization grows

💡 Your comment matters!

With Data Contracts, you can clearly define expectations, standardize definitions, and, most importantly, establish true ownership over your data.

📌 Key takeaways:
✅ Define ownership for each data component
✅ Document everything—clarity beats assumptions

🔒 INTRODUCING: Data Contracts
Your data team struggles with misalignment, unclear ownership, and inconsistent definitions—leading to endless debates with business stakeholders. Until now, blame games have been the default.

TODAY, I’m open-sourcing the Starlight Data Warehouse Template—a complete CI/CD and Snowflake developer setup built for enterprise data warehouses.

And yes, it’s free to use—even for business use.

https://www.linkedin.com/feed/update/urn:li:activity:7290257691799695360/

Martin Carlsson on LinkedIn: #datawarehouse #opensource #snowflake #dbt #cicd #lightdash…

TODAY, I’m open-sourcing the Starlight Data Warehouse Template—a complete CI/CD and Snowflake developer setup built for enterprise data warehouses. It’s…