Connecting and Loading data from Snowflake to Azure Synapse

Nnenna 1 Reputation point
2022-11-03T20:48:04.41+00:00

We are having issues connecting our Snowflake data to our Azure Synapse Analytics (Studio [I think]). 256963-errors.png

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,373 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator
    2022-11-06T17:58:35.803+00:00

    Hello @Nnenna ,

    Welcome to the MS Q&A platform.

    Are you using copy activity to load the data from snowflake to Azure synapse(SQL pool)? Could you please provide more details here?

    In general, status code 403 is related to a permissions issue. Were you able to test your snowflake linked server connection in the synapse?


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.