When to use live and when to use extract connection
Live can be used when-
1. You need data in real-time
2. Your source is optimized for the performance
3. You don't have a lot of data at the backend
4. Not many transformations are involved which can slow the performance
The extract is preferred when-
1. When a database is not optimized for performance
2. You don't need data in real-time
3. Want to have great dashboard performance