Move mouse over a fusion table feature and pause a while (configurable, default < 0.5 sec), a map tip will display. (documentation)

Select an sample fusion table: Point Line Polygon