Hi, Can we preview the table data on fly when creating the connection, while selecting the source tables?

No, this is not possible right now. There is a Github issue to implement this. You can upvote it showing the issue showing us this is important to you.

Thanks for that! But Im asking could we see the source table data(for example upto 100 rows of each table) in airbytes UI or is there any API for that

Unfortunately it's not possible. Could you open a Github issue requesting this feature?

Sure