According to best practices, we should integrate our data pipelines with Tableau Server using tabcmd. The following diagram will show us the common architecture of a modern data warehouse project:
We will install the Linux version of Tabcmd on a Matillion EC2 instance and integrate with Tableau Server. We should be sure that our ETL and Tableau Server can talk with each other. In our case, we will use the same AWS account and region in order to use the same private network. In case you have Tableau Server on-premise, you should configure your firewall. We choose Matillion ETL because this is the leader among modern cloud ETL solutions and works with Redshift, Snowflake, and BigQuery.