search

databricks / databricks-sql-go

Golang database/sql driver for Databricks SQL.
Apache License 2.0
34 stars 37 forks source link

How to do bulk insert like 100K rows into databricks #194

Open ganeshkompella opened 3 months ago

ganeshkompella commented 3 months ago

I'm looking a way other than raw queries, also using prepared statements I'm able to insert only 1 entry at a time & that to using Parameter{Name: "value", Value: "100"})

is there any library to support bulk insert or any way ? I need some boilerplate code.

mroy-seedbox commented 3 months ago

Write your data into files. CSV or JSON are usually the easiest to handle. Then those are easy to load into Databricks.