I am trying to retrieve the data in MS SQL databse via Presto. I am simply using an SQL block and giving details of the SQL server and clicking on run button.
SQL query is very simple → Select * from Community_Table;The data i am working with has varchar columns with names "Serial number","Street name","contact name", etc.
The challenge i am facing is that though the values of all the records are being read accurately,
the names of the columns are not being reflected. Instead of "Serial number" , i am getting the name of the column as "Column1".
I have tried using various ways to call upon the column names including , "", /" but still the issue remains.
Any help is highly appreciated !