Since the Ignition Exchange’s introduction in 2019, members of the Ignition community have contributed hundreds of resources ranging from pre-built templates, tools, and scripts to Ignition-powered retro arcade games — all available for free. Discover the full potential of the Ignition Exchange as we highlight some of its most valuable assets, including a handpicked sampling of the top Exchange resources developed by IA engineers. 

Transcript:

00:10
Mara Pillott: Hi, everyone. Welcome to the "Ignition Exchange Resource Showcase." We are Dereck and Mara, and we are the Application Engineering Managers at Inductive Automation. In application engineering, we implement Ignition projects for internal customers, for product demonstrations, and the Ignition Exchange. We also present webinars and presentations and consult with our customers on proof of concepts, best practices, and project planning for successful Ignition projects. Dereck, tell us a little about yourself.

00:40
Dereck Saunders: Thanks, Mara. Hello, everyone. I'm Dereck Saunders. As Mara said, I'm an Application Engineering Manager at Inductive Automation. Previously as an application engineer, I've worked on a variety of Ignition projects for oil and gas production, solar and winds, automotive manufacturing, water/wastewater, food and beverage production, inventory management systems, and more. Today, Mara and I lead a team of application engineers that help develop Ignition proof of concepts. We consult with customers on Ignition design best practices. We contribute resources to the Ignition Exchange, and we help develop a variety of Ignition projects, like Inductive Automation's public demo projects.

01:17
Mara Pillott: I've been working with Ignition since 2010 and previously served as a design services engineer. I've built a variety of projects for our customers, and I've also assisted them one-on-one with learning to build their projects. Most of my experience is in custom database solutions, and I'm giving a workshop next week for using databases in Ignition. So I hope to see some of you there. Today, we're going to talk about how to use the Exchange to elevate your projects.

01:44 
Dereck Saunders: Alright. So here's our agenda for today. We will be giving an overview of the Exchange, what it is, where you can find it, and how you can use its resources to elevate your project development. Next we'll go over a series of resources developed by IA that we would like to share with you today. After this session, we hope you'll explore some of the resources showcased, as well as the many resources developed by the Ignition community. Finally, we'll wrap the session up and answer some questions. So with that, let's get started.

02:09
Mara Pillott: So what is the Exchange? To explain, let's go back to the beginning. If you were here in 2019 watching the Build-a-Thon, you will remember when our own Kent Melville gave us the Exchange. Our dev team wanted to make Ignition even more customizable, encourage more collaboration, and help you save more time. We created a new online community with free resources. Now some of these are built right here at Inductive Automation, but you know what's really exciting? You, our community, are able to share your own resources. Today we're gonna be highlighting things that were built here at IA, but I encourage you to share your own and to check out our many community contributions. So what can you find in the Exchange? Well, really just about anything you could think of. I want you to go to the Exchange and try searching on keywords, categories, types. You're gonna find everything ranging from just like a single view, some scripting resources, entire projects, and so much more. Go check it out.

03:09
Mara Pillott: So why would you use the Exchange? You can just build anything you want with Ignition, but why build everything from scratch? Using prebuilt Exchange resources is going to jumpstart your project and save time. And you can use that for those trickier parts of your project that always seem to take up the bulk of your development time. You can find prebuilt projects in the Exchange and use those as a starting point. Once you download a project, it's yours. You can add views, make any changes you like. You can also find some prebuilt components and add those to your project. Today we're gonna show some examples where we start with a fairly complete project and we're gonna add some resources to improve it. We're also gonna show you some full project resources. We're focusing on only a few resources built here at Inductive, but there's many high-quality community resources. We encourage you to check those out and build your own. You could also keep your own set of resources just so you have a consistent look and feel for all of your projects.

04:05
Dereck Saunders: Alright, so just going over the resource submission process a little bit, resources are initially private when they are first submitted to the Exchange, and they are individually reviewed by an application engineer at Inductive Automation, and they're reviewed just to make sure everything with the resource generally works as expected and that it meets the quality standards expected for the Exchange. If we do find any issues during the review process, we provide feedback directly to the developer to help them improve the resource. And then once the resource has been approved, it's made publicly available on the Exchange. So there's a couple different ways to integrate Exchange resources into your projects. You can import them manually by going through the standard import process in the designer, or you can import them from the Ignition Exchange page on the gateway web page, which you may find to be just a little bit more convenient.

04:52
Dereck Saunders: So when we start to take a look at our specific resources in our presentation, you will see that some of them are deployed in a sample project. Our application engineering team developed a general manufacturing demo depicting the assembly of solar panels using robots for adhesive application and material handling. This demo will become the Perspective demo in the future, but we've decided to use it here as the foundation and backdrop to showcase a variety of IA-developed Exchange resources. With that, let's get into it and start talking about some of the great resources developed by IA. Our first resource is the Perspective Tag Meta Property Viewer. So in this resource, it includes a view that can be used as a pop-up to view any tag's meta properties from a Perspective session. Normally opening up the Ignition designer would be required to easily view all the tag's meta properties, but this resource provides the ability to view a tag's meta properties in real time from a Perspective session.

05:42
Dereck Saunders: This view is built to work dynamically with any standard tag type, so memory, expression, query, derived, whatever it may be. This resource is also configured to work with tag drop, so you can drag any individual tag onto a view and it will give you a small tag icon, which is dynamic based on the tag type. Hovering over the tag icon will display the full tag path, and clicking the icon will open the Tag Meta Property Viewer pop-up. Opening the pop-up will allow you to browse and view the tag's meta properties and also any custom properties that the tag may have. This will also work with any tag inside of a UDT, and all property values displayed are read-only. The main header includes the tag type, in this case a Boolean, the full tag path, its current value, quality, and timestamp. Similar to the tag browser in the designer, the header also has icons in the top right corner to indicate if the tag has scripting or alarms configured on it. Any tag scripts like a value-change script can also be viewed to further assist with any potential troubleshooting, diagnostics, or anything like that right from the session.

06:47 
Dereck Saunders: Alright. Next we have the Perspective Toast Notifications developed by Application Engineer Conner Futa. This resource provides the ability to create toast notifications in your projects. These toast notifications are commonly used in mobile-specific projects for tablets and phones, but these can also be deployed in a standard desktop Ignition application if you wanted to. These appear as small pop-ups with text, and they can be configured to be click-dismissable, autodismiss after a certain amount of time, and slide in from different directions. This resource does include a small demo to help get started to see some of the options for configuring toast in your project. You can simply enter the text you want to appear in the toast message, set a number of seconds for the message timeout, and click "send toast" to see it in action. There's also additional configuration that you can set within the demo to customize the toast. You can see different locations like top left, bottom right, center, set the animation style like center right, or enter top, and the message type as well.

07:44 
Dereck Saunders: Give these various options a try to see what works best for you, and then you can use the main views and scripting to build your own custom toast notifications in your project.

07:53
Mara Pillott: Thanks, Dereck. I'm going to gonna have some toast with my next project. Our next resource is Comments by Application Engineer Mitchell McPartland. The Comments resource can be used to power a blog-style system within your project. This can be useful for some ad hoc collaboration and communication between shifts or remote users. We see in this screenshot, people are discussing a fault. These notes are gonna be saved. We can look back at this later and see if this maybe happened before and who knows how to fix it. Now, you're probably going to have specific loggers in place to capture information, but this is something you can do really quickly and just give you a free-form method of communication. So resources are generally gonna include some README, maybe a guide or install notes. This page is going to tell us about the supported databases, the main view parameters, and if we want to know more about the resource, we've got a PDF document in the download folder. Now the first thing to note is we're gonna need a database connection, and we've got two parameters to set on a view. So we know we've got a database connection or gateway, we're going to hop in the designer.

08:57 
Mara Pillott: So this view is in the Comments folder under the Exchange folder. You will see some resources with different folder usages, but we really encourage you to put everything in a folder named "Exchange." This is gonna keep things separated from your other project resources and avoid any duplicated names. So any parameters I have here, I can set at runtime, but just to get started, I'm setting this database connection and schema parameters, and I'm gonna save the view. And those are the two properties I have highlighted in yellow. Once I've set the properties, I can click Create Database Tables, and that's gonna go ahead and create all the database tables I need, no setup in the database for me. So there's a few more parameters here. I'm just leaving date format default. Date range can be used for filtering. Instance name is gonna separate out your comments into different groups, and we're gonna see this in a minute. And you can change the default title to anything you like.

09:51
Mara Pillott: So I've got my pop-up all configured, and I need a way to open it. I want to have a set of comments for each robot. I'm gonna open the robot pop-up view in the designer. I added a button with a comment icon, and I'm gonna add a pop-up action. I just picked my comments view, and the only parameter I need to pass is the instance name, which I'm just binding to my robot name. So let's see it in action. The blog icon opens the comment's pop-up. They're organized by the instance name we set, so this is only showing comments that are related to this particular robot, and we can view all previous comments and add our own. So I'm the Robotech user. I want to let everybody know that I've got this robot calibrated. I'll just add that comment, and we can see it there. They've got some additional features. You can pin them, just like on a traditional forum. You can save your favorite comments. Users can edit or remove their own comments, but they can't remove anybody else's comments. And you can search these guys. You can filter them by date range. Maybe I wanna know when diagnostics were last run. I can just type that in the dialog box, and I can see if I've got any results related to diagnostics. There I go.

