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 toTRUE
, 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 toTRUE
, 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"
}
}
}