Defining a Data Lake object

You must define a table-like object in the Data Lake. You can define the object in Infor OS, Data Fabric, or Data Catalog. Other consumers of the data, such as a Business Intelligence (BI) system, can use this table.

Note: You must define the Data Lake object correctly. You cannot edit many properties after you create the object.

You can edit a ZIP file that contains the table configuration. Use this method to match the required keys and object name.

  1. Unzip the file.
  2. Edit the DMPRF1 folder and the DMPRF1.schema.json and DMPRF1.properties.json files to change the object name, column names, and data types.
  3. Zip the files again, for example, as DMPRF1.zip, or use another object name.
  4. Import the ZIP file into Data Catalog.
For example, the table has this identifier path: COUNTRY, WAREHOUSE, ITEM, YEAR, PERI, VERSIONDATE.

VERSIONDATE is a date in the YYYY-MM-DD format. Use this column to compare different forecasts. The VERSIONDATE column is set to the current date when you export a forecast to the Data Lake.

The variationNumber, timestamp, and deleted fields are optional. Data Lake design typically recommends these fields, especially when you might delete records.

The variationNumber field is filled with a value similar to today’s date (YYYYMMDD) or the current Epoch timestamp. The deleted field is left empty.