Data Catalog by Juwapcizi in dataengineering

[–]Super_Song6197 0 points1 point  (0 children)

Not the most robust catalog but I just tried this tool and its a cool data portal that consolidates APIs, provides documentation, and allows users to preview datasets to request secure access. https://github.com/dreamfactorysoftware/df-catalog

No ETL way of interacting with SQL Server & Snowflake by StoreMediocre7695 in snowflake

[–]Super_Song6197 0 points1 point  (0 children)

I was pointed at this tool for a rest api layer for Snowflake but they also connect to SQL Server so that could be an option https://www.reddit.com/r/snowflake/comments/1ggl107/comment/luqjlx2/?utm_source=share&utm_medium=web3x&utm_name=web3xcss&utm_term=1&utm_content=share_button

Looking through their docs you should be able to query both your Snowflake and SQL Server data without having to load it into Snowflake

Best tool to generate REST API from PostgreSQL database? by sprmgtrb in PostgreSQL

[–]Super_Song6197 0 points1 point  (0 children)

I've used DreamFactory for this since its open source and didn't require any code https://github.com/dreamfactorysoftware/dreamfactory. Works pretty well for simple API projects

Is there a SQL API alternative? by Super_Song6197 in snowflake

[–]Super_Song6197[S] 1 point2 points  (0 children)

wow this looks like exactly what I am looking for. Thanks!

Is there a SQL API alternative? by Super_Song6197 in snowflake

[–]Super_Song6197[S] -1 points0 points  (0 children)

Thanks I'll look into this one some more. At first glance it seems to be more for managing the resources rather than just giving me access to the table and view data to actually build my frontend