Difference between writing a custom SQL on Quicksight when your data source is Athena vs Creating a view on Athena itself and then using it on Quicksight

@shweta ,

For Q1 , i have explained it here : Incremental Refresh Limitations Question - #9 by Koushik_Muthanna
For Q2 , I believe yes , though you would have to test it out when the date is field is used in partitioning.

Kind regards,
Koushik