SleekData

  Hello Data Pros, and welcome back to another exciting episode of our Snowflake learning series! In our previous video, we explored advanced table types, with easy-to-follow examples along the way. Today, we'll take a step forward to understand the different types of views in Snowflake, along with their use cases and practical examples! Just like tables and stages, views are also database objects, that allow the result of a SELECT query to be accessed as if it were a table. The SELECT query is specified in the CREATE VIEW DDL statement. It's worth noting that we cannot perform any DML operations such as insert, update, and delete directly on views. However, any DML operations performed on the underlying tables are always reflected in the views. --                  Views LAB - Non-materialized views, Materialized views, Secure Views                 -- --             ...

Hello Data Pros, welcome back to another exciting episode of our Snowflake learning series! In our previous video, we’ve dived deep into three main snowflake table types: permanent, temporary, and transient. Today, we'll move forward, and learn about 6 additional table types available within the Snowflake platform and their specific use cases! Snowflake External Table Snowflake Iceberg Table Snowflake Dynamic table Snowflake Hybrid Table Snowflake Event Table Snowflake Directory Table --  External Tables, Iceberg Tables, Dynamic tables, Hybrid Tables, Event Tables, Directory Tables  -- --             All commands/statements can be found via the link in the video description           -- -- <<<<<<<<<<<<< External Tables >>>>>>>>>>>>> -- CREATE OR REPLACE STAGE oms_ext_stg   URL = 's3://s3e...

Provider: -- Create Database CREATE DATABASE exchange_rates_db ; -- Use Database USE DATABASE exchange_rates_db ; -- Create Schema CREATE SCHEMA exchange_rates_schema ; -- Create Table CREATE TABLE exchange_rates_schema . exchange_rates (     date DATE ,     currency_from VARCHAR ( 3 ),     currency_to VARCHAR ( 3 ),     exchange_rate NUMBER ); -- Insert Rows INSERT INTO exchange_rates_schema . exchange_rates ( date , currency_from , currency_to , exchange_rate ) VALUES     ( '2023-06-01' , 'USD' , 'EUR' , 0 . 89 ),     ( '2023-06-01' , 'USD' , 'GBP' , 0 . 78 ),     ( '2023-06-01' , 'USD' , 'JPY' , 109 . 50 ),     ( '2023-06-01' , 'EUR' , 'USD' , 1 . 12 ),     ( '2023-06-01' , 'GBP' , 'USD' , 1 . 28 ),     ( '2023-06-01' , 'JPY' , 'USD' , 0 . 0091 ),     ( '2023-06-01' , 'EUR' , 'GBP' , 0 . 91 ),     ( ...