Currently we are using sql server as a database and soon we will be moving to aws . So we are in the process for selecting database between Redshift and Snowflake . So just wanted to know which database has better performance in terms of analyzing Petabytes of Data by connecting to Tableau.
Currently we have three database in all the Database Server(Sql server, Amazon Redshift. Snowflake). Each database has same data with same tables. The only diffrence in the three database is the amount of database present. I have been assigned to build Tableau Report First by connecting to Sql Server and then use the same report for all the three database to get the performance metrics Data by doing Performance Recording in Tableau. Once we will get the metrics for sql server then we will test the same report against all the three database but this time with Amazon Redshift and then after this same thing gets repeated for Snowflake . So the basic funda of this is to get the performance metrics of Tableau Reports from all the three database server and then decide which one to go for
So my questions is that database team has geenrated data with the help of some tools and loaded that data into the tables in the database. They are doing Perfromance Testing based on the sql queries generated by tool and checing their execution time by running those queries at the database level like for example by running the quesries in SSMS (for sql server) and other server
1)Should i connect live with the database or extract or should i publish the datasource into the Tableau Server ?
2) How can check at the Tableau level how the underlying database performance is good ?
3) if i build a Tableau Report by connecting with the database server , then how will i determine that this particular server is giving faster results for executing queries . Do i consider building some special types of Visualizations from which i can determine how database performance is