Wrangler fails when connecting to a table whose name starts with a number

Description

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.

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

Assignee

Reporter

Components

Fix versions

Priority

Created April 1, 2021 at 9:17 PM
Updated January 10, 2023 at 11:28 PM