Show HN: Tool for Automating SQL Transforms

4 points

6 years ago

Hey everyone this is Michael and Daniel from the structure.rest team. We built structure as an alternative to the command line based tools that currently exist for building DAGs for your data warehouse.

With command line based tools, you have to edit and explore in a sql editor, paste that into a code editor, use the command line tool and use a web browser to view your data catalog. And then you have to go back and forth constantly between all these tools and do this over and over again for the hundreds of models in your DAG.

Instead, we’ve built an open source editor + command line utility that integrates all of this into a single integrated experience. We feel that better tools lead to better data analysis which helps organizations make better data driven decisions

Here’s a video that shows how intuitive the structure editor is: https://www.youtube.com/watch?v=hskhBTyg258

Come check us out at www.structure.rest and join our slack (https://join.slack.com/t/structuresupport/shared_invite/zt-ddx04ho4-_q43i5o3zQ9jv00qx~dx8A) . Both the editor and command line utility are open source and the editor downloads as an app for Windows, Linux, and Mac. Our command line tool makes it easy to run your DAG as part of CI/CD.

We currently support snowflake (https://www.snowflake.com/), but we are looking forward to supporting other platforms. Let us know if there is a platform you would like us to support next.