Consume data from API

[Andrea]

We are developing an API Rest to extract data from our databases so it’s relevant for us to know: Does Redash have the capability to consume data from API such as data source.? Is it possible this scenario?

[jesse]

Redash is pretty good at this. You should try the JSON API data source. If it’s not quite suited to your specific API, it’s also quite easy to add your own custom query_runner specific to your needs.

Feel free to keep asking questions if you need further direction.

[Andrea]

I’d like to know more about how can we add our custom query_runner?
Thanks.

[jesse]

We’re working on new and improved docs for this. Meanwhile, this is the guide most people use:

Creating a new query runner (data source) in Redash

To support new data source type in Redash, you need to implement a Query Runner for this data source type. I’m working on a Snowflake query runner, so decided to use this opportunity to describe the process of adding a new data source: We start with implementing the BaseQueryRunner class: from redash.query_runner import BaseQueryRunner class Snowflake(BaseQueryRunner): def run_query(self, query, user): pass The only method that you must implement is the run_query method, which a…

Also happy to answer questions here on the forum if you get stuck.