11:11
Dereck Saunders: Alright. Thanks, Mara. The next resource we're gonna take a look at is the CSS Animation Guide: A Robot Example developed by Application Engineer Mike Bordyukov. So this resource provides a detailed guide on how to perform basic animations in the Ignition Perspective Module using CSS. This guide covers how to create smooth motion, pause and resume animations, and synchronize two robots using a state machine. This project starts with basic animations and then demonstrates how to create more complex movements. The intermediate example shows how to combine multiple rotating elements to create an animated robot. You can adjust angles and duration to see how property adjustments affect the animations. You can also view the designer properties to better understand how to achieve and implement and adjust your own animations. The advanced example shows how multiple animations can be synced together, for example, a robot placing an object onto a moving conveyor, or in this case, two material-handling robots passing an object. These particular animations are controlled by a UDT with a state machine, allowing for animation pausing to accurately depict the actual robot or equipment movements and position.

12:16 
Dereck Saunders: The UDT tab of this resource includes more details on how the state machine is being controlled behind the scenes. Alright, so now let's take a look at the Simple Perspective SVG Editor developed by Application Engineer Charles Ahrens. So this resource is meant to allow users to edit SVG drawings that have been generated or modified within the Ignition designer as well as save those SVGs out as drawings out of the designer. You can add or edit circles, rectangles, paths, and text, and you can adjust the properties and color of each shape's fill and stroke or apply transforms to those shapes. You can edit drawings in either the designer or web browser and export those drawings to your computer as an SVG file. Alright, let's take a look at the SVG editor in action. Here we can see how to draw some simple shapes and maybe add some text to an SVG drawing. These shapes obviously aren't being used together to show a more complex drawing or depict equipment, but it should instead give you an idea of what the range of possibilities are with this awesome drawing tool in Perspective.

13:19 
Dereck Saunders: Next, let's take a look at a more practical example where we're editing an existing valve SVG. So here we can see how we can go in and manipulate and edit the valve to our liking, and then when we're happy with how it looks, we can download to use it elsewhere and clear the canvas for our next drawing. I'm honestly a fan of all the resources that we're showcasing here today, but I think this resource in particular really underscores the impact and importance of the Ignition Exchange and all the possibilities that it can unlock, thanks to the contributions of our Ignition community as well as our application engineers here at IA. Okay, so we just looked at how to draw and create SVGs in Perspective, but what if you want to take it a step further and animate them? So next we have the Perspective SVG Animation Resource, which was also developed by Application Engineer Charles Ahrens. This is a teaching/learning resource similar to the CSS animation guide that we looked at earlier, except this deals with SVG animations.

14:14 
Dereck Saunders: This resource has a few examples of SVGs being manipulated by elements within Ignition to create dynamic objects. Following these examples, a user could create an SVG representation of complex equipment in their facility and animate it dynamically to give users of that display a better idea of what is happening behind the actual process. Starting simply, the basic example shows how to move a circle around the screen controlled by two simple sliders for the X and Y coordinates, as well as a slider for changing the radius and color of the circle. Again, a very basic example just to start things off. The intermediate example uses some more complex expression bindings to draw a line connected between the center of the canvas and the center of the circle, which follows the circle wherever it goes. Additionally, this view has the ability to have automatic movement and the circle will rotate around the center point following a path that can be changed while running with the sliders.

15:05
Dereck Saunders: This automatic movement can be toggled with the manual and auto buttons. The advanced example uses lessons of movement and rotation and combines them into a robot arm, which has four positions that can be saved automatically and moved between them with a smooth motion. If you're looking to learn how to animate SVGs in your Ignition project, whether it's something very simple or even more complex, go check out this resource on how to get started.

15:29 
Mara Pillott: Wow, those are some amazing graphic tools we could use in almost any project. Our next few projects are simple but very powerful. First is the Copy to Clipboard by Application Engineer Conner Futa. This allows us to copy any text on the screen into our clipboard. In this case, let's say I sometimes just need to copy a serial number for robots so I can look up documentation or send emails to a vendor. If you wanted to look something up and they said, "What's your serial number?" and you had to go find it, you know how annoying that is. I added an embedded view to the robot view. I set my path to a link to the Copy to Clipboard resource in the Exchange folder. I've got one parameter named "toCopy" and I'm going to bind that to my serial number. So let's see it. I just click the copy icon next to the serial number. The icon turns green, so we know we've got the text in our clipboard, and we can paste it anywhere we like. I'm just going to go ahead and paste this into my email where I'm requesting some service.

15:38 
Mara Pillott: Next we have our JSON Viewer by Matt Raybourn. This resource exists just to make JSON human readable. Our imaginary robot manufacturer provided us some diagnostics as a JSON string. It's pretty long, it's not human readable, and it's not very useful in this format. In our JSON viewer, it's much better. It's human friendly, it's color coded, it's nicely formatted. We can find what we need here. We can pair this with Copy to Clipboard, and we can paste this in an email or a report or anywhere we want. We're going to stay on the subject of powerful user interfaces as I turn this back over to Dereck.

17:05
Dereck Saunders: Thanks, Mara. Our next resource is the Pan Zoom Frame developed by Application Engineer Mike Bordyukov. So this resource enables the manipulation of images or other views using CSS transformations. It offers two distinct views: a generic view that allows panning and zooming of any embedded view, and a specialized view for image components that provides more options for customization. As the name suggests, with this resource, you can pan over images or SVGs to provide a more interactive viewing experience. In this particular case, we can see how this resource is used to pan over an Ignition architecture diagram, but this could be any image, SVG, or even just another embedded view in Perspective. Even though this is just an architecture diagram, you can see how this could be especially useful for panning and zooming over detailed schematics and line drawings. While the pan zoom capabilities of this resource are awesome, this resource takes things a step further, allowing you to leverage dynamic displays that are driven by zoom level. By that, I mean we can design an embedded view to react to the zoom level of the pan zoom frame, which allows us to display certain components and details when zooming in, but then hide them when zooming out.

18:12
Dereck Saunders: Maybe we have a lot of tanks or other type of equipment on an overview screen, and we want the overview to stay relatively simple, but we still want to be able to drill down and get more details like tank level or tank contents without navigating away from the overview to a different screen or open a pop-up or dock view. This dynamic display driven by zoom level allows us to accomplish that all within the pan zoom frame, and this design approach certainly won't work for every project, and there will definitely be cases where it still makes sense to use a classic pop-up to drill down, but I think this resource offers a different and intriguing design approach that could be really useful in certain scenarios. Switching gears a little bit, let's talk about IEC 61850 and in particular the IEC 61850 Scripting Demo developed by Training Content Creator Rob Lapkass and Lead Quality Assurance Engineer Garth Gross. If you're unfamiliar with IEC 61850, I'm not going to go into all the details here, but we do have some great resources and articles on our website and in the Ignition docs to help break it all down. Essentially it enables device interoperability and data standardization in electrical power systems and provides a better way for IEC-compliant field devices to read and write data.

19:23 
Dereck Saunders: We recently released our IEC 61850 Driver for Ignition, and with that came some new scripting functions to help explain those new functions. And to help explain those new functions, we have an Inductive University video called "Using IEC 61850 Scripting Functions," and this resource is a copy of the view shown in that video. While most of the features will not work without a valid device connection, you can still download the resource and take a closer look at how the scripts work and potentially connect an IEC 61850 simulator device as well. Staying the topic of IEC 61850, let's take a look at Sales Engineer Tom Goetz' IEC 61850 Graphics resource. The goal of the Ignition Exchange resource here is to provide basic graphics and configurations to components related to the IEC 61850 Driver. The configuration allows for users to change color, text, visibility, rotation, and state of switches and breakers.

20:17 
Dereck Saunders: The configuration works both in the designer as well as in session, and if modifications are allowed in session, a SQL database can be configured to store and retain changes made in the session. You can arrange and use any of the custom components as you would any embedded view to build out a substation layout, or you can use the dashboard component in this resource for easy configuring and arranging of the graphics. Alright, next let's take a look at the Inventory Prediction Manager developed by Sales Engineer Reese Tyson. So this application is built off of a UDT and scripts that monitor levels, predicts a run-out date using linear regression, and notifies emails, notifies a list of emails before the inventory runs out. The linear regression is performed on the historical data of the inventory levels to create a prediction of the date that the inventory will run out. Once that date is established, a user-configurable lead time can be set which will determine when the notification is sent out.

