SQL Interaction
Every Yres database (IRIS_DWH) can be managed through a SQL endpoint (SSMS, Azure Data Studio). Recommendation: use the webapp for most tasks. Some functions are only available through SQL, and without a frontend subscription the SQL endpoint keeps existing sources available. Adding new sources via SQL is not possible — that always goes through the wizard in the webapp (which generates the corresponding ADF pipelines).
This page is the catalog
Below are the names per schema with a short description. The full purpose, inputs and outputs per object are on the detail pages:
- Stored procedures — all 111 procedures
- Functions — all 66 functions
- Logs & views — log tables + all 51 views with output columns
Certified users only