-
Re: Is it possible with Magic ETL to append a dataflow
It's possible with a Recursive DataFlow: https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_ETL_DataFlow There's an append ETL option for Redshift that's i…1 -
Re: Is there a number of rows restriction in the Domo API query functionality?
I use limit and offset to download tables with more than 1mm rows, like this: SELECT * FROM table LIMIT 1000000 OFFSET 0; SELECT * FROM table LIMIT 1000000 OFFSET 1000000; Or you can use Domo Java CL…1 -
Re: Column Names with R plugin
This will take care of the extra period: names(data) <- stringr::str_replace(names(data), '\\.\\.', '.') Is that issue with the DomoR package?2 -
Re: Is there a number of rows restriction in the Domo API query functionality?
Checkout the Java CLI, link, and its `export-data` function. It grabs the entire dataset as a .csv file. To use the Java CLI, after adding Java to your path, create a script file called `script.txt` …1
