CLI or native SQL-like GUI for SQL tooling
I would like to see the possibility of creating a SQL-like CLI or GUI (thinking psql, vsql, or Sequel Pro) for SQL dataflow creation or testing.
The current SQL dataflow tool doesn't give a great preview of data when joining multiple datasets or even just adding functions to manipulate data in the same dataset. The preview seems to work with simpler queriers, but fails to present anything but the header row when the query becomes a little more complex. Because of this, you can't see if the output is what you desire. So, you write the query, save it, run it, look at the data, and if it's not what you expected, you have to click back through the UI to edit the query, then click back out to wait for it to run just to check it again.
The current state doesn't allow for quick tooling. It'd be great to have a desktop tool (or just a CLI) that would allow you to access your company's data warehouse, and do query tuning from an environment that doesn't have so many steps like the current Domo UI for SQL dataflows. A CLI would be a decent starting point for something that is OS agnostic. Since some of the desktop tools/plugins that exist for Domo seem to exist on Windows only.
Comments
-
When script is not correct in a SQL statement in importing a dataset, a valid error message should be shown highlighting where the error occured, if possible.
4 -
CLI for R Scripts too, please.
0
Categories
- 11K All Categories
- 5 Private Company Board
- 2 APAC User Group
- 12 Welcome
- 43 Domo News
- 10K Using Domo
- 2K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 349 Workbench
- 267 Domo Best Practices
- 12 Domo Certification
- 474 Domo Developer
- 51 Domo Everywhere
- 111 Apps
- 728 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 31 お知らせ
- 65 Kowaza
- 303 仲間に相談
- 664 ひらめき共有