โ04-06-2022 04:03 AM
I have followed the steps given here to parse .accdb files using ucanaccess on Azure Databricks, however, I receive errors.
See below my code:
# Connection properties
conn_properties = {"driver" : "net.ucanaccess.jdbc.UcanaccessDriver"}
# Path
url = "jdbc:ucanaccess:///dbfs/mnt/dropzone/xyx.accdb"
# Table
dbtable = "full questionnaire"
# Dataframe
df_accdb = spark.read.jdbc(url = url, table = dbtable, properties = conn_properties)
df_accdb.printSchema()
Below is a screenshot of the error message:
Any tips on how I can resolve this issue?
Thanks in advance!
โ05-12-2022 10:38 PM
@Valeri Nteleahโ this looks like data privilege issue, This might help you if I understand correct - https://docs.databricks.com/security/access-control/table-acls/object-privileges.html#:~:text=The%20....
โ04-07-2022 03:38 AM
Hi @Valeri Nteleahโ , Please try to use a PreparedStatement and a parameterized query.
โ05-09-2022 04:06 AM
Hi @Valeri Nteleahโ , Just a friendly follow-up. Do you still need help, or did you find the solution? Please let us know.
โ05-12-2022 10:38 PM
@Valeri Nteleahโ this looks like data privilege issue, This might help you if I understand correct - https://docs.databricks.com/security/access-control/table-acls/object-privileges.html#:~:text=The%20....
โ05-21-2022 06:55 AM
@Valeri Nteleahโ please let me know if you need further help on this.
Thanks
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโt want to miss the chance to attend and share knowledge.
If there isnโt a group near you, start one and help create a community that brings people together.
Request a New Group