• PRODUCTS
  • SUPPORT
  • DOCS
  • PARTNERS
  • COMPANY
  • QUOTE
  • ACCOUNT
  • STORE
QUOTE

Documentation

Support Forums
What can we help you with?
Topics

Class AstAzureSqlDataWarehouseUploadTaskNode

The Azure SQL Data Warehouse Upload task node corresponds directly to an Azure SQL Data Warehouse Upload Task.

Namespace:
Varigence.Languages.Biml.Task
Assembly:
Biml.dll
C#
    public class AstAzureSqlDataWarehouseUploadTaskNode : AstTaskBaseNode, IBindableItem, IVulcanCollectionParent, IVulcanNotifyPropertyChanged, IPropertyChangeNotificationTarget, IGetJsonProvider, INamedNode, IScopeBoundary, IReferenceableItem, IFrameworkItem, INotifyPropertyChanged, IXObjectMappingProvider, IValidationInfo, IDataErrorInfo, INamedItem, IScopedNameIndexable, IDataflowItem
    
  
Inheritance
System.Object
AstNode
AstNamedNode
AstScopeBoundaryNode
AstTaskNode
AstTaskBaseNode
AstAzureSqlDataWarehouseUploadTaskNode
Derived
AstAzureSqlDataWarehouseUploadTaskNode
Implements

IBindableItem, Varigence.Utility.Collections.IVulcanCollectionParent, Varigence.Utility.ComponentModel.IVulcanNotifyPropertyChanged, Varigence.Utility.ComponentModel.IPropertyChangeNotificationTarget, IGetJsonProvider, INamedNode, IScopeBoundary, IReferenceableItem, IFrameworkItem, System.ComponentModel.INotifyPropertyChanged, Varigence.Utility.Xml.IXObjectMappingProvider, IValidationInfo, System.ComponentModel.IDataErrorInfo, INamedItem, Varigence.Utility.Collections.IScopedNameIndexable, IDataflowItem,

Constructors

AstAzureSqlDataWarehouseUploadTaskNode(IFrameworkItem)

Initializes a new instance of the AstAzureSqlDataWarehouseUploadTaskNode class with the specified parent node.

Properties

BlobContainer

Specifies the name of the blob container that should be the target of file uploads or the source of file downloads.

BlobContainerDefaultValue

Gets the default value for the BlobContainer property

BlobDirectory

