Wrangler fails when connecting to a table whose name starts with a number
Description
Release Notes
None
Activity
Show:

Sneha Lakshmisha September 1, 2021 at 10:37 PM
It was fixed as part of
Unresolved
Pinned fields
Click on the next to a field label to start pinning.
Details
Details
Assignee

Reporter

Labels
Components
Sprint
Fix versions
Priority
Created April 1, 2021 at 9:17 PM
Updated January 10, 2023 at 11:28 PM
When user is retrieving data from PostgreSQL 12, 1 error message "syntax error" showed up when attempting to display data from table name such as "111_table1" (a table name starting with a number)
While this issue can be addressed in the pipeline job by modifying the query in database object property by putting quotation mark around the table name:
SELECT * from "111_table1"
it will be good if the issue can be address within Wrangler UI side.