Unable to query sys_choice table via ODBC

[hemant10]

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?

[hemant10]

Hi Tony,

I created a ACL on column 'element' and I was able to pull data for that column. Will try to create ACLs for other columns as well and see if it works. But not sure why I have to create at column level when I already have one at table level.

Thanks,

Hemant

[tony_barratt · Accepted solution]

Hi Hemant,

Good news!

You can OK all the fields at the same time with a sys_choice.*

Best Regards

Tony

[hemant10]

Thanks Tony. sys_choice.* works well..

Cheers!

[tony_barratt]

Hi Hemant,

Excellent news!

All good now? If not, can you update with further questions.

If yes consider marking the question as answered, and marking replies as helpful as appropriate.

Best Regards

Tony