21:14 
Dereck Saunders: This application is designed to take a proactive approach to making sure material is available when you need it. As you can see, the Inventory Prediction Manager is also mobile responsive. Alright, next we have the Mobile Responsive UI resource. This resource was a joint effort by Application Engineers Conner Futa, Chase Dorsey, Sales Engineer Tom Goetz, Sales Engineering Director Kent Melville, and Design Department Manager Ray Sensenbach. Mobile responsive means creating an app that is easy to navigate, visually appealing, and functionally consistent. However, there is no user manual to tell you what to include in your mobile app or what structure is best for your purposes. This resource has examples of good mobile-responsive design, all wrapped up in a semifunctional demo CMMS project. The best practices for design include intuitive navigation, reversible actions, informative feedback, smart defaults, accessibility, error design, protecting user work, visual clarity, progressive disclosure, visual style, and functional behavior.

22:15 
Dereck Saunders: So this resource is also meant to be more of a teaching or learning tool than an actual resource that you would deploy in your project. It showcases a lot of great design techniques that I just mentioned and could also help inspire your next design or take your current mobile project to the next level with excellent UI that feels intuitive and is easy to use. If you're looking for an example of some stunning visuals and best practices in UI/UX, definitely go check out this fantastic resource.

22:42 
Mara Pillott: Well, speaking of user interfaces, our next resource is the Perspective Alert Dialogs, again by Ray Sensenbach. If you're like me and you came from the Vision world, you may have noticed that we can't use things like system.gooey.confirm or message box in Perspective. Perspective is HTML-based, so if we want those dialogs, we have to create some pop-up views. We could create them ourselves or we can use these nice themable dialogs that Ray already built for us. Like a lot of resources, it comes with an information view that's going to help you get started. The dialogs are totally customizable. You can select a theme to match your project. You can warn against an action, let users know if an action was successful, alert them to an error, or just give them some information. The alert pop-up is a single view with several parameters. They're going to set everything, icons, button text, message text, all your actions. Best of all, they're extensible. They come with some built-in functions, and you can add anything you like. Let's hop in the designer.

23:41 
Mara Pillott: So we can see we have several parameters for text, icons, and actions. We can set the action for each button. We can set any of these icons, alignment, remove icons, and we can change the state based on the states we saw in the previous slide. Each button has a set of message handlers. We can see here we've got two handlers, one for closing the pop-up and one that will log us out of our session. You're not limited to what you see here. Like I said, you can add any of your own custom message handlers. I have an icon over here that I can click to log out of my project, but I want to let users confirm before they close that project. I added an event handler. It's got a pop-up action. I set my parameters. I want my log-out action for the primary button, and for my secondary button, I just want to close the pop-up. I set some yes and no text, and it's not visible here, but I set a title and a message. So let's see it in action. I click the log-out icon and realize I don't want to log out. I can just click no, and the close pop-up action executes.

24:48
Dereck Saunders: Alright. Thanks, Mara. Now let's check out the System Monitor resource developed by Application Engineer Tyler Earnest. So this project is a basic system monitor for CPU and memory utilization of the gateway PC beyond that being used by Ignition itself. This is accessed using the Java ManagementFactory library. Two Perspective views are provided. One is a mobile view showing real-time details, and the other is a desktop view showing historical details over the last five minutes using tag history. An included system monitor UDT can be imported that includes CPU, total memory, available memory, and calculated in-use memory. So here's a better look of the desktop view showing those historical details for the CPU and memory usage. Obviously, you can customize this, alarm on the UDT tags for high CPU and memory usage or embed this elsewhere as part of a larger in-session diagnostics bundle. While it's common for Ignition to have its own dedicated server, there are definitely instances where Ignition is installed alongside a database or other software where knowing the overall machine CPU and memory usage and potentially alarming on it might be quite useful.

25:54
Dereck Saunders: Alright. Next, we have the GeoJSON Explorer developed by Application Engineer Mitchell McPartland. This Perspective project can be used to display GeoJSON data in the Map Component. For demonstration purposes, this resource retrieves datasets from data.gov that can be modified, and it can be modified such that it retrieves datasets from other sources as well, and there are examples included in this resource. You can browse a selection of datasets that the developer included and see a lot of different ways to visualize GeoJSON data. As cool as all the examples are, you will really unlock the full potential of this resource by leveraging your own GeoJSON data. There's a good amount of options you can choose from to display the GeoJSON data differently, including the base map type, the overlay, and the theme. We just talked a few minutes ago about UI/UX best practices with the mobile-responsive UI resource, but I think this resource also really showcases some really clean and intuitive UI.

26:49 
Dereck Saunders: And as you can see, this resource is also fully mobile-responsive and can be run on a phone or tablet right out of the box. And lastly, before I turn it back over to Mara, let's check out the Perspective Electronic Signature Framework resource developed by Chief Technology Evangelist Travis Cox. This resource shows how to leverage the new authentication challenge feature in Perspective to perform electronic signatures with full auditing. This resource provides a framework and example that you can use in your project. This resource is designed to be extended to any kind of action you want to perform. The example provided shows how to perform tag writes with a two-stage verification process. And this resource was made possible through the collaboration with 4IR, an Inductive Automation Solution Partner. 4IR Solutions provides an easy way to deploy Ignition and its partner ecosystem into the cloud via a fully managed solution. They have deep expertise in 21 CFR 11. So yeah, this is a really neat resource that Travis put together with 4IR and provides some awesome new functionality with this electronic signature framework.

27:53 
Mara Pillott: Alright, we've seen some pretty cool resources today, but I have one here that's going to help you with just about any project that you have. I talked about themes a little when I introduced dialogues. Ignition comes with built-in themes, but like anything, you're not limited to just what is built in. You can build your own themes using the built-in themes as a base. Now, these themes are built using cascading style sheets, but you can modify these with your favorite text editor, and if you want a more visual tool for building themes, check out this Theme Builder by Sales Engineer Tom Goetz. Let's take a minute and just talk about themes in Perspective. This was a little new to me coming from the Vision world. So like I said, it comes with built-in themes, and this is going to provide an initial style to your components. Now, we're going to focus on color today, but the themes allow you to change all the styling. For example, you can change scrollbar width or the default borders. The themes are built on cascading style sheets or CSS, like I said. These advanced users, you're going to just you're going to learn this very quickly on your own, but this resource is going to help you build a set of colors visually.

29:01 
Mara Pillott: So how does this look in a Perspective project? We saw an example of this in the dialogs project. There's a built-in session property for theme. Changing this theme is going to change the default colors of your components. Here we can see that choosing between the themes changes our background and text colors. I don't have any colors or styles set for these components. These are just default colors, and they're based on the theme. They range between light and dark, and you've got some cool and warm selections as well. Now, you can set custom colors for your components, or you can use the themes to just give yourself a set of color variables. In this example, I want purple buttons, but I still want all my buttons to work with the theme. I chose sequential 4 for my button background color. It only applies to this button, and it's going to follow my theme selection. So using light, I'm going to get a dark purple button with white text, and if I switch over to dark, I'm going to get a lighter background and darker text.

30:01
Mara Pillott: You can also use theme colors in your style classes. So in the previous example, I was just working with the color selection for a single component, but using styles, I could apply these selections to multiple components and give my users a consistent look and feel. So that gives you a few basics on themes, so let's see how we can use this theme builder to create a new theme. So the main view shows you all the colors in your selected theme. You can start with any existing theme as a base or import a theme. Here, I'm selecting light and dark, and we can see that my color sets are changing with my selection. Configuration is on the left, and the theme colors are displayed on the right. This just gives me a chance to preview. So I'm going to start with the dark theme, and I'm going to start changing some colors. Notice that the colors are grouped. In this example, I want to change my neutral colors. I want lots more blue, and I'm just going to slide that blue selection all the way over. As I change this, you notice that the preview colors change. The original colors are in one column, and my updates are in the far right.

31:08 
Mara Pillott: So this gives me some idea of where I'm going, but I don't really know how this is going to look on a screen. Well, I got a preview mode, and I can test drive my theme. Now I've got a really blue background, and you can see my neutral colors range from blue to yellow, and this really hurts my eyes, and I've gone way too far. But I got a reset button. I can reset everything using the bottom reset button, or I can just reset to a neutral group. Now maybe I just want to make a few changes. So I would just like call to action to be a nice Ignition orange. I can expand the individual color config, enter in my hex color, and apply that to call to action. So check it out. I get a nice orange color listed in the preview pane. I can come over here to see how it would look on my screen. I've got standard light theme for everything except call to action, and just a few other selections like my checkbox and slider are now the orange color that I'd like. I can keep making changes, and I can just see what they look like right here on screen.

