topic Copy Data from fabric Lakehouse to snowflake in Pipelines

Copy Data from fabric Lakehouse to snowflake

rakeshdasari — Tue, 25 Feb 2025 18:09:09 GMT

Hi Community,
I need to copy data from a fabric lakehouse to snowflake database. What are the different ways I can dump the data?

Thank You!

Re: Copy Data from fabric Lakehouse to snowflake

nilendraFabric — Tue, 25 Feb 2025 21:25:16 GMT

hello rakeshdasari

there are multiple ways to do this.

each way has different tradeoff

Direct pipelines are faster but require staging; external tables avoid copying but require upfront permissions.

OneLake External Tables
Expose Fabric Iceberg tables directly in Snowflake via external volumes for real-time querying without physical data copying.

https://www.snowflake.com/en/blog/microsoft-partnership-enhancing-interoperability

Azure Blob Intermediate
Stage data in Azure Blob Storage first for large/complex datasets, then use Snowflake’s `COPY INTO` to load from Blob (ideal for batch transfers).

Pipeline Copy Activity
Use Fabric’s built-in connector to directly map Lakehouse data to Snowflake via the Copy Data Assistant, requiring manual staging configuration (Azure Blob) for optimal performance.

if this is helpful please accept the answer

Re: Copy Data from fabric Lakehouse to snowflake

Meghamsh_M — Wed, 05 Mar 2025 10:45:16 GMT

Hii nilendraFabric , while connecting to snowflake using copydata activity, I am getting an Authentication issue (Invalid credentials) inspite of providing the valid credentials. Do you know why is this happening?

Re: Copy Data from fabric Lakehouse to snowflake

BrunoR — Fri, 31 Oct 2025 14:20:24 GMT

Hi @nilendraFabric,
I hope I can use this thread for the following problem:
I created a copy job option to copy a lakehouse table to Snowflake and specified my destination table: <my_schema>.<my_table>
The issue is that the copy job try to recreate the schema I provided by running the statement:
"CREATE SCHEMA IF NOT EXISTS ...." in Snowflake.
The copy job ends up thus with a failed status.
The role used (default role for <my_user> ) doesn't allow to create a schema in the given database.
Also I don't get to see "Additional connection properties" in my Snowflake connection (wrong licence type)?
Without it I can't specify a Pre-copy script that might prevent the "create schema" issue.
So I'm kind of stuck.
Is there something else I can do to make my copy job work?