Cant extract table data since table name "User" is a reserved name

Question

So my problem is, I am trying to extract a table into this dataframe but I cant since the table named "User" is a reserved word... How could I go about this to get past the problem?

Thanks!

attachmentDf = (spark.read 
         .format("com.microsoft.sqlserver.jdbc.spark") 
         .option("url", azure_sql_url) 
         .option("databaseName", database_name) 
         .option("user", sql_user_name)
         .option("password", sql_password)
         .option("encrypt", "true") 
         .option("hostNameInCertificate", "*.database.windows.net")
         .option("dbtable", "dbo."+"User").load()
           )

Error message:

com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'User'.

Try wrapping the table name in `[...]`, for example: `"dbo."+"[User]"` — DavidG, Oct 28 '21 at 15:22
You should really try to avoid Reserved Words. Take a peek at https://learn.microsoft.com/en-us/sql/t-sql/language-elements/reserved-keywords-transact-sql?view=sql-server-ver15 — John Cappelletti, Oct 28 '21 at 15:25
The dupe might be c#, but the answer is the same, delimit identify. — Thom A, Oct 28 '21 at 15:31

score 2 · Accepted Answer · edited Oct 28 '21 at 16:17

2

Try putting square brackets around the table name (e.g. [dbo].[user]). That tells MS SQL to use the string as a field or table name.

edited Oct 28 '21 at 16:17

pltc

5,836
1
13
31

answered Oct 28 '21 at 15:22

JackLThornton

375
3
14

score 1 · Answer 2 · edited Oct 28 '21 at 16:17

1

Since you are using a keyword as a table, you must enclose 'user' in brackets.

ex. dbo.[user]

edited Oct 28 '21 at 16:17

pltc

5,836
1
13
31

answered Oct 28 '21 at 15:22

javisrk

582
4
19

Damn guys you are fast! Thanks! :) – Lasse Oct 28 '21 at 15:23

Cant extract table data since table name "User" is a reserved name

2 Answers2