MattTriano / analytics_data_where_house

An analytics engineering sandbox focusing on real estates prices in Cook County, IL
https://docs.analytics-data-where-house.dev/
GNU Affero General Public License v3.0
9 stars 0 forks source link

Add Superset configs to setup process, and maybe reimplement that process #84

Closed MattTriano closed 1 year ago

MattTriano commented 1 year ago

This will involve (at least) adding these to the process and having them output to a .env.superset file.

The setup process may be a bit cumbersome with these added to the process, and it felt barely maintainable when I initially implemented it. I should rethink the config secrecy strategy.

MattTriano commented 1 year ago

Upon revisiting that process, it was actually pretty easy (for me, the original implementer) to add new configs, but it would be rather difficult to write clear documentation so that someone else could also easily extend it in a fork. In any case, I added a dev mode to make it easier for such forkers to experiment with adding env-vars without having to hide their existing .env files.

This current implementation shields the user from a lot of potential credential-related bugs, such as:

I still think there's got to be a better way to do this than having a user slog through 15+ prompts where they have to enter passwords, but I'm very pleased by the amount of complexity my implementation shields the user from.