We have our Data Warehouse(Postgres) and out of it we have Datasets which we define(d). We are uploading them to Domo via Using the CLI.
This data is in tables in our Data Warehouse. What is the best architectural approach to do that?
Would it make sense to have table returning functions in the Database System, which we call and retrieve the data. When yes, how could we call this functions and transport the returned data directly to our DOMO datasets in a scheduled way. In general what can be a good approach to handle also new reporting requests?