Snowflake Must Know New Objects | Chapter-8 | Snowflake Hands-on Tutorial

This tutorial & chapter 8, "Snowflake Must Know New Objects" guides on all those snowflake account level and database level objects that a data developer and lead must know. These objects are not very common across other data warehouse system and snowflake has introduced them with a specific purpose.

Many of us use snowflake as if it is another data warehouse system and only focus on writing SQL statements, stored procedures, or functions (or UDFs). Snowflake has many new objects and knowing their purpose and their power will help you to save a lot of time and also optimize your cost and solution. These new objects not only help to build faster data solutions but also help to build easier and simple ETL or ELT data pipelines.

This hands on visual guide covers following, most important and very frequently used snowflake objects with live examples
1. Sequence Objects,
2. File Formats,
3. Stage Objects
4. Integration Objects
5. Pipe Objects
6. Stream & task Objects
7. Resource monitor

So enjoy this video series and provide your valuable feedback.

🚀 🚀 Chapters 🚀 🚀
-----------------------------------------
➥ 00:00 What so special about snowflake new objects
➥ 01:08 Welcome Note
➥ 01:43 Covered in this Chapter 08
➥ 02:06 Sub topics & tree map
➥ 03:05 Why to subscribe this channel
➥ 04:16 Live Demo - Sequence Objects
➥ 09:16 Live Demo - File Format Objects
➥ 15:18 Live Demo - Stage Objects
➥ 21:08 Live Demo - Integration Objects
➥ 23:14 Live Demo - Pipe Objects
➥ 27:14 Live Demo - Stream Objects
➥ 31:37 Live Demo - Task Objects
➥ 34:42 Live Demo - Resource monitor
➥ 40:03 Quick Recap of tree map
➥ 40:03 Thank you note & next chapter

🚀 🚀 Snowflake Tutotorials (Beginners) All Episodes 🚀🚀
---------------------------------------------------------------------------------------------------
➥ Chapter-25 (Part-1) Snowflake & PowerBI Reporting 🌐 coming-soon
➥ Chapter-25 (Part-2) Snowflake & Tableau Reporting 🌐 coming-soon

🚀 🚀 Snowflake Certification Complete Guide & Question Dump 🚀 🚀
-----------------------------------------------------------------------------------------------------------------

#snowflaketutorial #snowflakeobjects #snowflakecomputing #snowflakedatawrehouse #snowflake #dataengineeringsimplifed #DESimplified#toppertips #snowflakefeatures

[EricVanWinkle]

Started learning about Snowflake just as I got caught up in a RIF. Thankfully, I can use my personal email for a trial and use your tutorials (and the documentation) to get the best value out of my training. Thanks!

[shashankreddysai]

perfect explanation of objects, earlier they were confusing, now its clear what object is used for what. Thank you.

[sketchstudios]

work you have done by creating these tutorials in overwhelming.

[pratikparbhane]

I am seeing your videos like web series 😍

[NagendraDataEngineeringWorld]

This is the most enjoyable snowflake learning cource in the market with detailed level of so much sir😍

[mohamdhaji]

Great video that summarize some good aspects in snowflakes. thanks! and well done.

[derekeichman]

Very nice tutorial! Really thorough and clearly explained in a quick-paced manner.

I couldn't find the example SQL anywhere on your website, and see that this was going to be fixed in comments below. It would be very helpful if we could find it on the website.

Thanks again!

[pk-wanderluster]

Thank you for making videos. Content is very rich! Many thanks!!

[elamaranravichandran]

👏Well done!
Great work and a big thank you for sharing it

[joshipodili]

Thank you very much, i have attended many videos classes, i have experienced crystal clear explanation.Thank you is very less...gratitude

[pundrikaxhtripathi]

Wonderful video, thanks for this, good refresher video for key feature and objects. was not able to find the exact path for the sql used in this chapter so created sql which can be used by others if needed. hope this helps others.

"create or replace sequence demo_db.public.sales_sequence start = 1 increment = 1;
create or replace table
tx_key number default demo_db.public.sales_sequence.nextval,
product_id int,
product_desc varchar(),
category varchar(10),
segment varchar(20),
manufacture varchar(50),
purchase_date date,
zip varchar(),
units int,
revenue decimal(10, 2)
);

