I was wondering if Tableau can easily connect to a master table if I went ahead and partitioned our database (postgreSQL). We are getting around 2 million+ rows a day for certain tables and the current process is just appending them to one big table. This was okay for a long time but I think it finally makes sense to do some partitioning.
For example, create an employee level per-30 minutes data empty master table. Then create separate tables with the actual data (partitioned based on the source and maybe quarterly).
Will tableau be able to connect to that master table and still be able to query and extract the data from the other tables?
I would contact support to verify but I'm pretty sure you should be able to. You may have to create multiple connections and join the data or write some custom sql but you should be alright.