SDF to the Rescue: Overcoming dbt-osmosis's Column Rename Struggles
日本語版はこちら On January 14, 2025, dbt Labs announced the acquisition of SDF Labs. For those unfamiliar, SDF is a multi-dialect SQL compiler, transformation framework, and analytical database engine packaged into one CLI. In the webinar Accelerating dbt with SDF, it was even called "the future of the dbt engine". On the other hand, in Japan, although I've seen some mentions on the acquisition on X, not many people seem to deep-dive the upcoming new tech. So in this post, I want to shine a spotlight on SDF’s potential to enhance the dbt development experience, especially in tackling some of the challenges that dbt-osmosis faces in metadata management. If you want to get hands-on, all the code from this article is available at myshmeh/osmosis_vs_sdf. Feel free to check it out and experiment in your own environment!

On January 14, 2025, dbt Labs announced the acquisition of SDF Labs.
For those unfamiliar, SDF is a multi-dialect SQL compiler, transformation framework, and analytical database engine packaged into one CLI. In the webinar Accelerating dbt with SDF, it was even called "the future of the dbt engine".
On the other hand, in Japan, although I've seen some mentions on the acquisition on X, not many people seem to deep-dive the upcoming new tech.
So in this post, I want to shine a spotlight on SDF’s potential to enhance the dbt development experience, especially in tackling some of the challenges that dbt-osmosis faces in metadata management.
If you want to get hands-on, all the code from this article is available at myshmeh/osmosis_vs_sdf. Feel free to check it out and experiment in your own environment!