I'm trying to understand Dataverse, and trying to see if it is a solution for me.
Current Process:
PowerApps (Canvas) uses a Custom Connector to reach out to a Third party API. (Workato, very similar to Power Automate, but they have an out-of-the-box snowflake conector)
The API can call a particular recipe (flow) that will query snowflake, and return records to the API and ultimately a Powerapps Gallery. This works as expected, and completely achieves the needs of my app. This is a view(read)-only connection.
The problems with this process:
1)It takes 50 seconds to pull in 500 records into powerapps.
2) PowerApps Custom Connectors can only use a particular Grant Type for OAuth. Workato does not support that Grant Type. Therefore I have been forced to use API Key. I do not want to distribute an API key to 400+ users.
I am trying to figure out if dataverse can solve all of my problems. Specifically, a virtual table.
IF I UNDERSTAND CORRECTLY-
A virtual entity can be created to serve as a virtual table. It can have OAuth (removing the need for an API key)
I am able to set up the columns/schema to receive data in a virtual table, and set up the connection to snowflake. The virtual table populates as needed when users submit a query (Select * from Table1 where ID = 1, will return a single record with that ID to the virtual table, but Select * from Table1 would return many (all) records to the virtual table, and therefore be usable in a powerapps gallery).
Am I misunderstanding?
What is the best way to pull a read-only data from Snowflake into powerapps? I am open to pro-dev solutions.
Please do not tell me that connecting to snowflake is current unavailable in powerapps. While there might be pro-dev code involved, that is fine.
