#data bricks snowflake dialect

[jadhav_vikas]

Hello,
I’m encountering an issue while converting SQL code to the Lake bridge Snowflake dialect. It seems that DML and DDL statements may not be supported in the Snowflake dialect within Lake bridge.
Could you please confirm whether DML and DDL statements are supported in the Lake bridge Snowflake dialect, and if so, how they can be executed?

[szymon_dybczak]

Hi @jadhav_vikas ,

Looking at lakebridge source code, particularly on their test section it seems that is should support DDL and DML statements for Snowflake. Did you get any error or it just didn't work?

[jadhav_vikas]

Hi @szymon_dybczak

As per my understanding and testing, Lake bridge currently does not support DDL or DML statements for the Snowflake dialect.
Only read or query operations are supported at this time.
Please let me know if you have any recent updates or documentation indicating otherwise.

I have attached a snapshot that shows the converted code and the corresponding output.

[szymon_dybczak]

Hi@jadhav_vikas ,

I'll try to use it after work and I'll let you know if it works. 

[jadhav_vikas]

okay sure @szymon_dybczak  
Thanks for understanding