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.
|
Attribute |
API Type |
Default |
Description |
 |
CompressionType |
TableCompressionType |
|
This value specifies what kind of compression the table uses.
[.NET API Property: CompressionType] |
 |
ExternalPartitionScheme |
String |
|
Defines that the table uses a partition that is not modeled as part of the project. This can also be used to create the table on a particular filegroup or the "default" filegroup.
[.NET API Property: ExternalPartitionScheme] |
 |
FriendlyName |
String |
|
Specifies the name to use in the SSAS data source view and downstream SSAS objects.
[.NET API Property: FriendlyName] |
 |
LateArriving |
Boolean |
|
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.
[.NET API Property: LateArriving] |
 |
LogicalDisplayFolder |
String |
|
Specifies a path that should be used for organizing the tree display of this object in the Logical View in BimlStudio.
[.NET API Property: LogicalDisplayFolder] |
 |
Name |
String |
|
Specifies the name of the object. This name can be used to reference this object from anywhere else in the program.
[.NET API Property: Name] |
 |
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.
[.NET API Property: PackageSubpath] |
 |
PartitionColumnName |
AstTableColumnBaseNode |
|
Defines the table column used by the partition scheme.
[.NET API Property: PartitionColumn] |
 |
PartitionSchemeName |
AstPartitionSchemeNode |
|
Indicates the partition scheme that will be used by this table.
[.NET API Property: PartitionScheme] |
 |
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.
[.NET API Property: Schema] |