I am exploring to load incremental data to Synapse SQL(internal sql pool table) from Synapse notebooks. I see Scala has the connector to write the data (write.SynapseSQL), but looks like it doesn't allow inserts to the existing table.
Can you please point to some documentation/samples for achieving this.