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

Assignee

Amit Virmani

Reporter

Bhooshan Mogal

Labels

Dev Complete Date

None

Publish Date

None

Reviewer

None

Components

Sprint

Fix versions

Priority

Major