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).
This may not be what is causing you problems but in the past when I have went to replace a data source and the option was grayed out I found that it was because I had to be in a sheet that was actively using the data source I wanted to replace.