Snowflake Iceburg Table

[lakshmipai]

Hi Team,

I am trying to create Iceburg Table in snowflake for that I am trying to create External volume,to connect to the Microsoft Fabric..I am not able to find the options while creating New DataBase in Snowflake for enabling of iceburgtables option as mentioned in the below document.
So is it publicly available or still in preview.

Snowflake & Microsoft: Enhancing Interoperability with Apache Iceberg

[v-nikhilan-msft]

Hi @lakshmipai 
Thanks for using Fabric Community.

Creating Iceberg tables in Snowflake involves several steps:

Create Users and Roles:
You need to have the necessary permissions to create and manage Iceberg tables.
How to Create Iceberg Tables in Snowflake | phData

Create an External Volume in Snowflake:
An external volume is a named, account-level Snowflake object that you use to connect Snowflake to your external cloud storage for Iceberg tables. For instructions on creating an external volume, you can refer to the Snowflake documentation.
Getting Started with Iceberg Tables (snowflake.com)
Create an Iceberg table | Snowflake Documentation

Create Iceberg Tables in Snowflake:
You can create an Iceberg table by using the CREATE ICEBERG TABLE command. To define table columns, you can use Iceberg data types.
Snowflake & Microsoft: Enhancing Interoperability with Apache Iceberg
Iceberg Tables in Snowflake. Iceberg Tables in Snowflake are in… | by Feng Li | Snowflake Builders B...

As for your question about the availability of Iceberg tables in Snowflake, as of the latest information, Iceberg Tables in Snowflake are in public preview. Please note that the availability status might change, and it’s always a good idea to check the latest Snowflake documentation or announcements for the most up-to-date information.

Hope this helps. Please let me know if you have any further questions.

[lakshmipai]

Hi @v-nikhilan-msft 

These all documents are related to AWS S3,GCS,Azure Storage..I am trying to implememt same concept for Fabric.can you assist on that.

[v-nikhilan-msft]

Hi @lakshmipai 
Please refer to this document :
https://datamonkeysite.com/2023/12/16/reading-snowflake-iceberg-table-using-fabric-onelake/

Hope this helps.

[lakshmipai]

Hi @v-nikhilan-msft 

Thank you for your response.

I need a cliarification,you created iceberg table into datalake storage,then you created shortcut to the lakehouse you are able to access data in notebook that part I got clarified....so as of now can't we create directly into lakehouse.
Snowflake & Microsoft: Enhancing Interoperability with Apache Iceberg,but in this screen  I am able to see Microsoft Fabric option while creating Database in the snowflake db

Thanks& Regdars,

P.Lakshmi

[v-nikhilan-msft]

Hi @lakshmipai 
Apologies . This question is more related to Snowflake rather than MS Fabric. I would request you to create a support ticket with the Snowflake team for more help.
Thanks