CODEWITHSUNDEEP
apache-supersetdruid
Dunco
Dunco

Reputation: 335

Can Superset visualize data returned from a REST API call?

We are trying to use Apache Superset to visualize business data, some of which is stored in SQL based databases, but some of it (think for example of external weather data) we need to access via public APIs (normally REST, but also sometimes push based microservices like websockets and gRPC).

Can Superset surface data in this way, or is it tied to SQL or SQL-like queries/APIs?

Upvotes: 6

Views: 11699

Answers (1)

David Tobiano
David Tobiano

Reputation: 1268

Superset supports any database engine with a DB-API driver and SQLAlchemy dialect (https://superset.apache.org/#databases).

So, in theory, you could wrap your API calls into some custom-developed SQLAlchemy accessible endpoint, but unless you need access to data that's refreshed in real-time, your best bet is probably to ETL the data from these public APIs into some type of reporting data lake.

Upvotes: 11

Related Questions