# How to insert data into datasource in dremio using JDBC

**URL:** <https://community.dremio.com/t/how-to-insert-data-into-datasource-in-dremio-using-jdbc/5839>\
**Category:** Uncategorized\
**Created:** [July 1, 2020, 9:20pm UTC](https://community.dremio.com/t/how-to-insert-data-into-datasource-in-dremio-using-jdbc/5839 "2020-07-01T21:20:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![hghub](https://avatars.discourse-cdn.com/v4/letter/h/54ee81/32.png) [@hghub](https://community.dremio.com/u/hghub)\
**Post date:** [July 1, 2020, 9:20pm UTC](https://community.dremio.com/t/how-to-insert-data-into-datasource-in-dremio-using-jdbc/5839/1 "2020-07-01T21:20:14Z")

</div>

From Azure databricks I am trying to push a dataframe so that, i can insert data into an existing mysql database table but I a get this error:

scala code:  
streamingDataFrame.write.mode(SaveMode.Append).jdbc(jdbcUrl, “sentiment\_analysis”, connectionProperties)

error:

org.apache.spark.SparkException: Job aborted due to stage failure: Task 0 in stage 0.0 failed 4 times, most recent failure: Lost task 0.3 in stage 0.0 (TID 3, 10.139.64.5, executor 0): java.sql.SQLException: Failed to create prepared statement: error\_id: “b929187c-8dfe-4f18-8953-2bb383483eab”  
endpoint {  
address: “[dremio-demo-vm.internal.cloudapp.net](http://dremio-demo-vm.internal.cloudapp.net)”  
user\_port: 31010  
fabric\_port: 45678  
roles {  
sql\_query: true  
java\_executor: true  
master: true  
}  
start\_time: 1592941976465  
max\_direct\_memory: 8589934592  
available\_cores: 2  
node\_tag: “”  
conduit\_port: 39955  
}  
error\_type: UNSUPPORTED\_OPERATION  
message: “UNSUPPORTED\_OPERATION ERROR: Please contact customer support for steps to enable the iceberg tables feature.\n\n\n[Error Id: b929187c-8dfe-4f18-8953-2bb383483eab on [dremio-demo-vm.internal.cloudapp.net:31010](http://dremio-demo-vm.internal.cloudapp.net:31010)]\n\n”  
original\_message: “Please contact customer support for steps to enable the iceberg tables feature.”

```
at com.dremio.jdbc.impl.DremioJdbc41Factory.newServerPreparedStatement(DremioJdbc41Factory.java:147)
at com.dremio.jdbc.impl.DremioJdbc41Factory.newPreparedStatement(DremioJdbc41Factory.java:108)
at com.dremio.jdbc.impl.DremioJdbc41Factory.newPreparedStatement(DremioJdbc41Factory.jav
```

---

<div class="post-metadata">

**Author:** ![fetanchaud](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/fetanchaud/32/4192_2.png) [@fetanchaud](https://community.dremio.com/u/fetanchaud)\
**Post date:** [November 7, 2020, 5:20pm UTC](https://community.dremio.com/t/how-to-insert-data-into-datasource-in-dremio-using-jdbc/5839/2 "2020-11-07T17:20:11Z")

</div>

Hi, I think you can only write in file systems sources, with a CTAS, and with the new iceberg feature, with INSERT INTO statements.