use role sysadmin;
create or replace database my_db_08 comment = 'database for chapter 8';
create schema my_schema_08 comment= 'schema for chapter 8';

create or replace sequence seq_01 start =1 increment=1 comment='this is trial sequence';
create or replace sequence seq_02 start =1 increment=2 comment='this is trial sequence';
create or replace sequence seq_03 start =0 increment=-2 comment='this is trial sequence with negative increment';

select seq_01.nextval, seq_02.nextval, seq_03.nextval, my_seq_00.nextval ;

create or replace table my_tbl_01
(i integer);


create or replace table my_tbl_02
(
pk int autoincrement,
seq1 int default seq_01.nextval,
seq2 int default seq_02.nextval,
seq3 int default seq_03.nextval,
msg string
);

desc table my_tbl_02;

select get_ddl('table', 'my_tbl_02');

insert into my_tbl_02(msg) values('msg-1');
select * from my_tbl_02;

show sequences;
show sequences like '%01';

select get_ddl('sequence', 'seq_03');


Format

create or replace file format my_format type = 'csv' field_delimiter = ', ';

create table customer_csv
(
customer_key integer,
name string,
address string,
country_key string,
phone string,
acct_bal decimal,
mkt_segment string,
comment string
);

select * from customer_csv;

select get_ddl('file_format', 'csv_ff');


objects

--create stg object as CUSTOMER_CSV_STG thru web ui
--go to snow sql

;

list @CUSTOMER_CSV_STG;

--file can be copied into stage by subdir like below

;

copy into customer_csv
from
file_format=(type=csv) on_error=continue;

select * from customer_csv;


object
;
use role accountadmin;

create or replace storage integration s3_integration
type = external_stage
storage_provider = s3
storage_aws_role_arn = 'provide arn iam role here from aws'
enabled='true'
storgae_allowed_loacation= ('s3://mubucket1/path1', 's3://mubucket1/path2');

show integrations;

--

use role sysadmin;
show pipes;

select get_ddl('pipe', 'my_pipe')

create or replace pipe MY_PIPE auto_ingest=false comment='this is my 1st pipe to load a small chunk of data' as
COPY INTO
FROM
FILE_FORMAT = ( FORMAT_NAME = );

select system$pipe_status('my_pipe')
;

select * from CUSTOMER_CSV;


--


create or replace stream
customer_stream on table customer_csv;

select * from customer_csv order by customer_key desc;

select * from customer_stream;

update customer_csv set name='alan' where customer_key=3;
insert into customer_csv select * from customer_csv where customer_key=1;

show streams ;

select get_ddl('stream', 'customer_stream');

--

;
create or replace task my_task
warehouse = compute_wh
schedule = '5 minute'
as
select current_date;



create or replace task my_task_insert
warehouse = compute_wh
schedule = '5 minute'
when

as
insert into customer_01 select * from customer_01 where customer_key =1 ;


"

[sireeshap]

Thanks for sharing. Your videos are very helpful.

[ratnakaligatla]

Thank you so much. This is so great to understand.
Please give Interview questions on Snowflake. I'm going to try job on informatica along with Snowflake

[swapnakarnati]

Thanks for detailed tutorial. Could you please make CSV, ORC, Parquet, JSON files available for us and also please share information on how to use snowSQL?

[kawkawshiSan]

Love your videos, Thank you & keep up the awesome work!
Can you suggest any place where I could find scenario based questions for the SnowPro Cert Exam?

[cbdinesh]

Amazing videos, thanks for making these 👍👍

[visshalgupta]

Hi Loved your videos, Any chance for your series on snowpark and tips to look for the new snowpro certification . Thanks in advance

[vijju]

Amazing content and great explanation and coverage of topics. Is there a way I can get Sub Topics and tree map soft copy ? TIA

[divya-wy]

this is an excellent course. However, without SQLs handy (for practice) it's hard to remember what we learned.

[MahathiKodicherla-kw]

Hello, great explanation. Where can I find the tree map in the website?