Dataset Run Time
Best Answer
-
Both Dataset and Dataflows have a History tab at the top when you are in it for properties...it should show you run times there.
Matt
*Please Like to Thank
1
Answers
-
Both Dataset and Dataflows have a History tab at the top when you are in it for properties...it should show you run times there.
Matt
*Please Like to Thank
1 -
I wrote a C# program a long time ago that exports the dataset metadata and then pushes it back into Domo. I would recomend using hte something like powershell and the APIs to do the same thing. This allows me to create a card on the inputs datasets for a given dataflow - take sales for example - and with some beast modes I check if a given dataset updated before or after the dataflow kicked off. the card is color coded for "all good" or "Houston we have a problem".
Looking through the APIs I do not find anything for Dataflows. You might have to use C#. That makes it a bit trickier ...For what it is worth, here is the section of code I use to read the data about our dataflows
Utility.LogMessage(DateTime.Now + " Creating array of dataflows to load back to Domo.");
var dflows = client.DataFlows.GetDataFlowsAsync();
DomoApi.Model.DataFlow.DataFlowCollection Dataflows = new DomoApi.Model.DataFlow.DataFlowCollection();
Dataflows = await dflows;
try
{okToUpdate = true;
foreach (var df in from DFList in Dataflows.DataFlows select DFList)
{
Console.WriteLine(df.Name);
if (df.Inputs != null)
{
foreach (var inp in from inputlist in df.Inputs select inputlist)
{
if (df.Outputs != null)
{
foreach (var outp in from outputlist in df.Outputs select outputlist)
{
List<object> dfobj = new List<object>();if (df.Name != null) dfobj.Add(df.Name.ToString()); else dfobj.Add("no name");
dfobj.Add(df.Id.ToString());
if (df.DatabaseType != null) dfobj.Add(df.DatabaseType.ToString()); else dfobj.Add("no Database type");
if (df.Description != null) dfobj.Add(df.Description.ToString()); else dfobj.Add("no Description");
dfobj.Add(df.DocumentVersion.ToString());
dfobj.Add(df.Enabled.ToString());dfobj.Add(df.LastExecution.LastUpdatedTimeUtc.ToString("o"));
dfobj.Add(df.LastExecution.BeginTimeUtc.ToString("o"));
dfobj.Add(df.LastExecution.EndTimeUtc.ToString("o"));dfobj.Add(df.ResponsibleUserId.ToString());
if (inp.DataSetName != null) dfobj.Add(inp.DataSetName.ToString()); else dfobj.Add("no input dataset name");
if (inp.DataSetId != null) dfobj.Add(inp.DataSetId.ToString()); else dfobj.Add("no Input Dataset Id");
if (inp.ExecuteFlowWhenUpdated != null) dfobj.Add(inp.ExecuteFlowWhenUpdated.ToString()); else dfobj.Add("no dataflow trigger indicator");if (outp.DataSetName != null) dfobj.Add(outp.DataSetName.ToString()); else dfobj.Add("no Output Dataset Name");
if (outp.DataSetId != null) dfobj.Add(outp.DataSetId.ToString()); else dfobj.Add("no Output Dataset Id");
if (outp.DataFlowId != null) dfobj.Add(outp.DataFlowId.ToString()); else dfobj.Add("no Output Dataflow Id");
dfobjects.Add(dfobj);
dfobj = null;
}}
}
}} // end of dataflow loop
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive