- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Labels:
-
Python
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-21-2022 06:55 AM
@Valeri Nteleah please let me know if you need further help on this.
Thanks