Fetch Dataset based on some selection criteria using DomoR

user05966
user05966 Member
in Connectors

Hi,

 

I use DomoR package to download a Dataset onto my R environment for further processing.

 

I am wondering is there is any possibility to fetch data based on SQL query. Like, instead of fetching entire dataset, it is possible to fetch data like

 select * from Dataset where Age > 20

My original Dataset is quite huge so I failed to download entire data in R

 

If it is not possible with DomoR, then is there any Connector to avail the same?

Comments

  • ST_Superman
    ST_Superman Domo Employee

    You could use ETL or MySQL dataflows to filter your larger dataset or create partitions so you can download smaller datasets into your r environment

Categories