since ages I wait for you to do some proper stuff for your customers. This is the first time I follow the invitation to place the idea here, but I still find it blaming for you that I have to do so!
- I need YTD
- I need it through sFTP
- For sure there will be more than 50.000 rows of data
Unfortunately, there is no tool that can fulfill all the 3 requirements!
YTD can only be fetched through Report builder but it wouldn't support rows more than 50,000 and it delivers to FTP only!
Data warehouse will give you unlimited rows with SFTP support but doesn't support YTD feature!
Don't talk about delivering by mail and forget reports & Analytics or Workspace!
This is like the distinct count, which is also not available and a ton of other really normal things when working with data, but you're the Leader in analytics, well....
Can't you just specify the YTD dates in data warehouse? I'm confused why that wouldn't be possible.