32:11 
Mara Pillott: I'm going to apply my ICC 2023 color to the diverging colors and to the info color. I expanded the diverging color selection, entered in the hex color, and I applied that to the starting color property. All the diverging colors changed. Next, I expanded the individual color config and set that same hex color for my info. Once I'm happy with my theme, I'm going to want to use it in all my projects. So it's time to build my variable CSS file. I'm just going to click my build button, choose a starting theme, give it a name, and I can download this as a zip. So I've downloaded it. What do I do with it? Well, like a lot of the resources we have here, we've got a README file in the download, and I just had to copy my CSS file in my theme folder into the Ignition program files. So once I've got the theme in the Ignition install directory, I can use it. I can just go to my session property for theme, check out my dropdown selections. My new ICC 2023 theme is here. I can select this and notice that my button color is changing from that default blue to my new custom orange.

33:25 
Dereck Saunders: Nice. Alright. Thanks, Mara. So those are all the resources that we had to share here today. We do want to let you guys know that there are going to be some great new features coming to the Exchange soon. We do plan to add resource ratings, which should be great, and even more search capabilities. So stay tuned for that. And we look forward to bringing even more improvements to the Exchange in the future. Also, every single year we host the Ignition Exchange Challenge now. So all resources entered to about a month up before ICC are eligible for the challenge. And the winners will be announced at the live Build-a-Thon after this session, so you'll be learning their names soon. And we look forward to this year's announcement and seeing all of your new resources in the coming year. Lastly, while we wanted to showcase resources today that were developed by our application engineering team and others here at IA, we still want to say a big thank you to the entire Ignition community that contributes to the Exchange.

34:17 
Dereck Saunders: There have been a lot of incredible resources that have been built just in the last year by the Ignition community, and we invite you to go visit the Exchange now or later and check out all of the resources that are available. You might find something really useful that you've been waiting for but you didn't think existed. You might find something that you can leverage and build on to accomplish your project goals. You might find a helpful learning resource that helps you take the next step, or you might find something that inspires you to go create that next amazing feature or project. And if you build something that you think is useful, fun, or just plain cool, please upload it to the Ignition Exchange and share your creations with the Ignition community. Inductive Automation's motto has long been: Dream It, Do It. And I think that motto is personified, and to borrow a term that you may have heard once or twice this week, elevated by the Ignition Exchange and its contributors.

35:04 
Mara Pillott: So once again, we just really want to thank all of our contributors from Inductive Automation and all of you for what you've done in the Exchange. We've seen some amazing resources today. I just cannot wait to see what you, the Ignition community, are going to develop next. You never fail to surprise me. With that, we're going to conclude our presentation and answer any questions you might have.

35:36 
Audience Member 1: So the question was, if we're going to contribute to this, and we're working for a company, what is it that they have to agree to? What are the legal kind of, what's the paperwork?

35:47
Mara Pillott: Sure. Everything that you download from the Exchange is freely available and free to use in your, in anybody's projects. And it can be changed or modified at will.

35:57 
Audience Member 2: If he contributes.

35:58 
Mara Pillott: Sure. Sure. So if you want to ask something of your users, that's really, you know, that they give you credit or anything else, that's really not part of the Exchange. It's a freely available resource.

36:12 
Audience Member 1: So basically, the, whoever we work for needs to be okay with, basically.

36:16 
Mara Pillott: Oh, absolutely. Sure.

36:17 
Audience Member 1: Yeah, yeah, yeah. So what is the, is there like a legal, is there like a form you have to sign to sign away the...

36:24 
Dereck Saunders: There's an agreement that you sign when you set up an account for the Exchange, but that's essentially it.

36:29 
Audience Member 1: Okay. Thank you.

36:33 
Audience Member 3: I was wondering if there's talk about adding more videos to how to use these tools like you had today.

36:40 
Dereck Saunders: Yes, great question. And that is something that we are planning on doing. Right now, you know, if you uploaded a resource, you could potentially include a link to YouTube or whatever it may be for that resource. But our team is planning in the future to provide videos for every resource that's uploaded by IA. So in the future, the idea is to have a video companion with every resource that we make.

37:03 
Audience Member 4: So how do you decide which applications make it into the main installer? Or what should live in the Exchange?

37:13 
Dereck Saunders: Sorry, you're asking what our approval process is? Or just somebody who's just using the Exchange?

37:17 
Audience Member 4: Oh, what made you put it on the Exchange instead of just putting in the main program? Since it's being developed by the same company?

37:25 
Dereck Saunders: Oh, like why isn't in the platform that you would download with Ignition?

37:27 
Audience Member 4: Yeah.

37:28 
Dereck Saunders: Yeah. So you know, our dev team has a lot of things that they want to add to Ignition and a lot of things they need to maintain. With the Exchange, we have the flexibility to have developers build things that they think are useful. Maybe a while ago, it might be something that we might have built for one or two customers. Now we have the ability to build something that might be more generic and share it with a lot of different people. So it just gives us that flexibility, where we can build something that maybe dev would like to do. And maybe we'll come to Perspective or Ignition or whatever it may be someday. But you can essentially build something and upload it in a few weeks and have it be available for people to use.

38:01 
Mara Pillott: And it allows people outside of Inductive Automation to also contribute to this community, collaboration is very important here at Inductive. And even though you're giving your resource away, you're really publicly showing people what your developers can do. And I think there's some... There's some contributors that are pretty famous, really in the community for what they've built here on the Exchange.

38:23
Dereck Saunders: Yep.

38:25 
Audience Member 5: Are there any constraints on the sort of things we can put up on the Exchange, such as like injecting JavaScript into views and then with that, when it comes along to 8.3, are you doing regression testing on Exchange resources?

38:42 
Dereck Saunders: So I'm not sure on the JavaScript question. I'd have to check on that. We do do a full review of the resource. So anything that gets uploaded before it goes public for anyone to download, we do do a full review of the resource. And then for 8.3 in terms of regression testing, that is something that we probably will have to look at. But I don't know that we'll be going through and doing every single Exchange resource, probably the ones that IA has developed. But that'll probably be something that will be the responsibility of the person who uploaded the individual resource.

39:09 
Mara Pillott: And our developers are committed to making sure that you don't have regression problems with 8.3.

39:17 
Audience Member 5: And aside from JavaScript, are there any other absolute no-no's in terms of if I'm going to put a resource up there that you just say you shouldn't be doing that sort of thing?

39:27 
Dereck Saunders: I don't think so. If it's something that you can build in Ignition and it's part of your project, you can essentially upload it. Again, we do review the resource for anything that could potentially be malicious or anything like that. But yeah, if it's something that you can build in Ignition, you're pretty much free to upload it.

39:42 
Mara Pillott: There are certain types of function calls that we are specifically looking for in the review process that we might not allow. So if we had questions about anything you had built, or even if you have questions before you build it, go ahead and talk to us because we might be able to have a conversation with our reviewers about that.

40:01 
Audience Member 6: Just a suggestion of either a feature request, like someone could request a resource and people could look at making that or having a challenge or something to create a certain kind of resource for future stuff.

40:17 
Dereck Saunders: Yeah, you can go to the Ideas section of the Inductive Automation website and there is an Exchange section there where you can put in requests or just ideas or just see the status of something that you may be interested in. Yep.

40:29
Mara Pillott: But I like where you're going with that.

40:31 
Dereck Saunders: Yeah, for sure.

40:31 
Dereck Saunders: Exchange specifically.

40:34
Dereck Saunders: But other than that, I think that's it. Thank you.

40:38 
Mara Pillott: Thank you. Just like us, I'm sure you're looking forward to Build-a-Thon.

Come and learn with Cirrus Link and Snowflake what your data has to say. Snowflake, Inductive Automation & Cirrus Link have partnered to provide Data Cloud Solutions. With Ignition UDTs, MQTT, and Sparkplug, discover how easy it is to leverage Snowflake’s platform to gain derived data insights immediately through native AI tooling. Learn about the impact of the recent partnership of NVIDIA and Snowflake. See how this disrupting technology, in conjunction with Ignition, will elevate and simplify your journey to data insights. 

Transcript:

00:00
Travis Cox: Let's do it. Hello, everybody. Welcome. Hope you guys had some fun here today, so far. I know the session's been pretty amazing so far, yeah? We definitely have another great session for you now. Hope you guys are excited about this one, Accelerator for Driving Edge to Cloud Business Outcomes, and we're gonna show a complete edge-to-cloud solution today using data models, and we're gonna actually bring in the Data Dash and kinda show you how all that comes into play.

00:30
TC: Got three amazing speakers, really two, besides myself. We got Arlen Nipper, who is the CTO for Cirrus Link Solutions. He's the man, the myth, the legend behind MQTT. I'm sure a lot of you know him. Excited for having him here today. We also have Pugal Janakiraman. He's the Industry Field CTO for Manufacturing for Snowflake, and he's responsible for building higher level solutions to kinda drive business outcome for manufacturing. And we're really excited about this particular session. We're gonna kick it off with Arlen. He's gonna show, we're gonna show Ignition Edge and Ignition, how we can bring that in through MQTT to the cloud, bringing that from IoT Bridge over to Snowflake. We're gonna show you that whole journey here this morning. So Arlen, without further ado.

