Extend 'preview' mechanism to kedro-datasets

[MehdiNV]

Description

Ticket SQL is blocked as existing solutions aren't viable.

The most optimal solution would be modifying kedro-datasets to have a new supporting method for kedro-viz, which would shift responsibility from viz to kedro-plugins instead. Easier to test, less coupling between the two systems.

Context

A change like this is accepted by multiple team members - it's a viable compromise, but still doable

Possible Implementation

Adding the existing 'preview' method in kedro-datasets to ones like SQLQueryDataset.

[rashidakanchwala]

Refer to the spike work done here - #1623

[astrojuanlu]

One thing that is not clear to me - is the idea to extend the _describe method to allow this preview mechanism? Given that _describe already returns a dictionary, would be nice to reuse it (as suggested in #1714)

[SajidAlamQB]

I've been trying to understand this issue and have some questions:

Can we confirm the scope of this ticket, is there list of dataset types that need the preview functionality extended?

Will the implementation follow similar structure done in kedro-org/kedro-plugins#504?

[SajidAlamQB]

Extended preview to the following:

• ParquetDataset
• SQLTableDataset
• pandas.JSONDataset
• JSONDataset

in kedro-org/kedro-plugins#595