Welcome to sqlmesh Discussions!

[tobymao]

👋 Welcome!

We’re using Discussions as a place to connect with other members of our community. We hope that you:

• Ask questions you’re wondering about.
• Share ideas.
• Engage with other community members.
• Welcome others and are open-minded. Remember that this is a community we
  build together 💪.

To get started, comment below with an introduction of yourself and tell us about what you do with this community.

[anishjoni]

I am wondering if I can use R transformations with sqlmesh.

My pipeline starts with sqlserver but I do most of my data transformations in r and the feature I want to use sqlmesh for is column level lineage.

If I can export my transformed data tables as csv, can I make a sqlmesh project with sql models of raw data and connect it with a seed model that has the transformed data tables?

Will I be able to see the lineage from sql source tables flowing through the transformed tables created by r(potentially loaded as a seed model)?

[georgesittas]

Hey @anishjoni, can you make a separate "Discussions" thread about this? I imagine this one won't get any visibility by users of the community.

[anishjoni]

sounds good, I'll make a separate post under "Discussions". Thanks!