I finally was able to figure out PostgreSQL and switch my daily updates from writing .csv files (which sometimes need to be overwritten etc) to being dumped in a PostgreSQL database instead.
When trying to switch the datasource from my massive csv file (over 7 million rows) to my new database, I was not given an option to replace the source. Any ideas?
I really do not have the time or energy to rebuild these dashboards from scratch and do all of the formatting again so I am really hoping that there is an easy solution. All column names are exactly the same (literally the CSV was just inserted into postgres).