Rest Api call
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-16-2024 10:32 PM
There is a requirement to create a pipeline that calls a rest Api and we have to store the data in datawarehouse which is the best was to do this operation?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-17-2024 12:08 AM
there are several ways to do this.
you could use python (or scala or ...) to do the call. then transform it and write it to the dwh.
Or you could do the call, write the raw data and process it later on.
Or you could use an ETL/ELT tool that can do the rest call (so you do not have to program it using python or whatever) and transform the data with databricks or some other tool.
Basically there is no best way, it depends on your needs and the functionality of the API itself and the tools you can use.
But it is definitely possible.