Show Estimated Table Row Size in UI
Answered
Show estimate table row size in the UI next to each table. This would help from an efficiency standpoint of understanding which larger tables might make sense to break into separate connectors and help determine when tables might take longer to replicate at first due to size.
Most databases store table and row size in information schemas which I believe Fivetran already uses to identify table structure. Example MySQL below.
SELECT table_name, table_rows
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = '[db]'
and table_name in ('table1','table2');
-
Official comment
Hi David,
Thanks for your feedback here! This is a reasonable request, although we at Fivetran would like to remove as much of the database management complexities or size/volume concerns from the user as possible.
Ideally, we improve the speed of the MySQL connector significantly so that time or sync duration is less of a concern!
I will review this with our team, but please note that we are prioritizing database replication speed and performance as a top initiative. We hope to make connecting to databases easy, simple, and fast!
Please sign in to leave a comment.
Comments
1 comment