TheOC
Databricks Partner

hey @austinoyoung ,
I don't have an Oracle database to be able to test this for you, but I believe you can get around this error by following the steps laid out in here:
https://stackoverflow.com/questions/9156379/ora-01882-timezone-region-not-found

In short, I understand the fix to be adding the parameter:

oracle.jdbc.timezoneAsRegion=false


To your connection. Assuming your connection is set up similar to how it is laid out in this article, I believe the additional parameter can be added to the url, as such:

df.write.format('jdbc').options(
    url='jdbc:oracle:thin:@192.168.11.100:1521:ORCL?oracle.jdbc.timezoneAsRegion=false',
    driver='oracle.jdbc.driver.OracleDriver',
    dbtable='testschema.test',
    user='testschema',
    password='password'
).mode('append').save()

 Let me know if this doesn't help and I'll have a deeper dive for you 🙂

 

TheOC

Cheers,
TheOC