01:16
Arlen Nipper: Thank you. Thanks, guys. Thanks, everybody. Everybody enjoying it? This has been awesome so far. So real quick, Cirrus Link Solution, we've been around... This is our 11th year now. We've been growing year on year. This has been a fantastic journey for us. And we started eight years ago. I was over in stage two. And I did the first ever MQTT engine demo. That was our first Ignition module. From there, we've developed a whole line of Ignition modules, as well as products that we support, including the Chariot standalone MQTT broker, and all of the IoT Bridge products that we've developed for getting data out of Ignition into the cloud. So where I'd like to start is largely due to the community and all of the feedback and the involvement of all of you.

02:13
AN: We started with MQTT and the first demo that we did was just Arlen and one of the engineers I worked with. And we had a little binary way that we published MQTT. It was great. As we started going to conferences and all of that, everybody goes, oh, we do MQTT, and we do MQTT, and we do MQTT. But if we would've plugged it all together, nothing would've worked, because the topic namespace would've been different, the payload would've been different. So we started on a journey for our own sanity five years ago. We said, mm, let's invent a spec. And since we have Engine and we're running on Ignition, let's call it Sparkplug. And so we started the Sparkplug specification. And again, it was internal. People started looking at it, Ignition users. I still remember Chevron going, "Well, Arlen, who owns that?" And we said, "Well, it's up on our public GitHub site. You can download it, it's open source." "No, really, who owns it?"

03:12
AN: So at that point, we kinda went on this journey of taking the Sparkplug spec to the Eclipse Software Foundation, which is a standards body and we worked for three, almost four years, in getting the spec cleaned up and getting it ratified. And at the end of last year, Sparkplug 3.0 was officially released. And from that, what you see up here, is that resulted in the release of a Technology Compatibility Kit. So that means that if you're doing MQTT Sparkplug, whoever wants to do it, you can download the conformance kit and you can run your client against it and get conformance-tested and get listed up onto the Eclipse website, so that we have interoperability. So when Todd Anslinger at Chevron orders your module or buys your product, he can be assured that it is Sparkplug B compliant going forward. And then other thing interesting from that is that because of Eclipse and their relationship with the IESO, IEC standards body, now Sparkplug is pending, but it'll be an international standard, IEC 2237. So now Sparkplug will be an international standard.

04:29
AN: And then the last thing I wanted to mention is that I know a lot of you, especially in manufacturing, you deal with a protocol called MTConnect. MTConnect's been around for about 15 years. There's probably over a million CNCs and Lays and Autoclaves that talk MTConnect. And the cool thing about MTConnect is they already do data models, but they do them with XML. So if you want to get the spindle speed from a current MTConnect, you do a get and it sends you back a 300K XML file that you can parse down and find the spindle speed. And what they've realized is they wanna be able to publish those MTConnect models using MQTT Sparkplug. So we are working with the MTConnect Foundation to natively have MTConnect agents running on CNC machines and Autoclaves and all this other equipment, be able to publish that information natively. And you can imagine, that means you could have a whole factory with all of this machinery. You turn it on, it publishes into Ignition, you automatically learn everything about those machines, which would be pretty cool. That's our end goal, if you will.

05:46
AN: So the other interesting thing, we hadn't even thought about it, so I had Chris run a report and say, well actually, how many people are using MQTT Sparkplug? And at this point in time, there are over 1,300 separate companies that are using MQTT Sparkplug. And six years, seven years ago, if I were to put this pie chart up, it would have been 95% oil and gas. And over the last four or five years, you can see, we've expanded pretty much across this technology, across all of the verticals that Inductive Automation is in. So the adoption for MQTT Sparkplug across all of the industry section has been huge going forward. So real quick, I just wanted to review this. What does Sparkplug do? Well, it does four important things. Number one is it gives you plug-and-play auto-discovery. So with a well-known, with Sparkplug, you know what the topic is, you go subscribe to it, it publishes a message, you get the message, and you go, oh, I know where you came from and I know what you wanna do.

06:58
AN: So, high level, gives you plug-and-play auto-discovery. Number two, very important, as we're finding out, as Colby and Carl talked this morning, this is digital transformation. And to do that, you can't have data in the data swamp, you have to have contextualized data that you can actually see from a business-level standpoint of what that data is. So with Sparkplug, we can publish a model, or the definition of that. Now, you instantiate that and create the asset, and I hate the word, but we'll call it that, you create your digital twin. Now, everybody's notion of a digital twin is different. I think ours is the best and we'll see that in the demo here in a little bit.

07:43
AN: The third thing that Sparkplug does is that we have been wrestling with registers from PLCs and our sensors and our flow computers for the last 47 years that I've been doing this. Modbus register 40002, and it's got a value of 17. 17 what? Degrees, gallons, we have no idea, so what do we do? We sat a human being in a chair, and we said, "Okay, Arlen, engineering high is this, engineering low is this, engineering units is that, and I hope I typed it all in correctly because you're gonna run your plant with all of that information that I just typed in."

08:21
AN: But with Sparkplug, we create a digital object that I can go back five years from now from this Snowflake demo that I'm gonna do, find that tag, and I can tell you the name, the value, the timestamp, the engineering high, the engineering low, the quality, and any other custom property you wanna decorate that measurement with and get it into Snowflake, we can do that now with Ignition. And then the last thing Sparkplug does is it gives us that state management. Because if I can't guarantee that I know the state of all your process variables, if you're doing command and control, or you're going to the cloud, then you're not gonna trust that, you're not gonna use Sparkplug. So, Sparkplug tells you that you are online, that value is last known good, and then if your network goes down, you're gonna know about it, all the tags will go scale in Ignition, but when it comes back up, we know at the edge, at the Ignition Edge, everything we would have published goes into a store and forward queue, and now we can do store and forward.

09:24
AN: So with Ignition on the left side, we've got that brownfield connectivity that we need to connect to all those different protocols, all those machines, and bring that into the Ignition platform. From the platform, we've got a really cool tool called UDT, and with that UDT, we can organize that data, we can give it context, we can give it engineering use, give it engineering high, we can give it asset properties because it's very important. Think of like PI Asset Framework, you've got all your asset information over here, which is different from your historical data over here, but we're gonna be able to put that together in one single database, and then we can take MQTT transmission and publish that to an MQTT infrastructure, where it can be consumed by what? Well, it can be consumed by Ignition, for sure, but we're introducing IoT Bridge for Snowflake. So those Sparkplug messages coming from Spark, from our MQTT transmission module into a server, well, IoT Bridge sits there, it's an MQTT client, it knows how to receive those messages coming in, and then using Snowpipe Streaming, we can do sub-millisecond inserts into rows into Snowflake data tables.

10:45
AN: So that means that we can take all of that contextual data we have in Ignition, and by a click of a button, get all of that natively into Snowflake, the data cloud platform. But wait, what is Snowflake, right? So I'll bring Pugal out, Pugal will tell us. Now, Pugal and I have a bit of a history. We've been working together since AWS IoT, and right before Christmas last year, Pugal called me, he said, "Hey, Arlen, I'm the manufacturing CTO for Snowflake," and I said, "Great, Pugal, that's fantastic. What's Snowflake?" And so here it is, it's incredible technology, and here's Pugal to tell you about it.

11:31
Pugal Janakiraman: Thanks, Arlen. Okay. So what is Snowflake? There is a reason why we sat together and picked Snowflake as a platform to build this out, because this is an Industry 4.0 journey. There is a whole bunch of requirements around Industry 4.0. One is that the attractive thing around Industry 4.0 and value proposition is you need very high level of compute, you need an extremely performant database out there, because this is a big data problem. You're bringing in huge volume of data, spanning IT and OT data sources into one location, whether you call it as unified namespace or a centralized location where you can facilitate IT and OT convergence, you need a high-performance database out there. So, the challenges I have seen, been in the middle of a few hundred of these Industry 4.0 initiatives, is today if customers want to go build an Industry 4.0 solution, if they pick a cloud vendor, you have to learn around 200, close to that amount of services, elemental services, stitch it together to build a solution, govern all of it, go through the whole journey of learning that and go from there.

12:45
PJ: That is hugely challenging for most of the customers we work with. So what do we do here? Snowflake is a globally connected cloud vendor agnostic data platform. So what does it mean? You don't have to go learn hundreds of services from multiple cloud vendors and build an Industry 4.0 solution. We got that covered. It's one single managed service from Snowflake. We take care of security, we take care of governance, we take care of scalability. Every one of it is taken care by us. And after that, much more cool, your API of choice is still SQL. You don't have to learn hundreds of new services. You continue to use SQL as a mechanism to leverage data which is present in Snowflake, whether it is around building dashboards or you want to build an AI and ML model or build inference around those models, you still use SQL as an API for doing that.

