Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Ray0801
Creator
Creator

tDBInput Compoent produces Invalid escape sequence When Clicking Guess Schema

I have created a microsoft sql server connection,

the connection is succesfull no issues on that,

When I give all the details and click on Get schema.

I am getting the attached error.

Labels (2)
4 Replies
Anonymous
Not applicable

Hi

The 'Guess schema' button is used to guess the schema based on the SQL in the query field, make sure you have written the SQL in the query field, from my experiences, it only works for simple query, we usually add manually the columns on the schema to map the selected fields of query.

 

Regards

Shong

Ray0801
Creator
Creator
Author

@shong,I am getting this error even when I try selecting s single column

Anonymous
Not applicable

Can you please provide the following information for us to be more better evaluate the issue, we need to check if it was a bug.

Which version of studio?

Which operating system?

A sample SQL?

 

Regards

Shong

Ray0801
Creator
Creator
Author

@Shicong Hong​  Version:Talend Open Studio 7.3.1

OS:Windows 10

Query: "Select * from Source_Table"