DDL – Snowflake Guide

ALTER TABLE … RECLUSTER is Classified as DML, not DDL

Posted on 13 November 202024 May 2021 by Eric Lin

We all know that ALTER TABLE is a DDL (Data Definition Language), not a DML (Data Manipulation Language), because ALTER TABLE only changes metadata information about a table, like adding a new column, or changing existing column names.. If you are unsure about the differences between DDL and DML, please refer to this page on […]

Fully Qualified Name in GET_DDL

Posted on 13 November 202024 May 2021 by Eric Lin

By default, GET_DLL function in Snowflake will return TABLE or VIEW without database and schema path. Please see example below: The result is below: You can see that the table name GET_DDL_TEST returned without Database and Schema info. This could be problematic if user is relying on the output to re-create tables or views, and […]