Can Spark JDBC create duplicate records

brickster_2018
Databricks Employee
Databricks Employee

Is it transaction safe?Does it ensure atomicity