KB485150: How to solve the query failure when selecting a table with brackets

Description 

When using SQL Server as the data source during data import, if the selected table contains brackets ([ or ]) in the table name, the default query will be the following: 

Select [new]
from [dbo].[[NEW]]

Why is this happening? 

The bracket character "[ ]" is used as a quoting delimiter. It is not suggested that you include brackets in the table name.
If you want to query a table which contains brackets in the table name, refer to the following workaround. 

Workaround

• Change the query to the following, using quotations (") to replace the brackets ([ ]).
  

  
  Select [new]
  from [dbo]."[NEW]"

  
  
• Enable Quoted Identifiers when using a DSN or DSN-less connection. The query will succeed.
  

How to Enable Quoted Identifiers

Windows ODBC DSN

• Open ODBC Data Source Administrator.
  

• Click Configure.
• Go to the Advanced tab and select the Enable Quoted Identifier checkbox.
  

Linux ODBC DSN

1. Edit the configure file

   ODBC.ini.

2. Change the

   EnableQuotedIdentifiers

   value to

   1

   .
   

   
   [WH_T26.AzureSQLDataWarehouse]
   
   Description=Strategy ODBC Driver for SQL Server Wire Protocol
   Driver=installpath\MYsqls64.so
   
   Database=
   
   HostName=
   
   PortNumber=1433
   
   DoubleToStringPrecision=17
   
   EncryptionMethod=1
   
   ValidateServerCertificate=0
   
   EnableQuotedIdentifiers=1

   
   

ODBC DSN-less Connection

Add

EnableQuotedIdentifiers=1

DRIVER={Strategy ODBC Driver for SQL Server Wire Protocol}; hostname=; Port=1433; Database=; EncryptionMethod=1; ValidateServerCertificate=0;EnableQuotedIdentifiers=1; 

JDBC Driver

Add

EnableQuotedIdentifiers=1

JDBC;DRIVER={com.Strategy.jdbc.sqlserver.SQLServerDriver};URL={jdbc:Strategy:sqlserver://dbcert.database.windows.net:1433;DatabaseName=;User=;PASSWORD=;fetchTWFSasTime=TRUE; EnableQuotedIdentifiers=true;}