Skip to content

AssetAdditionalProperties

For Assets with different schemas under the same Entity, a specific table AssetAdditionalProperties has been included in order to cover the scenarios for Excel files ingestion specifically.

This table contains a Regex, or regular expression field, to map out a specific set of Assets. This table also contains a new field called AdditionalProperties for a specific Asset, that contains the appropriate JSON configuration for reading the schema of the Excel files to be ingested via Landing area. Then:

  • If there is a match between the Asset name and the regular expression (Regex) field in AssetAdditionalProperties, the AdditionalProperties field from this AssetAdditionalProperties table will be applied as an input for specifying the schema of such Asset.
  • If there is not a match between the Asset name and the regular expression (Regex) field in AssetAdditionalProperties, the ExcelDataIntake.py notebook should take the JSON configuration of the AdditionalProperties field at Entitiy level.
Column Description Format Required
Id AssetAdditionalProperties identifier int
IdEntity Identifier of the Entity int
AssetNameRegex Specific regular expression nvarchar(max)
AdditionalProperties Schema for the Asset related nvarchar(max)
Order Checking order of the regular expressions smallint


Sidra Ideas Portal


Last update: 2022-09-05
Back to top