Hello Microsoft Community,
I hope this message finds you well.
I am currently experiencing an issue with a virtual table that connects to Snowflake within Dataverse. Despite having successfully established connectivity with a role that has the privilege to perform SELECT operations in Snowflake, I am unable to see any records in the virtual table.
Here is the structure I've set up:
- Primary Key in the Virtual Table: ID -> in snowflake this fields is a varchar
- Primary Fields in the Virtual Table: FSM_NAME -> in snowflake this fields is a varchar
However, when the virtual table is created there is no error message, but all of the records appear blank, even though there are over 1000 records populated in Snowflake.
Could anyone please provide guidance on why the records are not displaying correctly? Any help would be greatly appreciated!
Thank you.
