擅长:python、mysql、java
<p>背着乔恩。。。这是我用来将数据从Azure databricks dataframe写入Azure SQL数据库的方法:</p>
<pre><code> Hostname = "YOUR_SERVER.database.windows.net"
Database = "YOUR_DB"
port = 1433
UN = 'YOUR_USERNAME'
PW = 'YOUR_PASSWORD'
Url = "jdbc:sqlserver://{0}:{1};database={2};user={3};password= {4}".format(Hostname, Port, Database, UN, PW)
df.write.jdbc(Url, "schema.table", mode="append")
</code></pre>