title: How to INSERT INTO Azure SQL database from Azure Databricks in Python
body: <p>Since pyodbc cannot be installed to Azure databricks, I am trying to use jdbc to insert data into Azure SQL database by Python, but I can find sample code for that.</p>
  
  <pre><code>jdbcHostname = "xxxxxxx.database.windows.net"
  jdbcDatabase = "yyyyyy"
  jdbcPort = 1433
  #jdbcUrl = "jdbc:sqlserver://{0}:{1};database={2};user={3};password={4}".format(jdbcHostname, jdbcPort, jdbcDatabase, username, password)
  
  jdbcUrl = "jdbc:sqlserver://{0}:{1};database={2}".format(jdbcHostname, jdbcPort, jdbcDatabase)
  connectionProperties = {
    "user" : jdbcUsername,
    "password" : jdbcPassword,
    "driver" : "com.microsoft.sqlserver.jdbc.SQLServerDriver"
  }
  
  pushdown_query = "(INSERT INTO test (a, b) VALUES ('val_a', 'val_b')) insert_test" 
  </code></pre>
  
  <p>Please advise how to write insertion code in Python.
  Thanks.</p>