Managing Metadata Tables on a Nominode

Managing Metadata Tables on a Nominode

You can use the Metadata section of your Nominode to create and update metadata tables for the data sets that your Tasks interact with.

Creating a Metadata Connection for Nominode data

  1. Click on Connections in the middle of the left hand navigation menu of your Nominode.
  2. Set the Project Select field at the top of the page to default.
  3. Click on the Create Connection button in the upper right hand corner of the page.
  4. Select NomNom:Metadata in the Create Connection dialog.
  5. Click on the Create button.
  6. The values needed for the Connection depend on what is specified in the [DATABASE] section of the config.ini file in the nominode folder on your Nominode.  The rest of these steps use the default values.  Replace with your Nominode's specific values if they have been changed from default.
  7. Fill in Local Nominode Data for the Alias value.
  8. Fill in mysql for the Hostname value.
  9. Fill in nomnomdata for the Database Name value.
  10. Fill in root for the Username value.
  11. Fill in mysqlroot for the Password value.
  12. Fill in 3306 for the Port value.
  13. Click on the Create button in the upper right hand corner of the section or the Save button at the bottom.
  14. Click on Yes when prompted to save the Connection.

Creating a Metadata Table

  1. If your Nominode does not have a Metadata Connection for Nominode data, the steps below will still create a Metadata table.  However, information in Metadata table other than its alias and description will not display and the entire Metadata table will disappear from display when you refresh your browser window. 
  2. Click on Metadata in the middle of the left hand navigation menu of your Nominode.
  3. Click on the Create Metadata Table button in the upper right hand corner of the page.
  4. In the Data Table Create dialog, fill out the required alias value along with the optional description, version, load type, location type, load parameters, key parameters, custom parameters, ancestry and location parameters values to populate your Metadata table.
  5. If you click in the browser outside of the Data Table Create dialog, it will disappear.  Click on the Create Metadata Table button to bring it back with the values you have entered intact.
  6. When you add a parameter, a new row will appear after it to give you the option to add another parameter of the same type.
  7. Click on the OK button at the bottom of the dialog.
  8. Click on the Ok button in the Success dialog.

Modifying a Metadata Table's values

  1. Click on Metadata in the middle of the left hand navigation menu of your Nominode.
  2. Locate your Metadata Table in the list, using the search fields or page navigation arrows if necessary.
  3. Click on the alias of the Metadata Table in the Name column.
  4. Click on the Edit button in the upper right hand corner of the Data Table Information page.
  5. In the Data Table Edit dialog, add, change or remove the alias, description, version, load type, location type, load parameters, key parameters, custom parameters, ancestry and location parameters values associated with your Metadata Table.
  6. When you add a parameter, a new row will appear after it to give you the option to add another parameter of the same type.
  7. Click the red trash can icon next to a parameter's value to remove both it and the parameter.
  8. Click on the Submit button at the bottom of the dialog.
  9. Click on the Ok button in the Success dialog.
  10. Refresh your browser to see your updated values.

Clicking in the browser window outside of the Data Table Edit dialog will result in any changes being lost.
If you do not refresh your browser as the last step and you click the Edit button again, you will see your previous unmodified values.  However, your modified values have been saved, they are just not displaying until you refresh your browser.

Adding a Comment to a Metadata Table

  1. Click on Metadata in the middle of the left hand navigation menu of your Nominode.
  2. Locate your Metadata Table in the list, using the search fields or page navigation arrows if necessary.
  3. Click on the alias of the Metadata Table in the Name column.
  4. Add the desired text to box below the existing comments (if any) in the middle of the page.
  5. Click on the Add Comment button.

Ignore the Apply button.  It currently has no functionality.

Removing a Comment associated with a Metadata Table

  1. Click on Metadata in the middle of the left hand navigation menu of your Nominode.
  2. Locate your Metadata Table in the list, using the search fields or page navigation arrows if necessary.
  3. Click on the alias of the Metadata Table in the Name column.
  4. Click on the Delete link beneath the comment that you want to remove.

