How copy data from Snowflake to Azure SQL using ADF directly, not moving before to Azure blob storage?

Inma 71 Reputation points
2023-11-30T14:42:03.1666667+00:00

I would like to copy data from Snowflake to Azure SQL directly using ADF, but avoiding creating intermediate blob file before loading into Azure SQL database. Any suggestion?

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

Accepted answer
  1. Nandan Hegde 31,346 Reputation points MVP
    2023-12-01T03:26:43.38+00:00

    Basically as per MSFT Docs : https://learn.microsoft.com/en-us/azure/data-factory/connector-snowflake?tabs=data-factory#direct-copy-from-snowflake

    If sink data store and format are natively supported by the Snowflake COPY command, you can use the Copy activity to directly copy from Snowflake to sink.

    Since Azure SQL DB is not supported, you would have to enable a staging layer of Azure blob storage as below flow:

    Snowflake>> Azure blob Staging layer >> Azure SQL database

    you need to enable a staging layer property in copy activity.

    So with ADF native features, it is not possible to load directly.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful