Table of Contents

Search

  1. Preface
  2. Introduction to Microsoft Azure Synapse SQL Connector
  3. Connections for Microsoft Azure Synapse SQL
  4. Mappings for Microsoft Azure Synapse SQL
  5. Upgrading to Microsoft Azure Synapse SQL Connector
  6. Migrating a mapping
  7. SQL ELT optimization
  8. Data type reference
  9. Troubleshooting

Microsoft Azure Synapse SQL Connector

Microsoft Azure Synapse SQL Connector

Supported features for Microsoft Azure Data Lake Storage Gen2 source

Supported features for Microsoft Azure Data Lake Storage Gen2 source

When you configure
SQL ELT optimization
, the mappings support the following properties for a Microsoft Azure Data Lake Storage Gen2 source:
Source
  • Azure Government endpoints
  • Source Type
    • Single object
    • Parameter
  • Format Type
    • Delimited
    • ORC
    • Parquet
  • Formatting options
    • Delimiter
    • Qualifier
    • First Data Row
    • Import from schema file
  • Filesystem Name Override
  • Directory Override
  • File Name Override
  • Compression Format
  • Edit metadata
You can also read data from a Microsoft Azure Data Lake Storage Gen2 case-sensitive database.
Lookup
When you configure
SQL ELT optimization
, the mappings support the following properties for Microsoft Azure Data Lake Storage Gen2 connected and unconnected lookup:
  • Azure Government endpoints
  • Source type
    • Single Object
    • Parameter
  • Multiple matches
    • Connected lookup - Return all rows
    • Unconnected lookup - Report error
  • Format Type
    • Delimited
    • ORC
    • Parquet
  • Formatting options
    • Delimiter
    • Qualifier
    • First Data Row
    • Import from schema file
  • Filesystem Name Override
  • Directory Override
  • File Name Override
  • Compression Format
  • Edit metadata

0 COMMENTS

We’d like to hear from you!