Unable to query sys_choice table via ODBC

hemant10
Kilo Contributor

Hi,

I am relatively new to SNOW. I was trying to connect to SNOW database via ODBC. The idea is to pull data into a local SQL Server database.

I was successfully able to create a linked server and connect to the SNOW db. I am also able to query the Incident and few other tables successfully.

However when I try to query the sys_choice table, I get NULL data for most of the columns.

Can someone help here? IS there anything special about the sys_choice table?