You can export data to a remote system by using an INSERT statement to place data into an existing table. The table can be empty or can contain data. If the table already contains data, the exported data is appended to the existing table.
Example: Using INSERT with Spark SQL as the Initiator Connector
scala> ForeignServer.sql("insert into default.nn1 values (8, 'user1')")
scala> ForeignServer.sql("insert into default.nn1 select * from players2")