Adding a Column to a Metadata Table

  1. Click on Metadata in the middle of the left hand navigation menu of your Nominode.
  2. Locate your Metadata Table in the list, using the search fields or page navigation arrows if necessary.
  3. Click on the alias of the Metadata Table in the Name column.
  4. Click on the Add Column button in the upper right hand corner of the Data Table Columns section of the Data Table Information page.
  5. In the Column Create dialog, fill out the required column_name, relative_position and version_added values along with the optional parameters and comments values for your Column.
  6. Click on the Submit button at the bottom of the dialog.
  7. Click on the ( X ) button in the upper right hand corner of the dialog.
  8. Refresh your browser to see your added Column.

Clicking in the browser window outside of the Column Create dialog will result in any changes being lost.
After the first Column has been added, steps 7 and 8 will not be needed.  Instead, there will be a confirmation dialog.  Click on the Ok button in it to save your column.

Viewing a Metadata Table Column's details

  1. Click on Metadata in the middle of the left hand navigation menu of your Nominode.
  2. Locate your Metadata Table in the list, using the search fields or page navigation arrows if necessary.
  3. Click on the alias of the Metadata Table in the Name column.
  4. Locate the Column's name in the Column Name column of the Data Table Columns section of the Data Table Information page.
  5. Click on the plus symbol ( + ) in the row with the Column's name to view the Column's details in JSON format.

Editing a Metadata Table Column's details

  1. Click on Metadata in the middle of the left hand navigation menu of your Nominode.
  2. Locate your Metadata Table in the list, using the search fields or page navigation arrows if necessary.
  3. Click on the alias of the Metadata Table in the Name column.
  4. Locate the Column's name in the Column Name column of the Data Table Columns section of the Data Table Information page.
  5. Click on the Edit link in the Action column in the row with the Column's name.
  6. In the Column Edit dialog, add, change or remove the column_name, relative_position, version_added, parameters and comments values for your Column.
  7. Click on the Submit button at the bottom of the dialog.
  8. Click on the Ok button in the Success dialog.

Clicking in the browser window outside of the Column Edit dialog will result in any changes being lost.

Removing a Column from a Metadata Table

  1. Click on Metadata in the middle of the left hand navigation menu of your Nominode.
  2. Locate your Metadata Table in the list, using the search fields or page navigation arrows if necessary.
  3. Click on the alias of the Metadata Table in the Name column.
  4. Locate the Column's name in the Column Name column of the Data Table Columns section of the Data Table Information page.
  5. Click on the Delete link in the Action column in the row with the Column's name.
  6. Alternatively, you can use the checkbox column to select multiple Columns and then click the Delete button in the upper left hand corner of the Data Table Columns section to remove multiple Columns at the same time.
  7. Click on the Ok button in the Delete Column confirmation dialog.

Removing a Metadata Table

  1. There is currently no way to delete a Metadata Table within the Nominode interface.


    • Related Articles

    • Managing Users on a Nominode

      Adding a New User Any person that you would like to add to your Nominode must have a Nom Nom Data account.  New accounts can be registered at https://auth.nomnomdata.com/sign-up Open https://my.nomnomdata.com and click on the Login button in the ...

    • Managing Connections on a Nominode

      A Connection allows you to store accounts, passwords, tokens, keys and other sensitive information used by Tasks securely on your Nominode. Creating a Connection Click on Connections in the middle of the left hand navigation menu of your Nominode. ...

    • Managing Tasks on a Nominode

      Tasks allow you to schedule and automate the execution of the functions within the Nom Nom Apps on your Nominode. Creating a Task Click on Tasks near the top of the left hand navigation menu of your Nominode. Set the Select Project field at the top ...

    • Managing Permissions on a Nominode

      In the Permissions section of your Nominode, you can control what actions each user of your Nominode can perform.  A general description of Permissions architecture can be found in the Nominode Permissions Overview support document. Viewing which ...

    • Managing Sequences on a Nominode

      Sequences are used to schedule one or more Tasks to execute at specific times on a recurring basis.  Sequences are also used allow one Task to begin execution after another Task completes its execution, rather than at a specific time. Creating a ...