Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Ways to minimize S3 fetches and without affecting performance?

Right now, we access data and run daily loads on our database cluster (ETL Load) and monitor this data by populating dashboards with information from the last three months. How can we design this kind of query to minimize fetches to the depot without sacrificing performance?
Optimizing Query Performance and Resource Pool Tuning
@rbankula @bat
Tagged:
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Answers
Hi,
A good reference as a starting point that may provide a lot of insights is this Knowledgebase article. https://www.vertica.com/kb/ETL_Considerations_in_EON_Mode/Content/BestPractices/ETL_Considerations_in_EON_Mode.htm
I hope it helps.