Ask HN: How do you provide APIs to your Data Warehouse
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
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
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