Write Iceberg table using Fabric Dataengineering

[msprog]

Hi,

Can i create a Iceberg table in the datalake  using the Fabric Data engineering experiences? is this supported? if so, any guidance on how i can use my notebook to create an Iceberg table pelase

thanks

[v-tsaipranay]

HI @msprog ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. 

Thank you.

[v-tsaipranay]

Hi @msprog ,

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

As @chetanhiwale  mentioned, Microsoft Fabric supports working with Iceberg-compatible tables by virtualizing Delta Lake tables. Currently, creating native Apache Iceberg tables directly through notebooks in Fabric is not supported. Instead, you can achieve Iceberg compatibility by saving your tables in Delta Lake format and enabling the "Delta Lake to Apache Iceberg table format virtualization" preview feature within your workspace’s OneLake settings.

This feature enables Delta Lake tables to be accessed as Iceberg tables, making it easier to integrate with external engines like Snowflake, while keeping the original storage format unchanged Please note that writing directly with format("iceberg") is not supported, since Fabric’s runtime does not allow direct writes to Iceberg tables or recognize an Iceberg catalog context.

For detailed official guidance, please refer to the Microsoft Learn documentation below:

Use Iceberg tables with OneLake - Microsoft Fabric | Microsoft Learn

I hope this helps, if you need any further assistance, feel free to reach out.

Thank you.

[chetanhiwale · Accepted solution]

There are multiple ways to create a iceberg table, assuming destination as Onelake. 
1. Enable onelake setting to treat delta tables as Iceberg tables, this feature is in preview. You can enable this feature by going to workspace setting - > onelake setting -> Enable Delta Lake to Apache Iceberg table format virtualization (preview)

2. If you want to create iceberg table in snowflake and want to reside the data in onelake, you can follow the following article . 
Link : Getting Started with Iceberg in OneLake
Although, some permissions are not mentioned which are essential to create connection between snowflake and fabric. I have raised the issue on the link, you can check this link : Re: Snowflake iceberg table connection Issue - Microsoft Fabric Community

3. The first method, automatically converts exisiting and newly created tables in iceberg format, if you want to do same using code, you can follow the article. 
Link :Microsoft Fabric: Working with Apache Iceberg without shortcutting to the Iceberg Tables | by Christ...