13:38
PJ: So this is extremely powerful, one-stop shop, easy button to adapt to the cloud. And that's what we bring to the table, Snowflake as a company. The other one, as I said, you need a highly performant database to do that. So Snowflake is a cloud-native database built 100% on cloud, and it is one of the most performant database today in the market today. Again, this is not a marketing statement. If I had to pick a number, I just brought up a number on what really is the kind of transactions which happens in Snowflake today. So April of this year, 2.9 billion queries was launched in the Snowflake data platform. And around just in one single customer, one single table, there are around 50 trillion rows out there. For us to go operate and pull up millions of rows and visualize that, it's no big deal. We do that on a daily basis.

14:33
PJ: And it's around the largest number of queries within one-minute interval a customer is executing, around 160,000. 177 petabytes of data just on five customers, what is being maintained within their database. So big data handling, we do it on a daily basis. That is our lineage. We started as a data warehousing company and built a data platform around it. So handling this volume of data is pretty much a daily affair for us. So other one around collaboration. There is a whole bunch of customer ecosystem built around Snowflake. Data sharing between different customers, it's a matter of you don't copy the data over, you can just refer to the data and still run analytics. Why is it important? You got a whole bunch of OEMs and you got a whole bunch of suppliers out there. If you want to share quality records or you want to share connected product performance data to your supply chain, you don't need to copy the data over.

15:33
PJ: Data can still reside on-premise or it can reside in whatever is your cloud vendor of choice. You can run analytics without the data movement out there. So we provide that kind of collaboration mechanisms. Another cool thing, with the volume of data, just visualizing billions of records or millions of records, human mind cannot comprehend that and derive inferences out of it. We provide AI and ML-based analytics. In fact, yesterday we demonstrated how you can just provide the data set to our pre-built anomaly detection algorithm. It is going to tell you that there is an anomaly going to happen and you might want to take a look instead of getting into an unplanned downtime kind of situation. So we do that as well. We provide all this reference architecture as part of Snowflake data platform. And obviously, with all these capabilities, it accelerates the analytics adoption, whether it is on IT or OT data or a mix of both.

16:31
PJ: So that's what Snowflake brings to the table from a manufacturing perspective. There's a lot of technical detail behind this. Feel free to stop by at our booth. We can go through this in detail on, any level of detail on what you would like to understand around what Snowflake brings to the table, technically speaking. Just to summarize, so what does it mean for customers and partners? So we got it covered, whether the data is sitting in silos of database and on-prem systems or it could, across different organizational boundaries, data is distributed, or it is distributed across multiple cloud vendors, across multiple regions, we can run analytics seamlessly. So I think that is one of the major value proposition we bring to the table. So any data products you build and offer to your customers, it's global in nature. It can scale. We got the security covered. There is seamless collaboration which is possible between you and your customers, and your suppliers.

17:31
PJ: It's not an issue at all, okay? Performance, as I said earlier, we got the performance factor covered as well, okay? Added to that we got thousands of customers today using Snowflake for various analytical needs today with pre-built integrations with popular systems like SAP, in addition to OT systems which Arlen talks about and which he's going to demonstrate as well. And we provide Snowflake Marketplace where you not only can take the products you've already built today on Ignition, you can monetize those data products and offer it through our marketplace to thousands of customers we got around the world. So that's what Snowflake brings to the table. Instantly scalable. You can build global data products which you can take it to your customers. So pretty much that's a Snowflake value proposition.

18:25
PJ: So again, quickly before I hand it over to Travis, this is how the journey started for us. Ignition on Edge with zero coding using Snowpipe Streaming API, send the data to Snowflake. So again, this is one of the best integration built by any cloud vendor as of today from a cost point of view and a fidelity of data point of view. To accurately represent every possible manufacturing data in cloud, you need to support around 13 data types. No other cloud vendor does that today. So maximum they support is four data types, which means all the other data types, you slam it on the existing data types you support. And there is always loss in translation issues associated with that.

19:10
PJ: In our case, we support all 13, Sparkplug B is an associate. We support all 13 of it, and this is the lowest possible cost integration with high performance, near real-time analytics, we can perform as well. That's what we built and launched as part of manufacturing cloud between Inductive Automation, Cirrus Link, Opto 22 as a joint solution offering. Okay. We have made that much better now with Snowflake, with Ignition Cloud Edition as a connected applications available in Snowflake, and along with that, in addition to OT data, you got IT data, you got third party data like weather, traffic information, supply chain information already being managed in Snowflake, you have an opportunity to build applications on top of Cloud Edition and take it to your customers. And every applications you have built and launched at Edge seamlessly will work in cloud, with this edition. I think again, this is a cloud vendor perspective. With that, I'm going to give it to Travis to talk about from Ignition point of view.

20:11
TC: Alright. Thank you.

20:19
TC: Alright. So everything that we are showing on this slide here is something that's available today. And we're gonna show a full example of how, with a demo with Arlen and myself, how we go from Edge to Cloud going into Snowflake, back into Ignition Cloud Edition so we can show some dashboards, get information out there. And what we're talking about is what Snowflake's calling Connected Apps, right? We're simply gonna be deploying Ignition Cloud Edition to our Azure AWS account, and we're gonna connect to Snowflake through JDBC, and be able to be able to get that data from there and put it onto dashboards. So we're gonna show you what that looks like. However, we're thinking future and how this can even grow and get even bigger as we go forward.

21:01
TC: And there is a potential future landscape where... Whoops. All of that can be simply running all within Snowflake's cloud environment, so that you could spin it up really, really fast and get these solutions going quickly. So, but the idea is really simple, right? The focus of this is being able to get data that is modeled, customers need to... Basically it's a culture shift, right? Where they have to think about how they're gonna standardize on data and their data models across their entire organization, and the idea of this is to get it into a storage where that data is stored with its context, so we can go a lot further. So, what's really funny about this whole thing, when we got introduced to Snowflake is, at the end of the day, it's a database and we can connect to it just like we connect to every other database within Ignition through JDBC. And you can install that JDBC driver really easily in Ignition and you can issue queries just like we do with any other database.

21:54
TC: And so, we're gonna show that here today. It's very, very easy to get connected, very easy to issue those queries. We can issue anywhere within Ignition and they also do provide REST API so you can actually go a little bit further as well with that. There was nothing we had to do in day one. We just had to install the JDBC driver and get started. And from the very beginning of our company, we've been centered around SQL databases. This is just now a database that's highly scalable, it's in the cloud that allows for a lot more opportunity that we can... Where we can... For what we can do with that data. And a lot of that is around AI and ML, as Pugal was saying, there's anomaly detection and forecasting services that are built into Snowflake, and you basically train models and you can can do the detection on those just by running simple SQL queries against Snowflake.

22:45
TC: So it's very easy to work with this. However, it doesn't have to be within that. Any other service or tool that's out there that wants to be able to do that same thing, you can connect to the database the same way and you have all that data, you have all the context, you can go and learn everything that's there and go a lot further, right? And with this, what we're talking about too is not only you get the storage, you get these kind of services, but you get those results back into Ignition so that we can provide that information back to our operators, can provide alarms, whatever it might be. So it's kinda that full circle kind of integrated solution. So that's all I wanted to say really, in terms of Ignition and Snowflake. We're gonna get into the demo a lot more, but I did wanna bring up the Community-Powered Sparkplug Data Dash, because we thought for the conference here, we wanted to show this whole thing in action.

23:31
TC: And well, we got all the community to participate, where they're basically leveraging Ignition or Ignition Edge or potentially have a smart device that speaks MQTT Sparkplug and they're gonna build a data model, publish that up to a Chariot broker that's in the cloud. Real simple. Then we can use the IoT bridge for Snowflake by Cirrus Link and all that data from Sparkplug goes directly into the Snowflake database. We're showing it on a dashboard within Ignition, but it's going to Snowflake database as well. And we can easily go and query that data. And we went one step further and we're actually showing the anomaly detection within the Data Dash. So we'll do a demonstration of this in just a moment, but wanna show you just how easy it is for this solution. And it's all something we could do right now. It's very, very simple to get started with this whole thing. So with that, Arlen, I'll bring it over to you for the demo... Start at the demo here.

24:23
AN: Alright. Cool. Thank you. All right. Real quick, the topology is, I've got some simulated devices. Some of the devices are in Stillwater, Oklahoma that I'm actually talking to publishing those up to distributor running on Ignition on an EC2 instance in the Cloud. And so what we're gonna do is we're gonna go into Ignition, we're gonna build our "digital twins," but they're much more than digital twins. We're gonna show all that context and then we're gonna say, "Okay. Well now we've got this single source of truth. How much code are we gonna have to write to get it into a highly scalable Ignition or into a highly scalable cloud database?" And then from there, Travis is gonna go, "Oh. Well I've got that data in there. Let's see what I can do with Ignition Cloud Edition."

