Snowflake for Beginners

Snowflake for Beginners – Describe A Table

Hits: 4 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: 6 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: 131 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: 8 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: 3 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: 6 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 – 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 …

Snowflake for Beginners – Sort Rows By A Column’s Values

Hits: 11 Sort Rows By A Column’s Values Create Table Of Superheroes – Create a table called SUPERHEROES. CREATE OR REPLACE TABLE SUPERHEROES ( – Column called ALTER_EGO allowing up to 100 characters “ALTER_EGO” VARCHAR(100), – Column called BANK_BALANCE allowing 38 digits with 2 after the decimal point “AGE” INT, – Column called STATE allowing …

Snowflake for Beginners – Add Column

Hits: 4 Add 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 – Add Comment To Column

Hits: 113 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 …