SMML Elements: Physical Table Alias

The SMML physical table alias element corresponds to the physical table alias object in the physical layer of a semantic model.

Physical Table Alias Elements

• name (required property) — The name of the physical table alias.

• description — The description of the physical table alias.

• tags — Keywords assigned to this object. This element corresponds to the Tags field.

• sourceTable (required property) — For alias tables only. References the physical table that is being used as the source for this alias table.

• additionalKeys — Keys that can be defined in addition to primary and display columns.

• caching — If set to TRUE, indicates that this table is included in the Oracle Analytics query engine query cache. See Caching Elements.

• dynamicName — If a session variable is being used to specify the name of this physical table alias, this element references that session variable.

• overrideSourceCacheSetting — For alias tables only. If set to TRUE, indicates that the alias table has its own cache properties that override the cache properties of the source table.

Syntax

{
    "$schema": "http://json-schema.org/draft-04/schema#",
    "$ref": "#/definitions/physicalTableAlias",
    "definitions": {
        "physicalTableAlias": {
            "type": "object",
            "additionalProperties": false,
            "properties": {
                "name": {
                    "type": "string"
                },
                "description": {
                    "type": "string"
                },
                "tags": {
                    "type": "array",
                    "items": {
                        "type": "string"
                    }
                },
                "sourceTable": {
                    "type": "string"
                },
                "additionalKeys": {
                    "type": "array",
                    "items": {
                        "type": "array",
                        "items": {
                            "type": "string"
                        }
                    }
                },                
                "caching": {
                    "$ref": "common_schemas#/definitions/Caching"
                },
                "dynamicName": {
                    "type": "string"
                },
                "overrideSourceCacheSetting": {
                    "type": "boolean"
                }
            },
            "required": [
                "name",
                "sourceTable"
            ],
            "title": "PhysicalTableAlias"
        }
    }
}