What’s the Best Way to Share SQL/Python Query Results with External Users?

Have you thought about using Grafana? It’s another great tool for visualizing data.

Consider using Power Query in either Excel or Power BI. It's designed for situations like yours where users can work with embedded data easily, making it a solid choice.

If you're looking for an alternative to Power BI, Evidence is a cool open-source framework. You can write SQL queries, primarily against DuckDB, and it pre-loads them for quick access. You create dashboards using a Markdown/HTML-like syntax, plus you get version control with Git. The output is a static HTML dashboard, which could be quite handy!

I built a backend API that serves data to the front end, pulling it from SQL or files. To allow users to filter and run complex SQL queries, I utilize DuckDB with WebAssembly and some JavaScript. This way, users can run queries right in their browsers without needing to sandbox queries on the server side. It's worked out really well for me!

It really depends on who your audience is. For example, in my Big Data projects, I often export tables to Parquet files. Researchers then load these into Python for their own analyses.

If your goal is to let users visualize datasets based on specified parameters, you might want to check out Metabase. It offers data sandboxing, which simplifies the process since you won't have to build the whole application from scratch. If you want to go the custom route, libraries like Flask or FastAPI can help, but make sure to include an authentication layer to manage access to sensitive data.