How do you version control and reproduce SQL queries across data environments?

Posted by hoshang_mehta on Friday November 24, 2023 @03:03AM
from the self-post dept.

Do you currently have a way to version control and reproduce metrics/SQL queries across different data environments without losing out the underlying business logic & definition?

( 5 comments | on HN )

Re:How do you version control and reproduce SQL queries acro... by DougBTX on Friday November 24, 2023 @03:15AM (#38401672)

Typically my SQL is part of some larger project, tracked in Git, typically with a Python API.

[ Parent | on HN ]

Re:How do you version control and reproduce SQL queries acro... by hoshang_mehta on Friday November 24, 2023 @03:46AM (#38401829)

Got it. Do you have a way to store them as metrics and let your business teams reproduce metrics on their dashboard?

[ Parent | on HN ]

Re:How do you version control and reproduce SQL queries acro... by gigatexal on Friday November 24, 2023 @03:48AM (#38401844)

There are efforts like this along the lines of Metric stores. Tableau has the semantic layer for this. But I’m not sure it’s a solved problem

[ Parent | on HN ]

Re:How do you version control and reproduce SQL queries acro... by hoshang_mehta on Friday November 24, 2023 @04:39AM (#38402133)

That makes sense!

We're trying to build something along these lines with Airbook (https://www.airbook.io) and we're looking for feedback for the same.

Would anyone be willing to connect?

[ Parent | on HN ]

Re:How do you version control and reproduce SQL queries acro... by gigatexal on Friday November 24, 2023 @01:36PM (#38406776)

I’d be down Alex at alexandarnarayan dot com

[ Parent | on HN ]