CODEWITHSUNDEEP
etldata-warehousewarehouse
rasen58
rasen58

Reputation: 5091

Standard techniques for calling external APIs on data warehouse data

What are the standard ways in which data from a data warehouse can be used to query an external API and then write back to the table in the warehouse?

With a normal database + backend server, it can talk directly to the DB, read from it, query an API, and write back to the row to update a column. But with a data warehouse, a normal backend server won't have direct access to it.

So what are the usual techniques that people use for warehouses? Lambda functions that run on demand? Schedulers like Airflow?

Upvotes: 0

Views: 252

Answers (0)

Related Questions