Set Up an External Data Source

  • how-to
    +
    To provide query access to data that resides in external object storage, you create an external link and associate it with an external collection.

    Supported External Sources

    Enterprise Analytics supports external links to data in Amazon S3 and S3-compatible object stores. This data remains in the S3 bucket—​Enterprise Analytics does not copy it into a collection. You can query Delta tables residing in S3 buckets, or S3 files that are in 1 of the following formats:

    • JSON

    • CSV

    • TSV

    • Parquet

    • Avro

    Enterprise Analytics uses different types of links to store credentials for accessing different types of data sources. You can use the UI to create links.

    To create a link with an SDK, note the following:

    • External: in an SDK, you use the S3ExternalAnalyticsLink class and then the AnalyticsIndexManager class to create the link.

    For more information about data sources, see Access and Organize Data in Enterprise Analytics.