Specifies the virtualhierarchical structure directory path that should be used to locate files for download or that should be prepended to files that are uploaded to blob storage. (https://azure.microsoft.com/en-us/documentation/articles/storage-dotnet-how-to-use-blobs/)

BlobDirectoryDefaultValue

Gets the default value for the BlobDirectory property

ColumnDelimiter

This value specifies the delimiter to use to segregate columns.

ColumnDelimiterDefaultValue

Gets the default value for the ColumnDelimiter property

ColumnMappings

This value specifies how the component should map columns in the source to columns in the destination. Columns that are not explicitly listed in this collection are automatically mapped based on name.

CompressionLevel

Provides options for supported file compression levels in Azure Storage.

CompressionLevelDefaultValue

Gets the default value for the CompressionLevel property

CompressionType

Provides options for supported file compression types in Azure Storage.

CompressionTypeDefaultValue

Gets the default value for the CompressionType property

DataWarehouseConnection

This value specifies the ADO.NET connection to use to connect to Azure SQL Data Warehouse.

FileFilter

Specifies the filter, with wildcards, that is used to determine the files that are included in the Azure Blob storage upload or download. If unspecified, this property defaults to '*' which will include all files.

FileFilterDefaultValue

Gets the default value for the FileFilter property

FirstRowAsHeader

Specifies whether or not the first row in the file should be treated as a list of header labels. The default value is true.

FirstRowAsHeaderDefaultValue

Gets the default value for the FirstRowAsHeader property

FriendlyTypeName

Gets the friendly name of the type of this node

FriendlyTypeNameStatic

Gets the friendly name of the type of this node

HashColumn

Specifies the name of the column that was used for hash table distribution. Only relevent if TableDistribution is set to 'Hash'.

HashColumnDefaultValue

Gets the default value for the HashColumn property

IsNewTable

Specifies whether or not the user is creating a new table or inserting into an existing one.

IsNewTableDefaultValue

Gets the default value for the IsNewTable property

IsRecursive

Specifies whether or not subfolders should be recursively scanned for source files. The default is false.

IsRecursiveDefaultValue

Gets the default value for the IsRecursive property

LocalDirectory

Specifies the path to the local directory that will store files to upload or files that have been downloaded.

LocalDirectoryDefaultValue

Gets the default value for the LocalDirectory property

RetainFiles

Specifies whether to retain the files uploaded to Azure Storage. The default is false.

RetainFilesDefaultValue

Gets the default value for the RetainFiles property

RowDelimiter

This value specifies the delimiter to use to segregate rows.

RowDelimiterDefaultValue

Gets the default value for the RowDelimiter property

SQL

This value specifies the SQL query to use to load data from the specified connection.

SQLDefaultValue

Gets the default value for the SQL property

StaticUserDefinedItems

Specifies a collection of items that are common across all instances of the same type in the framework.

StorageConnection

Specifies the AzureStorageConnection that should be used to connect to Microsoft Azure Blob Storage.

Table

Specifies the table node for the DataWarehouse destination.

TableDistribution

Specifies the distribution method (either 'Hash' or 'RoundRobin') for the new table.

TableDistributionDefaultValue

Gets the default value for the TableDistribution property

Methods

BindingScopeBoundaries()

Retrieves the permitted scope boundaries to bind references from this node.

BindReference(SymbolTable, String, Boolean, String, Int32, Boolean)
CopyFrom(IFrameworkItem, UnboundReferences)

Instructs the node to copy property values from the supplied node into itself. This method should only be used by the internal Biml framework.

DefinedAstNodes()

Retrieves a collection of nodes that have been defined as direct children of the current node.

Duplicate()

Creates a duplicate of the current node

Duplicate(Dictionary<IFrameworkItem, IFrameworkItem>)

Creates a duplicate of the current node with the scoped node mapping

Duplicate(IFrameworkItem)

Creates a duplicate of the current node with the specified parent item

Duplicate(IFrameworkItem, Dictionary<IFrameworkItem, IFrameworkItem>)

Creates a duplicate of the current node with the specified parent item and scoped node mapping

DuplicateHusk(IFrameworkItem)

Creates an empty object into which the values from the current node will be duplicated. This method should only be used by the internal Biml framework

DuplicateInto(IFrameworkItem, Dictionary<IFrameworkItem, IFrameworkItem>)

Copies the values from the current node into a husk object with the specified scoped node mapping. This method should only be used by the internal Biml framework

EmitXmlForAction(AstEnginePropertyAction)

Instructs the node to make changes to its underlying Biml code that correspond to the provided action. This method should only be used by the internal Biml framework.

EmitXmlForProperty(String, Int32)

Instructs the node to make changes to its underlying Biml code that correspond to the provided property and index. This method should only be used by the internal Biml framework.

ForceNull(String, Int32)

Internal method used by the compiler to make a propert value null when required by the binding framework.

GetAllItemsReferencedByDefinedSuccessors()

Builds a list of all items referenced by this node and its successors. Each tuple in the returned list represents a FrameworkItemReference. The first item is the ReferencingItem, the second item is the property name, and the third item is the ReferencedItem.

GetBimlAttributeFragment(CulturedStringBuilder)
GetBimlChildFragment(CulturedStringBuilder, Int32)
GetBimlFragment(CulturedStringBuilder, Int32, Boolean)

Internal method used by the Biml engine to produce the XML code for the current object.

GetDefaultValue(String)

Retrieves the default value for the property with the name propertyName

GetDefaultValue<T>(String)

Retrieves the default value for the property with the name propertyName

GetJson(StringBuilder, ref Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean)

Generates a JavaScript Object Notation (JSON) representation of the current node

GetPotentialParentProperties()

Retrieves the reflection information for related properties of this node type.

GetPropertyValue(String)

Retrieves the current value for the property with the name propertyName

GetReflectionInfoFromXmlParsePath(String)

Retrieves the reflection information corresponding to the Xml parse path beginning at this node.

HasAnyBimlChildNodes()
MergeFrom(IFrameworkItem, UnboundReferences, Boolean)

Instructs the node to merge property values from the supplied node into itself. This method should only be used by the internal Biml framework.

NotifyCollectionPropertyChanged(Object, String, NotifyCollectionChangedEventArgs)

Internal Biml framework method used to notify this node that the specified collection property value has changed.

ParseAttribute(XAttribute, ParserContext)
ParseChild(XElement, ParserContext)
StructureEquals(Object)

Compares this node to the provided object to determine if all defined children and references are equal.

Validate(ValidationReporter)

Retrieves a collection of validation and diagnostic messages for the current node.

© Varigence