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 |
+------+------------+