Spark SQL SELECT queries with Spark SQL as the initiator are used to import data from a target data source into Spark SQL.
Example: Using SELECT with Spark SQL as the Initiator Connector
scala> ForeignServer.sql("select * from default.nn1") +------+------------+ |number|name | +------+------------+ |9 |user1 | |10 |user2 | |11 |user3 | +------+------------+