Need Guidance on Loading Data from Amazon Athena to Azure SQL via ADF Linked Service Issue

ClarissaJacquline 200 Reputation points
2023-11-22T20:09:23.6833333+00:00

I attempted to load data from Amazon Athena to Azure SQL, but I’m unable to locate the linked service. Any insights or information on how to accomplish data loading from Amazon Athena to Azure SQL using Azure Data Factory would be greatly appreciated. Currently, I can’t find a connector in ADF linked service. How can we establish a connection from Athena to Azure SQL using ADF?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,130 questions
{count} votes

Accepted answer
  1. Harishga 5,910 Reputation points Microsoft Vendor
    2023-11-23T12:36:00.4366667+00:00

    Hi ClarissaJacquline
    Welcome to Microsoft Q&A platform and thanks for posting your question here.
    There is no connector for Amazon Athena in ADF Linked Service, and one possible workaround is to save your data into files in an S3 bucket and then copy them to Azure Blob Storage using ADF, and then move them to Azure SQL Database. 

    Use the Amazon S3 Compatible Storage connector in ADF to copy data from Amazon Athena to Azure Blob Storage or Azure Data Lake Storage Gen2, and then use the Azure SQL Database connector in ADF to copy data from Azure Blob Storage or Azure Data Lake Storage Gen2 to Azure SQL.

    Reference:
    https://learn.microsoft.com/en-US/azure/data-factory/connector-amazon-s3-compatible-storage?tabs=data-factory

    I hope this information helps you. Let me know if you have any further questions or concerns.


0 additional answers

Sort by: Most helpful