Biml Language Reference
ColumnPatternProfileRequest Element
The AstColumnPatternProfileRequestNode type corresponds directly to the column pattern data profile in the SQL Server Integration Services data profiling task, which will compute a collection of patterns that describe the values in a character-based column.
Attributes
  Attribute API Type Default Description
CaseSensitive Boolean
This value specifies whether the patterns will be evaluated against column values using case sensitive comparisons.

[.NET API Property: CaseSensitive]

Column String
This value specifies the name of the column whose values will be profiled against the specified pattern.

[.NET API Property: Column]

ConnectionName AstAdoNetConnectionNode
This value specifies the connection that will be used to access the target table.

[.NET API Property: Connection]

Delimiters String
This value specifies the characters that will be replaced with spaces before tokenizing. The default include tab (\t), carriage return (\r), and line feed (\n).

[.NET API Property: Delimiters]

MaxNumberOfPatterns Int32
This value specifies the maximum number of patterns that will be computed by the profile up to 100. The default is 10.

[.NET API Property: MaxNumberOfPatterns]

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]

PercentageDataCoverageDesired Int32
This value specifies the percentage of data in the column that should be covered by the generated patterns from 0 to 100. The default is 95.

[.NET API Property: PercentageDataCoverageDesired]

SchemaId String
This value specifies the name of the schema that contains the table that will examined by the data profile task. This property is used in conjunction with TableId when the table cannot be referenced by the Table property, because it has not been modeled in the Biml project.

[.NET API Property: SchemaId]

Symbols String
This value specifies any symbols or punctuations that should be retained as part of the patterns. The default includes ,.;:-"'`~=&/\@!?()<>[]{}|#*^%.

[.NET API Property: Symbols]

TableId String
This value specifies the name of the table that will examined by the data profile task. This property is used in conjunction with SchemaId when the table cannot be referenced by the Table property, because it has not been modeled in the Biml project.

[.NET API Property: TableId]

TableName AstTableNode
This value specifies a direct connection to the table that will examined by the data profile task.

[.NET API Property: Table]

TagTableConnectionName AstAdoNetConnectionNode
This value specifies a direct reference to the ADO.NET connection that contains the tag table.

[.NET API Property: TagTableConnection]

TagTableName AstTableNode
This value specifies a direct connection to the tag table which will tag 2 string columns - Tag and Term.

[.NET API Property: TagTable]

TagTableSchemaId String
This value specifies the name of the schema that contains the tag table. This property is used in conjunction with TableId when the tag table cannot be referenced by the TagTable property, because it has not been modeled in the Biml project.

[.NET API Property: TagTableSchemaId]

TagTableTableId String
This value specifies the name of the tag table. This property is used in conjunction with TableId when the tag table cannot be referenced by the TagTable property, because it has not been modeled in the Biml project.

[.NET API Property: TagTableTableId]

Collection Children
  Child API Type Description
<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.

[.NET API Property: Annotations]