REST API for Datawarehouse Database scenario

  1. I’m not sure. I think API calls are limited by how your tables are named in the DB.

  2. For joins and complex SQL operations, you will likely want to use stored procedures or views. You may also want to check out these forum threads:

  1. Yes! Check out our FAQs and this paper on scalability [PDF].