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
Ask HN: How do you provide APIs to your Data Warehouse
1–2 of 2 posts
Re: Ask HN: How do you provide APIs to your Data Warehouse
#2In 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