25:13
AN: So we're going to do the live demo, which we always love doing. All right. So, I know it's a bit of an eye chart, but it's hard to zoom in on the Tag provider. But I've got a Tag provider, Smart Factory and Smart Factory, underneath that I've kind of got the whole unified namespace of, I've got Smart Factory one and under Smart Factory one, I might have some building management systems because we've got BACnet/IP with Ignition now, I might have some Opto 22 KYZ meters and I've got my equipment in the factory, right? I've got CNC, a lathe, haul-off machine. And then down here you can see I've got the notion of an extruder. And this extruder has some process variables, some temperatures and some pressures and things like that. And had we... The way that we've been doing this going forward is that executives came to operations, they go, "Hey guys, we heard there's digital transformation. We gotta get all of our data in the cloud."

26:15
AN: "Okay. Well let's put all of our data in the cloud." So they go out and they write a bunch of code and they go in here and they go, "Okay. Let's do this and then let's pretend this is the cloud over here. And boom. Okay. We're done." We've got all of our data going into the cloud. It's all going into a data lake. But wait a minute, without some context, how can I use this? So I come into my data lake and I wanna look at something, and I've got 148 degrees, 148.85 degrees, where'd that come from? What machine was it attached to? What plant did it come from? I don't know. Oh. That's over another database. So I need to write some code. And then maybe there was some other asset information, now I've gotta get some code. And what happens is we've got terabytes of data hitting data lakes in the cloud and nobody's doing anything with it because it's too hard and you can't get any context from the data. So, let's drain the swamp. And before we do that, let's go into that extruder and actually give it some context.

27:34
AN: So I wanna build a UDT of an extruder model. And every time that extruder shows up, the first thing that I want to do is I probably want to give it some asset information. Asset ID, asset serial number, location, anything else that you want to be available to you on each instance of that extruder in Snowflake that you want to be up there, you can define in your UDT and it'll be automatically published up there. And now that I've got my asset information, I can go back to that melt temperature and say, "Look, for that machine when melt temperature shows up, I don't care if it came from Allen-Bradley PLC or a Modbus or Rockwell, I want to know that it represents melt temperature, it's 0 to 225 somethings. Those are in degrees C, it's using absolute deadband.

28:22
AN: There's my deadband percentage and my scale mode and anything else again that I want available to me in Snowflake when I'm done with this demo, I can define in this UDT. So now that I've defined my machine, very, very simply using tools on platforms and I can go in and define a dryer and a bunker, and now I can come back and take those nebulous tags and look at the fact that this extruder actually was, extruder seven, was a model of an extruder. And you can see here I've got my asset ID Wile E. Coyote, asset serial number B549 courtesy of Hee Haw, location in Oklahoma and all my process variables. And since it is a UDT, I can use the Power Perspective or Vision to be able to start taking that and maybe when the extruder feeds into a bunker, and the bunker feeds parts when it comes out into a CO2 dryer, and maybe I've got an Opto 22 EMU and it's measuring the three-phase power on that extruder. But my point is, is that at 3:14 on September 27th, this is the single source of truth of my factory.

29:48
AN: This is the single source of truth. I didn't define it in the cloud and then try to bring it back down and iterate back and forth, I know this is my factory. So I just came off of a really cool demo from Snowflake and I go, "Wow. What if I could get that single source of truth into Snowflake? How hard would that be?" So what I'm gonna do is I'm gonna go to the Azure or AWS marketplace and I'm gonna download the IoT Bridge for Snowflake. I'm gonna install it. And when I install it, it's going to go in to my Snowflake console here and it's gonna create two very simple databases, a node database and a staging database. And in here, I have a very simple Sparkplug device message table that you can see right now is empty. And when we installed it, we also added some convenience and I could get a view, and since it's all going up from UDTs, I've got a view that says, "Hey, tell me about all the UDTs that are in that factory or all the factories." Oh, well, I don't have any factories yet. So I need to fix that. Let's go back into our Ignition configuration. And you can see here that I demo a lot. I've got a lot of tag providers and if you look at Smart Factory, it's pointing to the Snowflake MQTT server. So that's great. I'm gonna come over here and I'm gonna enable my MQTT transmission. Okay? And when I did that, what happened? 

31:36
AN: When I did that, MQTT transmission looked into the Smart Factory Tag provider and it says, "Hey Arlie. You've got all these models, you got dryers and extruders and conveyors." And so we're gonna publish those using Sparkplug. And the Snowflake Bridge was sitting there listening to an MQTT server. It was a very... It wasn't doing anything. All of a sudden, messages started showing up. Remember that advantage, auto discovery. "Oh. We got an extruder." Now I'm gonna put that into Snowflake using Snowpipe Streaming. So 15 seconds ago, I didn't know anything. Let's go back to our Snowflake console and let's hit Refresh. And lo and behold, we now have a Smart Factory 1 with views of every machine that we've got in that factory.

32:32
AN: Before I go look at one of those, let's ask the SQL database, what models do I have? Let's ask it again. "Oh. Arlen, you've got an extruder, a chiller, a dryer." So now I literally know everything that was in that UDT on Ignition. Now that I know all of the models, I can go back over here and say, "Well, now that I know that, let's go to that extruder and let's do an SQL query, which everybody knows SQL and single, this unified namespace, Smart Factory, Smart Factory 1, line seven, extruder seven, when did the message arrive? What was its sequence number, and all of my process variables in real-time, all hydrated, no holes in the database. I literally could start using this today. So if I know SQL, it took me five minutes to get all my machines defined, get everything up there in real-time. And now for every machine I had in that Smart Factory, I now have a single source of truth of all the real-time data is showing up in Snowflake. Pretty cool. Now, once it's in Snowflake, what can we do with it from there? And with that, I'll turn it back over to Travis.

33:55
TC: Sweet. Alright. So, again, once it's in the Snowflake database, it's just a matter of going and doing, issuing queries against that. So, I'm going to switch over and show you the Sparkplug Data Dash here. And so this is our server that we have that's running in the cloud. And you can see that we've got a Snowflake database connection here that is connected and valid. So what we did first though is we went to the driver's part here in Ignition and then JDBC drivers, we had a bunch of pre-built ones that come with it. Now we're working on getting the Snowflake one built into Ignition, in a new build. But for now, you can go download the JDBC driver and simply just go ahead and install it.

34:37
TC: And we have some instructions on that, a little Read Me on how to do that. Real simple. Get that installed. Once we have that installed, we can go and make a connection like we have here. And so just like any other databases, of course, once I have that valid connection, I can go anywhere in Ignition, and I can use it. So I'm gonna open up the designer here and what we've done for the Data Dash, and I'll go and show you the application in a minute. But we just basically, if I go to the Snowflake, we have a bunch of predefined name queries that basically go and query certain tables. So, he was showing that, that Sparkplug device messages table, and so if I go and look at this, you can see that we're just doing a standard select query against that Sparkplug device messages table.

35:21
TC: And we're looking for... And this one I'm filtering for specific group ID, Edge node ID, and a specific data model that I wanna look for, that we're using for the actual dashboard itself. So it's incredibly easy for me to go into Ignition. In fact, we can go into the database query browser against the Snowflake database and we can easily start saying, "Select star from stage DB, sparkplug device messages." And so we can just bring that data back and anywhere in Ignition within that. And in those queries, we can have... There could be millions of rows. In fact, with the Data Dash, we've got over 120 million rows at this point that we've been logging with that and it's very, very high performance to get that information back.

36:12
TC: So as you can see, that's how we have developed it with the Data Dash. Let's actually go and show the outcome of what we built. So we're gonna go to tryignitioniot.com. So if you haven't checked out Data Dash, simply go to tryignitioniot.com on your phone. You can go... There's the... On the tech lounge, there's a TV up there that has this application open. So here's what we did. We asked participants to go and do exactly what Arlen just showed. He built an extruder machine, a data model. Build any kind of data model that you want, right? Provide that context, provide those parameters that you wanna associate, provide the engineering units and the engineering ranges of the values. Basically create a UDT within Ignition or any other device that speaks Sparkplug, and have that published up to a cloud MQTT broker. With IoT Bridge, everything he showed, that all came into Snowflake and it's all ready to be discovered. So, this dashboard, you can go and you can actually go and see these data models. So if I go look at, for example, I'll use Opto 22's EPIC c-store. We're just showing a visualization of this. Let's go to a different c-store.

37:20
TC: So, we're just showing a visualization of that data model. So you can see the information up here. So there's a perspective template that corresponds to that data model, so that we can easily look at that live data. But again, that history is all going into Snowflake and it's accessible so that we can query that. So let's go over here to the Snowflake tab. And the first overview of this is basically just a discovery of all the data models that happen to exist within Snowflake. So much like he just showed how all those views got created, well now we can actually go and query those, and we can discover information about this. So for example, let's go in. Since I was using the Opto 22 c-store, I'll go into the Stillwater and look at that particular data model. So there, on the right-hand side, we can see all of the parameters that are gonna be... That are part of this is like the UDT definition. All the parameters that are there, what the data model is, here are all of the process variables that are in there.

