DOMO CLI Interface Search/Filter

I'm trying to better understand how to use the Domo CLI, and have a few questions.

-Is there a way to search for all datasets/flow/cards whose name does not follow a defined convention? Ideally, I'd like to be able to utilize regex to search for patterns. Something like "list-dataset -n TEST%"

-When executing a search, is there a way to only return certain the ids based on defined attributes in the metadata? For example, I'd like to find all datasets who haven't updated in over a month. Or all datasets who are not connected to any cards.

Essentially, I'm exploring ways to more programmatically manage and administer data governance in our instance.

Thanks!

Answers

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🟀

    Have you looked into the Domo Stats and Domo Governance datasets in the appstore? Many of these questions can be answered with these datasets and the Domo Stats quickstart will even build the cards for you that will answer these questions for you.

  • user09644
    user09644 βšͺ️

    I guess that I could use the Domo Stats/Governance outputs to then generate the list of ids to tie to various actions that I want to take to update/delete/move/etc objects. I'm curious what the CLI was designed for? I figured something like this would be a good utilization of the tool.

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🟀

    I don't think the CLI tool was intended to be used as a reporting tool. I believe it was created as a quick way to perform some bulk actions, such as permissions, groups, etc... Here's a link to the KB article.


  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟀

    @user09644

    you could use list-dataflows and output to a csv. then use any other scripting tool (python for example) to continue the automation process.

    @MarkSnodgrass is correct, the CLI is mostly a wrapper for interacting with the APIs, the querying and automation part is the next mile which you'll pick up with Python, Node server or some other scripting environment.


    here's a similar ish example using PyDomo (python sdk)


Sign In or Register to comment.