Hi Community,
I have 40 crore records, I want to create an extract for that but it is taking too much time to extract. Can I put background task for extracting the data?
Thanks,
Ashitha.
I had no clue what "40 crore" meant until today! I learned something new today thanks to this posting.
Tableau can easily handle millions of records particularly when we added Hyper as the engine to handle extracts of this size. However, you might want to think about not creating an extract of that site since your local PC/Mac may not have the RAM to handle loading that into memory! Probably too much for a laptop!
Extracts don't necessarily improve performance when we are talking about a huge amount of data and I would recommend some other techniques. We connect to DB tables/views that have a lot lot lot more data than 15 million rows and hundreds of columns and yet Tableau works with that just fine. You just need to query your data accordingly and ask yourself what do you really want to show/visualize... you can start for example with a datasource filter and reduce your time range or aggregate dates to granularity you need. There is a Designing-efficient-workbooks document that you should read for improving performance.
I would check out a few publications:
10 Best Practices for Building Effective Dashboards | Tableau Software
