Class ExternalOperationsSchema.ExternalFileFormat

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.external_file_formats (Transact-SQL)

Applies to: √ SQL Server 2016 (13.x) and later √ Azure SQL Managed Instance √ Azure Synapse Analytics √ Analytics Platform System (PDW)

Contains a row for each external file format in the current database for SQL Server, SQL Database, and Azure Synapse Analytics.
Contains a row for each external file format on the server for Analytics Platform System (PDW).

See sys.external_file_formats.

[Table(Schema = "sys", Name = "external_file_formats", IsView = true)]
public class ExternalOperationsSchema.ExternalFileFormat

Inheritance

object

ExternalOperationsSchema.ExternalFileFormat

Extension Methods

Map.DeepCopy<T>(T)

Properties

DataCompression

The data compression method for the external data.
Range: For format_type = DELIMITEDTEXT:

- 'org.apache.hadoop.io.compress.DefaultCodec'
- 'org.apache.hadoop.io.compress.GzipCodec'

For format_type = RCFILE:

- 'org.apache.hadoop.io.compress.DefaultCodec'

For format_type = ORC:

- 'org.apache.hadoop.io.compress.DefaultCodec'
- 'org.apache.hadoop.io.compress.SnappyCodec'

For format_type = PARQUET:

- 'org.apache.hadoop.io.compress.GzipCodec'
- 'org.apache.hadoop.io.compress.SnappyCodec'

[Column("data_compression")]
[Nullable]
public string? DataCompression { get; set; }

Property Value

string

DateFormat

For format_type = DELIMITEDTEXT, this is the user-defined date and time format.

[Column("date_format")]
[Nullable]
public string? DateFormat { get; set; }

Property Value

string

Encoding

For format_type = DELIMITEDTEXT, this is the encoding method for the external Hadoop file.
Range: Always 'UTF8'.

[Column("encoding")]
[Nullable]
public string? Encoding { get; set; }

Property Value

string

FieldTerminator

For format_type = DELIMITEDTEXT, this is the field terminator.

[Column("field_terminator")]
[Nullable]
public string? FieldTerminator { get; set; }

Property Value

string

FileFormatID

Object ID for the external file format.

[Column("file_format_id")]
[NotNull]
public int FileFormatID { get; set; }

Property Value

int

FormatType

The file format type.
Range: DELIMITEDTEXT, RCFILE, ORC, PARQUET

[Column("format_type")]
[NotNull]
public byte FormatType { get; set; }

Property Value

byte

Name

Name of the file format. in SQL Server and Azure Synapse Analytics, this is unique for the database. In Analytics Platform System (PDW), this is unique for the server.

[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string

RowTerminator

For format_type = DELIMITEDTEXT, this is the character string that terminates each row in the external Hadoop file.
Range: Always '\n'.

[Column("row_terminator")]
[Nullable]
public string? RowTerminator { get; set; }

Property Value

string

SerdeMethod

For format_type = RCFILE, this is the serialization/deserialization method.

[Column("serde_method")]
[Nullable]
public string? SerdeMethod { get; set; }

Property Value

string

StringDelimiter

For format_type = DELIMITEDTEXT, this is the string delimiter.

[Column("string_delimiter")]
[Nullable]
public string? StringDelimiter { get; set; }

Property Value

string

UseTypeDefault

For format_type = DELIMITED TEXT, specifies how to handle missing values when PolyBase is importing data from HDFS text files into Azure Synapse Analytics.
Range: 0 - store missing values as the string 'NULL'.

1 - store missing values as the column default value.

[Column("use_type_default")]
[Nullable]
public bool? UseTypeDefault { get; set; }

Property Value

bool?