Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Microsoft Azure Data Lake Storage Gen2
  3. PowerExchange for Microsoft Azure Data Lake Storage Gen2 Configuration
  4. Microsoft Azure Data Lake Storage Gen2 Connections
  5. PowerExchange for Microsoft Azure Data Lake Storage Gen2 Data Objects
  6. Microsoft Azure Data Lake Storage Gen2 Mappings
  7. Appendix A: Microsoft Azure Data Lake Storage Gen2 Datatype Reference

PowerExchange for Microsoft Azure Data Lake Storage Gen2 User Guide

PowerExchange for Microsoft Azure Data Lake Storage Gen2 User Guide

Importing a Microsoft Azure Data Lake Storage Gen2 Data Object

Importing a
Microsoft Azure Data Lake Storage Gen2
Data Object

Import a
Microsoft Azure Data Lake Storage Gen2
data object to add to a mapping.
  1. Select a project or folder in the
    Object Explorer
    view.
  2. Click
    File
    New
    Data Object
    .
  3. Select
    Microsoft Azure Data Lake Storage Gen2 Data Object
    and click
    Next
    .
    The
    Microsoft Azure Data Lake Storage Gen2 Data Object
    dialog box appears.
  4. Enter a name for the data object.
  5. In the
    Resource Format
    list, select any of the following formats:
    • Intelligent Structure Model: to read any format that an intelligent structure parses.
    • Binary: to read and write any resource format.
    • Flat: to read and write delimited resources.
    • Avro: to read and write Avro resources.
    • Json: to read and write JSON resources.
    • ORC: to read and write ORC resources.
    • Parquet: to read and write Parquet resources.
    Intelligent structure model is supported only on the Spark engine. For a data object with an intelligent structure model, create a read operation. You cannot use a write transformation for a data object with an intelligent structure model in a mapping. Avro, JSON, ORC, and Parquet are supported in the native and non-native environments.
  6. Click
    Browse
    next to the
    Location
    option and select the target project or folder.
  7. Click
    Browse
    next to the
    Connection
    option and select the
    Microsoft Azure Data Lake Storage Gen2
    connection from which you want to import the
    Microsoft Azure Data Lake Storage Gen2
    resource metadata.
  8. To add a resource, click
    Add
    next to the
    Selected Resources
    option.
    The
    Add Resource
    dialog box appears.
  9. From the Package Explorer, select a naming context from which you want to import the schema.
  10. You can Perform one of the following tasks to import an
    Microsoft Azure Data Lake Storage Gen2
    file, and then click
    OK
    :
    • Navigate to the
      Microsoft Azure Data Lake Storage Gen2
      file that you want to import.
    • Search for the
      Microsoft Azure Data Lake Storage Gen2
      file, enter the name of the
      Microsoft Azure Data Lake Storage Gen2
      file that you want to add and click
      OK
      .
  11. Click
    Finish
    .
    The data object appears under Data Objects in the project or folder in the
    Object Explorer
    view.

0 COMMENTS

We’d like to hear from you!