List of Contributions

John Taylor

Contact Details

My Content

1 to 20 of 50+ total

RE: Use Bulk Uploader to delete records

Posted By John Taylor 04-06-2023 09:11
Found In Egroup: Data360 Govern \ view thread
Hi Jim, Hope you are well, long time no speak! The unrelation bulk loader will allow you to upload a list of relationship IDs (the specific relationship between 2 assets) and remove them from Govern. This can be used if you have a long list of related things that are no longer related in the ...

RE: Look for zip code less than 5 digits

Posted By John Taylor 05-20-2022 00:45
Found In Egroup: Data360 Analyze \ view thread
Hi Mike, The transform node could gives you any number of ways to do this with some fairly simple Python. For an even easier solution we can use the Filter node's "Advanced" feature to add the python function of LEN() to count the length of the test and filter record in or out. simply ...

RE: Transform Node

Posted By John Taylor 05-09-2022 01:37
Found In Egroup: Data360 Analyze \ view thread
It really depends on how complex it needs to be but Python actually supports filtering inline for DIGITS configure out1.ints = str Process out1 += in1 str1 = fields.data out1.ints = int(filter(str.isdigit, str1)) INPUT re456ty 45jk5k5l 34e34e eerrtt44 ...

RE: Display Relationship metadata on Lineage Diagram joins

Posted By John Taylor 05-09-2022 01:24
Found In Egroup: Data360 Govern \ view thread
Hi JP, I remember your ticket. We actually stopped using the meta-data on the relationships as much as we had planned due to this functionality not being there. I'm hoping that the update to the relationship tab will prompt others (like ourselves) to re-visit capturing the data on the join ...

Display Relationship metadata on Lineage Diagram joins

Posted By John Taylor 05-09-2022 00:22
Found In Egroup: Data360 Govern \ view thread
Hi, For a very long time in Govern you have been able to capture information about a relationship on the relationship itself. This has been a feature we have been using for some time. Since the improvements to the relationship tab you can now see this information much more clearly, even if ...

RE: Put AssetPath available as Display and Edit Format in a list configuration

Posted By John Taylor 04-29-2022 01:29
Found In Egroup: Data360 Govern \ view thread
So coming in a release that is expect very soon. Possibly next Friday to DEV (perhaps the week after) is this functionality: So you add a new field and select the type of "Asset Path", but instead of bring back the full path separated by ">", you will be able to select to "List Single Segment" ...

RE: Put AssetPath available as Display and Edit Format in a list configuration

Posted By John Taylor 04-29-2022 01:17
Found In Egroup: Data360 Govern \ view thread
Hi 430680398854 , Is your requirement to be able to break down the asset path into its various elements / hierarchy levels / components, isolate each one and make each one listable so that if a user is looking at table columns that are called "ID", they are able to see the 'Table', 'Schema', 'Database' ...

RE: Ability to "@" a user in comments on an asset

Posted By John Taylor 04-29-2022 01:04
Found In Egroup: Data360 Govern \ view thread
Ahh - I wondered if that was the root of the question. I do think users expect to be able to inline tag other users these days, so I certainly support the request from being able to '@' a user directly in the comment box. We've done some training on the comment tab as we use it ALOT throughout ...

RE: Ability to "@" a user in comments on an asset

Posted By John Taylor 04-28-2022 04:14
Found In Egroup: Data360 Govern \ view thread
Hi Mike & Matt, You can do this today. Simply add a comment on the comments tab and in the Tag box below the comment you add the user. You don't have to use the @ symbol and if you do you might get some weird results. The user will then get an email to let them know a comment has been made ...

Followers API or Bulk Load

Posted By John Taylor 04-06-2022 03:10
Found In Egroup: Data360 Govern \ view thread
Hi, We have recently had a use case put forward where using "Followers" as a way to list distant stakeholders for use in notifications seems like a solid approach. This people would not want to be list on the responsibilities tab as they have o direct owners of the asset, but may be impacted if ...