38:17
TC: For the process variables, like, for example, if I look at this freezer compressor, I'm gonna get, of course, that it's KW and I get the range, 0 to 1500. So this is all... I can have Ignition completely independent from all of the... Not even connected to the MQTT broker, and I can see all the data models that happen to exist within Snowflake, because again, using Sparkplug, those templates were sent to a broker and into Snowflake, again, it's that same exact context. So very, very easy to see that. So this overview is kinda just showing all the data models that are in there, and we've got a whole slew of them with this, so let's see if I can clear this out or there's no exit on that, but we have a whole slew of different data models that are there. At the end of the day, then we can go and query the history very, very easily, and build dashboards and we can go a lot further.

39:06
TC: So I'm gonna show you two kind of demos, one is we're just gonna go and query the history, bring it back into trends, so we're gonna go and select... I'll need to go down to one of those instances, those data models that we have, I don't wanna look at that data, so we'll go... Again, we'll look at the Opto 22, since we're on there, we'll go to Stillwater, look at the EPIC c-store, and because we have the data model stored, you can see here's all the tags, all the process variables associated with it. We already know what those are, and I'll go and select a particular instance. So here's our c-store 405, here's my date range that I'd wanna query the history on, and we'll just select some process variables. I'm not gonna select all of them, we'll just do, let's say, the compressor, all the freezer system, we'll bring those back. I'll apply. And basically, at this point, we're gonna go and issue the... For that time period that we have up here, we're gonna issue a query to get back that history. The idea is that we can simply just go and query all that data. We can bring it back on trends... Hey, there we go, just took a few for that information to come back.

40:03
TC: So, not only is all that data stored there, we can discover that, we can understand what it is, we can query it, put it back onto a dashboard very, very easily. So that's kind of one demonstration of what we're using with Snowflake. The other, of course, is going to the ML/AI side. We're talking about anomaly detection. And so if I go back over here to the map and we look at a particular location, let me go back to that, that Stillwater one, on that freezer, where we have that Compressor KW, we do have the Anomaly Detection turned on in Snowflake. We trained the model based on good data already and just basically ran a SQL query to train the model. And once it's trained, then we continuously, since that data is piping through the bridge into Snowflake all the time, on the Snowflake side of the task that's running, very, very quickly, that is basically looking at the last bit of data we brought in and we're gonna run it through that model to see if it detects any anomalies. Now we're kind of manufacturing this by clicking a button that says Trigger Anomaly, but it is going through that whole system, kinda coming back, where we're getting that feedback back in Ignition. So if I go ahead and do that, what we're doing is gonna...

41:08
TC: We're gonna spike that Compressor KW, which of course, is gonna cause that anomaly to happen, but as you can see, that came back extremely fast, running that model very, very quickly on the Snowflake side. We got the anomaly that's an alarm within Ignition, we could do something about that, but those can be running all the time. And because we trained the model off of that UDT, any new site that has that same data model can take advantage of that same... The same thing that we've built, so we can easily do anomaly detection across the entire enterprise on those data models.

41:41
TC: So it's very, very easy to get these things going, to go further with all of this, not only are we showing how we can get the data into... Get it into Snowflake and how we can leverage those UDT models, we can easily bring it back into dashboards and show that data very effectively. So with that, I think we'll just be opening up to questions.

42:11
TC: So anybody have questions out there? Yes? We have one down here...

42:14
Speaker 4: I know it's hard to say, but what's the rough startup cost of getting the MQTT,

42:22
And then the Snowflake? 

42:26
AN: Free. It's one of the rough startup costs... Everything that you're seeing there, you can run in trial mode, right? So you'd probably have to get a test account, and you can get a test account from Snowflake. For the IoT Bridge, that's 30 days free. So you can do it for 30 days, basically for free.

42:47
TC: The whole thing would be, so you got... You've got Ignition you could do in trial period, no problem, in trial period, we can also provide longer trial licenses if required. The IoT Bridge is 30 days free, easy to work with, and with Ignition Cloud Edition, that would be the broker, that would be in the cloud, you'd wanna have some broker up there, it could be that, it could be something else, so you can run that for a couple of hours or a few hours. It's pretty low cost, maybe a dollar per hour. And then with Snowflake, I believe, when you create the account, there's a... I think credits you already get.

43:17
PJ: Yeah, they are some credit options, we can work with you on that. I would say it's pretty much everything is... When you do the compute, you do the reporting, it's pay-as-you-go... It's like electricity bill. When you use it, you get the bill; otherwise, we're not going to charge you. So, pay-as-you-go model. That's what it does. And again, I think having done those kind of Industry 4.0 initiatives,

43:38
AN: Multiple effort, I would say this is the lowest cost possible startup cost around Industry 4.0 because even four years back around what the initiatives which used to happen, a few hundred thousand dollars, we can connect three machines and we can do a business outcome. That was the pitch. It's no longer there. It'll be hardly a few thousand dollars to get it started. At pilot level, I don't see that as a challenge.

44:06
TC: And yeah, and one thing to mention is that... Oh, I lost my train of thought... Oh, well, we'll come back to that.

44:13
AN: Well, no, I think... What I was gonna mention is that, the other thing that's really different here, it was an advantage, Snowflake didn't have an IoT service when we started this project, so they had no notion of charging by the measurement. So it doesn't matter if you're publishing a 1000 tags or 50,000 tags, you're running in a compute warehouse, so you're not charged by the measurement like you are on all the other data services, you're just running in a compute warehouse; as long as you stay within that warehouse, you know your cost.

44:47
PJ: In fact, there are two advantages which came with that. When Arlen mentioned there is no IoT service, [0:44:53.8] ____ but last year when I took this role, I told Arlen that this time, when we do the integration between Snowflake and at the edge, for edge-to-cloud business outcome through Inductive Automation, they should be the best-in-class integration ever built on this planet, so far. Again, I think there, we had an advantage because we didn't have an IoT service. There are two major advantages which came with it; one, there is no additional cost factor. We are not gonna charge you for an IoT service which other cloud vendors are going to do.

45:26
PJ: The other one, pretty much every IoT service as a sub-optimal view of the manufacturing asset world, and they have done the modeling, that always comes to the challenge when you try to move that edge data to the cloud, there is always a compromise made on the data model. When you try to change the data model, you've got a bigger problem associated with it. So these are all the challenges we never had, so we made sure that we can handle every possible data types. And data ingestion, in our viewpoint, should be a commodity, because either way, we don't make a lot of money in data ingestions, it's pretty much nickel and dime to move the data from edge to the cloud, it's really around compute, that's how we charge you. So we are trying to keep it as easy as possible to move the data into the cloud.

46:09
TC: I remembered my train of thought real quick, which is for existing customers who already have Ignition, it's incredibly easy to take advantage of this. We're talking about simply just getting MQTT transmission, just plopping it in, if you have models already built, it'll be that quick to get integrated again.

46:24
AN: Exactly. If you already have Ignition, we're probably talking less than a day.

46:27
TC: We're talking, for new customers though, for people that maybe have a new site or a new facility or something, or they haven't had Ignition at all, it's going with Ignition Edge or your full Ignition, putting it in to connect to PLCs, bringing those... Building the models is super easy. In fact, we've also built a kit with Opto 22, where they have their EPIC controller with Ignition Edge on it already ready to go; especially for energy, with the energy monitoring units to basically pump those energy UDTs in the cloud, so there's a lot of easy ways to get started. Other questions? There's one in the back up there.

47:07
Speaker 5: So, for the piece that you were speaking about, in terms of ML or the pre-trained models, can you go into a little more detail about A, the training that goes into those pre-built models and B, the explainability behind those models? 

47:21
TC: Yeah, so for the Anomaly Detection Service, the way that that works is, you're basically kinda like calling a stored procedure almost. You're specifying, you're doing a train model call and you're specifying the data set that you'd wanna train it on. And so in our particular case, we're doing one of those [0:47:37.1] ____ as of use that Arlen showed, for a particular...

47:39
TC: So we did it for this, the c-store, we did it on that, on that freezer compressor, we basically brought back the data from the time period that we'd wanna train in... We trained it on, I think, a few thousand rows of data that was good. So we call that function once and it creates an object in Snowflake, that is the anomaly detection object. And much like you're creating a table or a view or a task screen like that, you're creating one that you can then run again later. So then next time, when you want to do a detect anomaly, you just run another SQL query that is saying... Basically, call this anomaly detection name, you say detect anomaly, so you give it a new query or a new set of data you'd wanna run through, and it will give you back a result, a table that's gonna show you, if all the data, if there's anomalies or not, what the variation is, all of that. And so we just basically take that, that result and if we see anomalies, we then trigger that alarm to come back to Ignition. So as simple as that, two queries: One to train and one to detect. It's as simple as that.

48:40
Speaker 6: Okay. Is there any plans to add discovery tools for engineers who like to look at trends initially to build out some ideas before they run it through the model? 

48:54
PJ: If you can swing by the Snowflake booth, we can go deeper into that. That's a longer conversation, if you don't mind.

49:02
AN: Alright.

49:02
TC: Alright. Thanks, everybody. Awesome.

49:03
AN: Thanks, everybody, appreciate it.