Snowflake for Beginners

Snowflake for Beginners – Describe A Table

Hits: 2 Describe A Table Create Table Of Superheroes – Create a table called SUPERHEROES. If it already exists, replace it. CREATE OR REPLACE TABLE SUPERHEROES ( – Column called ID allowing up to five characters “ID” VARCHAR(5), – Column called NAME allowing up to 100 characters “NAME” VARCHAR(100), – Column called ALTER_EGO allowing up …

Snowflake for Beginners – Drop Column

Hits: 0 Drop Column Create Table Of Superheroes – Create a table called SUPERHEROES. If it already exists, replace it. CREATE OR REPLACE TABLE SUPERHEROES ( – Column called ID allowing up to five characters “ID” VARCHAR(5), – Column called NAME allowing up to 100 characters “NAME” VARCHAR(100), – Column called ALTER_EGO allowing up to …

Snowflake for Beginners – Query DESCRIBE TABLE like a table

Hits: 1 Query DESCRIBE TABLE like a table   DESCRIBE TABLE is a powerful tool for understanding the structure of a table. However, in Snowflake the output of DESCRIBE TABLE is not treated like a regular table (i.e. can be manipulated using SELECT). To query DESCRIBE TABLE as a regular table we have to first run it, then run a SELECT query on …

Snowflake for Beginners – Rename Column

Hits: 4 Rename Column Create Table Of Superheroes – Create a table called SUPERHEROES. If it already exists, replace it. CREATE OR REPLACE TABLE SUPERHEROES ( – Column called ID allowing up to five characters “ID” VARCHAR(5), – Column called NAME allowing up to 100 characters “NAME” VARCHAR(100), – Column called ALTER_EGO allowing up to …

Snowflake for Beginners – Undelete A Table

Hits: 1 Undelete A Table Create Table Of Superheroes – Create a table called SUPERHEROES. If it already exists, replace it. CREATE OR REPLACE TABLE SUPERHEROES ( – Column called ID allowing up to five characters “ID” VARCHAR(5), – Column called NAME allowing up to 100 characters “NAME” VARCHAR(100), – Column called ALTER_EGO allowing up …

Snowflake for Beginners – View A Column’s Comments

Hits: 2 View A Column’s Comments Create Table Of Superheroes With Comments Column comments concern a particular column, while table comments are about the entire table. – Create a table called SUPERHEROES. If it already exists, replace it. CREATE OR REPLACE TABLE SUPERHEROES ( – Column called ID allowing up to five characters with a …

Snowflake for Beginners – View A Table’s Comments

Hits: 1 View A Table’s Comments Create Table Of Superheroes With Comments Column comments concern a particular column, while table comments are about the entire table. – Create a table called SUPERHEROES. If it already exists, replace it. CREATE OR REPLACE TABLE SUPERHEROES ( – Column called ID allowing up to five characters with a …

Snowflake for Beginners – Add Comment To Column

Hits: 3 Add Comment To Column Create Table Of Superheroes – Create a table called SUPERHEROES. If it already exists, replace it. CREATE OR REPLACE TABLE SUPERHEROES ( – Column called ID allowing up to five characters “ID” VARCHAR(5), – Column called NAME allowing up to 100 characters “NAME” VARCHAR(100), – Column called ALTER_EGO allowing …

Snowflake for Beginners – Create Table

Hits: 4 Create Table Create Table – Create a table called SUPERHEROES. CREATE TABLE SUPERHEROES ( – Column called ID allowing up to five characters “ID” VARCHAR (5), – Column called NAME allowing up to 100 characters “NAME” VARCHAR(100), – Column called ALTER_EGO allowing up to 100 characters “ALTER_EGO” VARCHAR(100), – Column called BANK_BALANCE allowing …

Snowflake for Beginners – Create Table With Column And Table Comments

Hits: 2 Create Table With Column And Table Comments Create Table Of Superheroes With Comments Column comments concern a particular column, while table comments are about the entire table. – Create a table called SUPERHEROES. If it already exists, replace it. CREATE OR REPLACE TABLE SUPERHEROES ( – Column called ID allowing up to five …

Snowflake for Beginners – Create Temporary Table

Hits: 2 Create Temporary Table Create Temporary Table The temporary table will last until the session ends. – Create a table called SUPERHEROES. CREATE OR REPLACE TEMP TABLE SUPERHEROES ( – Column called ID allowing up to five characters “ID” VARCHAR (5), – Column called NAME allowing up to 100 characters “NAME” VARCHAR(100), – Column …

Snowflake for Beginners – Delete A Table

Hits: 2 Delete A Table Create Table Of Superheroes – Create a table called SUPERHEROES. If it already exists, replace it. CREATE OR REPLACE TABLE SUPERHEROES ( – Column called ID allowing up to five characters “ID” VARCHAR(5), – Column called NAME allowing up to 100 characters “NAME” VARCHAR(100), – Column called ALTER_EGO allowing up …