-
How to import all tables in a mysql database
Hi, Our use case is that we have a mysql database with about 200 tables in, one for each event that we track. We would like to mirror those tables in domo. We have been able to do this with individual tables, by simply setting up the datasource in the GUI with 'select * from event_table_1 where timestamp > curdate()' and…
-
How to change schema of a Dataset created through the Streams API?
Hi, We have data that we want to visualize in domo, and we are planning on loading it into domo using the Streams API, and then building cards based off that data. However, we often need to add columns to our data (eg we start collecting a new property on an event). I can't see any way to change the schema of a data set in…
-
Can I trigger a connector data pull with an API?
Hi, We want to do a regular pull of data from our mysql data into domo. As the table in mysql grows, we want the table in domo to grow - i.e. we want to sync them. The way we would like to do this is: 1. Upload the latest data batch to our mysql database 2. Call the connector API to update the details to say "select * from…
-
API call to change the details of a connector?
Hi, In a conversation with technical support, I thought they said that it was possible to: Fire an API call to change the details of a connector (eg update the sql to read "select * from mytable where timestamp > '2017-04-20') and then: Fire an API call to trigger the connector in such a way that it will append this latest…
