Snoeflake integration ACL for sys_dictionary.sys_id

NaBian
Tera Contributor

Hi, I am receiving this error as below, in the documentation from snowflake. they need access to sys_dictionary.sys_id, but I can not set this up as it is not selectable. 

 

Data ingestion for a ServiceNow table fails with an error "table does not have sys_id column and can...

NaBian_0-1757026015504.png

 

2 REPLIES 2

Ankur Bawiskar
Tera Patron
Tera Patron

@NaBian 

you cannot do anything here.

Exposing sys_id on Dictionary table is not recommended.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

kaushal_snow
Mega Sage

Hi @NaBian ,

 

Since sys_id on sys_dictionary cannot be individually selected via ACL UI, your best approach is to ensure the connector user has broad access (read/query) to the entire table, effectively bypassing per field restrictions....

Create or configure a dedicated ServiceNow user for the connector.

 

Assign roles or ACLs granting this user read, query_match, and query_range access on the full sys_dictionary table, not just on selectable fields....

 

Likewise, ensure similar access rights on sys_db_object, sys_glide_object, and sys_table_rotation. and confirm that no ACL rules unintentionally restrict access to metadata tables.

 

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.

 

Thanks and Regards,
Kaushal Kumar Jha - ServiceNow Consultant - Lets connect on Linkedin: https://www.linkedin.com/in/kaushalkrjha/