Trigger Analyze workflows from Govern

Posted By John Taylor 04-06-2022 02:52
Found In Egroup: Data360 Analyze \ view thread
Hi Team, I have raised this one before but given my recent reading the Analyze CLI, I thought I would ask it again. Could it in future be possible to trigger an Analyze workflow from an action or workflow from within Govern. For example an asset having its status updated would start a ...

RE: Export Information from Responsibility Tab

Posted By John Taylor 04-05-2022 00:50
Found In Egroup: Data360 Govern \ view thread
Have you tried to use the Responsibilities Endpoint: https://[enviroment].data3sixty.com/api/v2/responsibilities/assignments?_assetUid=[UID OF METRIC] This would quite happily give you all the responsibilities for any Asset, including metrics You get the name of the responsibility, the ...

RE: Bulk loading Tags

Posted By John Taylor 04-05-2022 00:38
Found In Egroup: Data360 Govern \ view thread
365242248007 - Have you considered using Analyze and the API in general to do this? There is no batch endpoint but Analyze could pass single payloads into a POST in a loop, either from pasted data in a "Create Data" node or from a file uploaded. Literally 2 minute build work: [Create ...

RE: schedule same data flow in parallel with different runtime properties

Posted By John Taylor 02-23-2022 10:20
Found In Egroup: Data360 Analyze \ view thread
I'm not sure if you can reference them in the scheduler. Why have you got to do it without the Execute Dataflow node? Can't you just do the very basics in there to get a UUID directory path and call the same dataflow with one variable. and run the your scheduled run against that flow rather than the ...

RE: schedule same data flow in parallel with different runtime properties

Posted By John Taylor 02-23-2022 10:05
Found In Egroup: Data360 Analyze \ view thread
Maybe combined the execute data flow with some very basic python like: import uuid out1.xxx = str(uuid.uuid4()) and xxx will be a random UUID (aka GUID) character string, which can be merged into a directory path using another line of python and passed to the data flow using the execute data ...

RE: schedule same data flow in parallel with different runtime properties

Posted By John Taylor 02-23-2022 09:18
Found In Egroup: Data360 Analyze \ view thread
Hi Scott, Have you explored the "Execute DataFlow" node and considered passing the variables and an ID into the flows from there. You could use a BRD file to count each run as a basic counter and then use that as a way to ID which flow is which. The execute Dataflow node also provides a really ...

Ability to control of Export by Group/user and by asset type

Posted By John Taylor 01-20-2022 09:05
Found In Egroup: Data360 Govern \ view thread
I have a request from the business to implement a greater level of control around who in the business is able to export metadata from Data360. Currently all users can export any asset, regardless of the user type or the asset type. The only limit is the number of rows they can export. The requirement ...

RE: JSON node - how do i use it

Posted By John Taylor 01-20-2022 02:53
Found In Egroup: Data360 Analyze \ view thread
So grab the JSON using the HTTP node in analyze and then connect the output/response to the JSON node. Set the Field setting to accept "Data from Field" and use the Hamburger menu to Select the response field. You don't have to define the schema, the JSON node takes care of in and output a table ...

RE: Flatten Hierarchy when shoing a child asset

Posted By John Taylor 11-24-2021 07:37
Found In Egroup: Data360 Govern \ view thread
Making Relation lookup fields 'listable' would be a massive improvement If we can't have calculated fields like in SFDC, then building what we want in distinct fields using relation lookup and then make those columns 'listable' (and maybe even hidden from the detail page) would be solid solution ...

RE: Concatenate / Merge multiple Datasets based on dynamic number of inputs

Posted By John Taylor 11-19-2021 03:08
Found In Egroup: Data360 Analyze \ view thread
Morning Adrian, Just a follow up note on this one. Turns out it was more to do with the JSON node not outputting a value for the cat node to consume rather than the cat node doing anything odd. Tweaking the JSON node that is connected to the HTTP response to ignore errors then allowed ...