BIML Language Reference
Table Element
Table objects correspond directly to regular tables in the SQL Server product. They support all of the same features and present all of the same limitations.
Attributes
| Attribute | API Type | Default | Description | |
|---|---|---|---|---|
 | ConnectionName | AstDbConnectionNode | This value specifies the connection where the table is located. | |
 | Name | String | Specifies the name of the object. This name can be used to reference this object from anywhere else in the program. | |
 | CompressionType | TableCompressionType | None | This value specifies what kind of compression the table uses. |
| FriendlyName | String | Specifies the name to use in the SSAS data source view and downstream SSAS objects. | |
| LateArriving | Boolean | false | This value specifies whether the table supports late arriving rows. Late arriving rows allow the table to create placeholder values that are patched later when a dimension foreign key value is loaded in a referencing tabe before it is present in this table. |
| PackageSubpath | String | This specifies a file path fragment to use for emitting output files for this table. It is most commonly employed to ensure that the output files for multiple tables will be placed into the same output directory. | |
 | SchemaName | AstSchemaNode | This value specifies the schema to which this table belongs. If this value is not supplied, the table will use the default schema specified in the database. |
Collection Children
| Child | API Type | Description | |
|---|---|---|---|
 | <Columns> Multiple Choices... </Columns> | AstTableColumnBaseNode | This is a container for table column definitions. |
 | <Annotations> <Annotation /> </Annotations> | AstAnnotationNode | This is a collection of annotation items that can be used to specify documentation, tags, or other information. Annotations are particularly useful for storing information about nodes that can be used by BimlScript code. |
| <CustomExtensions> <CustomExtension /> </CustomExtensions> | AstCustomExtensionContainerTaskNode | This is a collecton of containers for table index definitions or other table customization. |
| <Indexes> <Index /> </Indexes> | AstTableIndexNode | This is a container for table index definitions. |
| <Keys> Multiple Choices... </Keys> | AstTableKeyBaseNode | This is a container for table key definitions. |
| <Sources> <StaticSource /> </Sources> | AstTableSourceBaseNode | This is a container for table source definitions. |