topic Re: net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::5.0.1 user lacks privilege or object not found: full questionnaire in statement [SELECT * FROM "full questionnaire" WHERE 1=0] in Data Engineering

net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::5.0.1 user lacks privilege or object not found: full questionnaire in statement [SELECT * FROM "full questionnaire" WHERE 1=0]

valdereo — Wed, 06 Apr 2022 11:03:27 GMT

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!

Re: net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::5.0.1 user lacks privilege or object not found: full questionnaire in statement [SELECT * FROM "full questionnaire" WHERE 1=0]

Atanu — Fri, 13 May 2022 05:38:20 GMT

@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%20Databricks%20data%20governance%20model,tables%2C%20views%2C%20and%20functions.

Re: net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::5.0.1 user lacks privilege or object not found: full questionnaire in statement [SELECT * FROM "full questionnaire" WHERE 1=0]

Atanu — Sat, 21 May 2022 13:55:35 GMT

@Valeri Nteleah please let me know if you need further help on this.

Thanks