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
-
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
- 7.7K All Categories
- Connect
- 918 Connectors
- 242 Workbench
- 476 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 446 Datasets
- 35 Visualize
- 198 Beast Mode
- 2K Charting
- 8 Variables
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- Workflows
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 15 Manage
- 36 Governance & Security
- 23 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 15 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部