Simple SQL query that runs 7 seconds in SQL takes 19 minutes(!) to validate in Dataflows 19 minutes!!!??? Not just one query. I've tried SQL Server and PostgreSQL - the time it takes to Validate i...
If I could thumbs up this I would a million times over. It makes no sense why it takes so long to 'validate.'
I've had multiple DF's take 20-30 minutes to validate and yet the refresh takes 4 minutes. Makes no sense to me at all. It would be nice if there was some intelligence behind it. I've even had it take that 30 minutes to validate the data flow when the only thing I did was delete a table. Since there is logic in place that prevents me from deleting a query in use, the delete should be clean, why does it require a full rebuild of everything again?