topic Snowflake iceberg table connection Issue in Data Engineering

Snowflake iceberg table connection Issue

chetanhiwale — Tue, 01 Jul 2025 10:57:10 GMT

Hi folks,

Currently I am trying to setup Snowflake iceberg table which can be read in onelake. But getting the following error while creating iceberg table in snowflake.
Table query :

CREATE OR REPLACE ICEBERG TABLE snowflakeQS.ICEBERGTEST.dim_customer (
C_CUSTKEY STRING,
C_NAME STRING,
C_ADDRESS STRING,
C_NATIONKEY STRING,
C_PHONE STRING,
C_ACCTBAL STRING,
C_MKTSEGMENT STRING,
C_COMMENT STRING
)
EXTERNAL_VOLUME = 'FabricVolEastUS2'
CATALOG = snowflake
BASE_LOCATION = 'dim_customer';

error message : Fabric capacity region cannot be validated. Reason: 'Invalid access token. This may be due to authentication and scoping. Please verify delegated scopes.'.

As part of setup ,
Fabric :-

1. Fabric Capacity and snowflake are in same region (East US2)

2. Newly created Service permission created while providing consent is given admin role in workspace.

3. Properties enabled from Fabric Admin level

a. Authenticate with OneLake user-delegated SAS tokens, enabled at Fabric Workspace and Fabric tenant level.

b. Users can access data stored in OneLake with apps external to Fabric.

c. Use short-lived user-delegated SAS tokens (preview).

d.Users can sync data in OneLake with the OneLake File Explorer app.

From snowflake side,
Code to create volume ,
CREATE OR REPLACE EXTERNAL VOLUME FabricVolEastUS2
STORAGE_LOCATIONS =
(
(
NAME = 'FabricVolEastUS2'
STORAGE_PROVIDER = 'AZURE'
STORAGE_BASE_URL = 'azure://eastus2-onelake.dfs.fabric.microsoft.com/iceberg_poc/iceberg.Lakehouse/Files/iceberg'
AZURE_TENANT_ID = <tenant-id>
)
);
I am following this article ,
https://quickstarts.snowflake.com/guide/getting_started_with_iceberg_in_oneLake/index.html#0

Any ideas , on why this its giving the error !!

Re: Snowflake iceberg table connection Issue

v-priyankata — Wed, 02 Jul 2025 07:20:19 GMT

Hi @chetanhiwale

Thank you for reaching out to the Microsoft Fabric Forum Community.

We have an official document on this topic. Please review the document below, as it may be helpful to you.
Use Iceberg tables with OneLake - Microsoft Fabric | Microsoft Learn

Thanks.

Re: Snowflake iceberg table connection Issue

chetanhiwale — Wed, 02 Jul 2025 07:29:08 GMT

Hi @v-priyankata ,

I have already referenced this document, still I am getting the error. I have noticed, documentation provides a solution for my error, but it doesnt worked in my case. Please share if there are any updates or documentation available.

Thanks , looking forward for your response.

Re: Snowflake iceberg table connection Issue

v-priyankata — Thu, 03 Jul 2025 10:37:17 GMT

Hi @chetanhiwale

We regret the inconvenience caused, If the document contains a solution but it still isn't working for you, Please consider raising a Microsoft support ticket for further investigation. You can explain all the troubleshooting steps you have taken to help them better understand the issue.

You can create a Microsoft support ticket with the help of the link below:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Thanks.

Re: Snowflake iceberg table connection Issue

v-priyankata — Mon, 07 Jul 2025 12:46:36 GMT

Hi @chetanhiwale
Hope you have raised the support ticket & solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.

Thank you for your understanding and assistance.

Re: Snowflake iceberg table connection Issue

BhaveshPatel — Tue, 08 Jul 2025 09:22:58 GMT

For that, You should always use Lakehouse and then Azure Data Lake Storage Gen II ( Storage only )

Also, use shortcut.

I don't currently have permission rights to login into Azure Data Lake Storage Gen 2.

( always use dfs and not wasb in ADLS Gen 2 )