You need to sign in to do that
Don't have an account?
Gary Spencer 100
Wave Dataset Creation Record Row Limit 10000 error
I am creating Datasets using the Dataflow Builder in Wave Analytics. On one dataset I keep getting an error that states the dataflow failed due to record rows exceeds 10000 record row limits... How can I using JSON either break up the extraction into batches or change the default limit.
The maximum number of rows returned per query is 10,000.
10,000 is the default value if you don't specify any value. To set a different value, you can use the SAQL limit statement.
Query timeout will be in 2 minutes.
SAQL limit reference: https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_eql.meta/bi_dev_guide_eql/bi_eql_statement_limit.htm
There is a blog from Andrew about downloading a dataset where he talks about changing the limit and querying more records.. but the maximum he mentions is around 75,000 after which it times out.
- https://www.andrewprice.me/blog/2015/7/5/downloading-a-dataset-in-salesforce-analytics-cloud
For more information check here:- https://resources.docs.salesforce.com/200/latest/en-us/sfdc/pdf/bi_admin_guide_setup.pdf
Please mark this as solved if it helps.Regards,
Nagendra.