Use one sql statement to create the fruits table with ctas, then copy 'apple' into apples and 'orange' into oranges, yielding apples with two entries and oranges with one.

Uses a single sql statement with Snowflake's multi-table insert, demonstrating insert first for apples, orange entries into oranges, insert all to copy into apples and fruits5, and an else.

Extend the pivot query by adding a gender column with male and female values, creating headers: country, married, male, married female, single male, and single female. Experiment with a second pivoted column to produce four total columns, then compare solutions after testing.

Discover the easiest way to add, delete, or modify table data in snowsight without sql, with the option to type python and hands-on experimentation to test solutions.

Show how to build an in-place data editor for a Snowflake customers table using snowsight, streamlit, and snowpark, transferring edits from a pandas data frame back to Snowflake with write_pandas.

Copy and run setup script to explore Snowflake object dependencies, focusing on views referencing tables, including materialized views and fully qualified names, and render the graph with Streamlit using Graphviz.

Time travel serves data recovery with limitations. Snowflake permanently audits every SQL operation; inspect real-time query history in information schema and use account usage for longer history despite latency.

Build a snowflake challenge: a parent-child hierarchy from an employees table with employee and manager columns, listing each name indented under its manager, with the president as the top node.

Generate one million rows of realistic customer data in Snowflake, explore scalable data generation, label each column by data type, and compare generator and random functions with data governance considerations.