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...
dbeavon3
Memorable Member
Memorable MemberThis idea is about two years old.
One thing I wanted to point out is that it is currently possible to work around the problem by parameterizing dataflows in a way that has a "fast" and "slow/normal" mode. The fast mode would only return a small subset of data (eg one trailing week), and it would be used during development.
The fast mode, should you create one, would allow "validating" operations to be performed more quickly
When it is time to change your dataflow parameter to run in the "slow/normal" mode you make the switch like follows:
- Export dataflow as json
- Edit the json to swap the value of that parameter
- Import the dataflow.
- Configure the gateway as needed (note that it will "stick" if you change it - even without having to go thru the "validating queries" step).
Here is more info:
Dataflows - U/I Fixed? - No more waiting on "Validating Queries"!!!