Ask HN: How do you provide APIs to your Data Warehouse

5 pointsAnurag87011 comment

We have a requirement to expose our data warehouse as APIs. Should we use graphQL or there is some other service to expose say redshift as APIs

View on HN

In my opinion data warehouses are exactly the kind of database that are easiest to use when the API is SQL. BI people can point Tableau at it and get right to work, and lots of data analysts have an easier time writing R & Python against SQL than against REST or GraphQL.

You should take steps to protect your systems, but that is do-able. Here are some more notes about this approach: https://news.ycombinator.com/item?id=18143943

Reply on news.ycombinator.com