How to referring table name with space in sqlQuery

General
1

I know using to referring column name with space when using sql in R, but how to referring a table name with space? I tried code below, failed to me. Thank you.

dim_Organization1 <- sqlQuery(odbcChannel1,
"select Organization,
[Organization Street Address] from [dim Organization]")

2

Hi @tjcnnl1 , try wrapping "dim Organization" with a single backtick `

3

This topic was automatically closed 42 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.