Skip to main content

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:

Certified users only