The Varigence company brand logo
Products
BimlFlexBimlStudioBimlExpress
Pricing
Solutions
IndustriesUse Cases
Resources
DocumentationKnowledge BaseBlog
About
CompanyContact Us
Products
BimlFlexBimlStudioBimlExpress
Pricing
Solutions
IndustriesUse Cases
Resources
DocumentationKnowledge BaseBlog
About
CompanyContact Us
Schedule Demo
Account
Schedule Demo
Account

Default External File Format

The default External File Format SQL Statement to use.

Notes:

  • This setting is part of the SSDT settings category.
  • The default value for this setting is CREATE EXTERNAL FILE FORMAT [pipe_zip_format] WITH ( FORMAT_TYPE = DELIMITEDTEXT, FORMAT_OPTIONS ( FIELD_TERMINATOR = N'|', USE_TYPE_DEFAULT = FALSE ), DATA_COMPRESSION = N'org.apache.hadoop.io.compress.GzipCodec' );.

© Varigence