Power Platform Community Forum Thread Details

I am trying to build an AGENT which will perform some data quality check on my Azure synapse dedicated pool SQL warehouse tables. Looking to build with No code experience and purely based on Prompt. The agent I am looking to run on daily trigger at a schedule time. The basic checks I am looking to perform via the agent are Null column check, row count threshold, rolling median, MAD score, Z score, Table freshness check. All this via the prompt with no code or calling any stored procedure or notebook is not what I want. Please Suggest me the best approach and details on this.

Categories:

Autonomous agents

Hi dude,

Ok, there is a lot to talk about here. Some elements won't be feasable with Copilot Studio in my opinion.

First of all, regarding the scheduling, you can run a Copilot Studio agent on a daily schedule using Power Automate.
--> Create a cloud flow with a Recurrence trigger (scheduled daily) and use the "Execute Copilot and Wait" action to invoke your agent at a specific time.

Now, for SQL, Copilot Studio has an "Execute a SQL Query" action via the SQL Server connector. --> You can connect to Azure SQL databases (though not being an expert in Azure Synapse, you might have to dig a bit on that).

That being said, issues I can see are the following one :

Statistical calculations require structured SQL queries with specific formulas. I don't think these can be generated reliably through natural language prompts alone
The SQL connector action requires you to write the actual SQL query in the action configuration, not generate it dynamically from prompts
Table freshness checks will still need pre-defined SQL queries like: "SELECT COUNT(*) FROM table WHERE column IS NULL"

To date, I am not aware on copilot studio being able to fulfill all of your requirements.

Did you look into Fabrics and potentially connect the Fabric Agent to your orchestrator agent ?