thanks a lot for your content. here I have a doubt in the select query flatten the data. select c.key, c.value from customer_par, lateral flatten(input => my_data)c; here what is my_data attribute?
Thank you so much 😀.. your word of appreciation really means a lot to me... Never thought that it would so helpful to all of you.. really happy to hear
Hi,We unable to see the codes which ur earlier provided...and when we click the topper tips path its showing under maintenance..could you please look into fix as soon as possible...it will help who is learning
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!
I tried to use pipe with azure storage but it is work with storage integration..it only worked when I created notification integration with azure queue service for the storage endpoint
that is true.. if you have cloud provider, then notification service is must to trigger Pipe..and if you want to work without notification.. then you have to watch ch-10 (ua-cam.com/video/PNK49SJvXjE/v-deo.html) of this playlist.
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 demo_db.public.sales_consumption( 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'); -----File 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'); ------stage objects --create stg object as CUSTOMER_CSV_STG thru web ui --go to snow sql PUT file:///Users/pundrikaxhtripathi/documents/snowflake/customer_csv.csv @CUSTOMER_CSV_STG; ; list @CUSTOMER_CSV_STG; --file can be copied into stage by subdir like below PUT file:///Users/pundrikaxhtripathi/documents/snowflake/customer_csv.csv @CUSTOMER_CSV_STG/csv; ; copy into customer_csv from @customer_csv_stg/customer_csv1.csv file_format=(type=csv) on_error=continue; select * from customer_csv; ------integration 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; -- _____________Pipes________ --------------------- 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 "MY_DB_08"."MY_SCHEMA_08"."CUSTOMER_CSV" FROM @"MY_DB_08"."MY_SCHEMA_08"."CUSTOMER_CSV_STG" FILE_FORMAT = ( FORMAT_NAME = "MY_DB_08"."MY_SCHEMA_08"."CSV_FF" ); select system$pipe_status('my_pipe') ; select * from CUSTOMER_CSV; -- _____________Stream_______ --------------------- 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'); -- _____________Task_______ --------------------- ; 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 system$stream_has_data('customer_stream') as insert into customer_01 select * from customer_01 where customer_key =1 ; "
The snowsight is not the default webui for snowflake and the legacy WebUI is no more accessible. If you have an account that has been created long back, there is a thin chance that you can access it but now snowflake is directing all their users to Snowsight.
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?
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?
Thank you 🙏 @Kakashi for watching my video and your word of appreciation really means a lot to me. SnowPro core does not ask scenario bassed questions, so you don't have to worry about it. The situation based questions come in advance snow certification. Refer my pracrice test in this playlist (SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E) ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡ I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them. 🌐 Snowflake Complete Guide Playlist ➥ bit.ly/3iNTVGI 🌐 SnowPro Guide ➥ bit.ly/35S7Rcb 🌐 Snowflake SQL Series Playlist ➥ bit.ly/3AH6kCq 🌐 SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
@@kawkawshiSan youtube comment is the only way that I can exchange notes. Maybe in the future, I will find a better way to serve my audience. Feel free to drop any query and I will check and respond.
Hi can you please help me to export query results into text file with out using CLI, like in Oracle we have spool option. is there any option in Snowflake
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!
Thank you for all your Snowflake videos.I am a beginner and i just watched this video. Could you please provide some more insight on how to use sub directory in stage for CDC data capture? Thank you :)
CDC subdirectory in snowflake is just a context so if you have to push data to marking by date.. you can say maketing/01-jan-2022/my-data.csv .. the stage will automatically create it.. Watch the ch-9 and you will understand it. ua-cam.com/video/lI5OQPjuj-8/v-deo.html
@@DataEngineering Thank you so much :) I just completed watching videos until Chapter-8 and will now proceed with the remaining chapters. Expecting you to upload the remaining chapter videos . Thank you for all your hard work and this greatly helps people like me.!!
Thank you 🙏 for watching my video @ Nakul Deshpande , and your word of appreciation really means a lot to me. ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡ I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them. 🌐 Snowflake Complete Guide Playlist ➥ bit.ly/3iNTVGI 🌐 SnowPro Guide ➥ bit.ly/35S7Rcb 🌐 Snowflake SQL Series Playlist ➥ bit.ly/3AH6kCq 🌐 SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
Hello sir, Can you help with correct ans for this Will these queries be considered as same to get the benefit of the Query Result cache? Query 1 : SELECT * FROM t1; Query 2 : select * FROM t1;
yes it will use the query cache and actually, you can try that youself. Dont have any warehouse and just run the query and go to query profile and see if it has used the query cache or not.
came across this question , need 1 correct answer . Will data cached in a warehouse be lost when the warehouse is resized? 1.Possibly, if the warehouse is resized to a smaller size and the cache no longer fits. 2.Yes. because the compute resource is replaced in its entirety with a new compute resource. 3.No. because the size of the cache is independent from the warehouse size 4.Yes. became the new compute resource will no longer have access to the cache encryption key
Snowflake does not clearly say how they have implemented the resizing under the hood... so in my opinion the option(1) is the right answer.. Option(2) is very unlikely.. that is not mentioned anywhere in their documentation. Option(3) - This is definitely not. Option(4) - This is not true. @rajeev, Let me know if you have a different view
Thank you 🙏 @Kadamp for watching my video and your word of appreciation really means a lot to me. ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡ I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them. 🌐 Snowflake Complete Guide Playlist ➥ bit.ly/3iNTVGI 🌐 SnowPro Guide ➥ bit.ly/35S7Rcb 🌐 Snowflake SQL Series Playlist ➥ bit.ly/3AH6kCq 🌐 SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
Not exactly.. pipe is an object that runs a copy command and it is a wrapper object that can be triggered automatically based on configuration and move the delta files kept in stage location by running or re-running copy command. Future chapter covers this topic in detail.
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
if the pipe is in running status and filecount is 0 will it consume any credits for that ?, or only credit comes into picture only when the new file arrival?
Snowflake pipe is serverless component and it is hard to calculate its actual price when it is just listening but not consuming data... that goes to your overall cloud service pricing. The pipe price can be checked from information schema table for that I would request to watch my information schema video - ch-22 (ua-cam.com/video/kqZRXoFcKo0/v-deo.html)
Snowpark is in my list.. for snowpro... specially for new certification.. you can watch my playlist if not seen so far.. ua-cam.com/play/PLba2xJ7yxHB5X2CMe7qZZu-V4LxNE1HbF.html
You are most welcome Thank you 🙏 for watching my video and your word of appreciation really means a lot to me. ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡ I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them. 🌐 Snowflake Complete Guide Playlist ➥ bit.ly/3iNTVGI 🌐 SnowPro Guide ➥ bit.ly/35S7Rcb 🌐 Snowflake SQL Series Playlist ➥ bit.ly/3AH6kCq 🌐 SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
Not available for all the chapter.. will see how can I do it.. ---- and yes, I know many of us are not fully aware of snowpark Python API, if you want to manage snowflake more programatically.. you can watch my paid contents (data + code available) .. many folks don't know the power of snowpark... these 2 videos... will help you to broaden your knowledge.. These contents are available in udemy.. (one for JSON and one for CSV).. it can automatically create DDL and DML and also run copy command... 1. www.udemy.com/course/snowpark-python-ingest-json-data-automatically-in-snowflake/ 2. www.udemy.com/course/automatic-data-ingestion-using-snowflake-snowpark-python-api/
There is a work around. you can generate the data from snowflake sample data. Use the below script then download the data in your local machine: SELECT C_NAME,C_ADDRESS,C_NATIONKEY,C_PHONE,C_ACCTBAL,C_MKTSEGMENT, C_COMMENT FROM SNOWFLAKE_SAMPLE_DATA.TPCH_SF1.CUSTOMER
There;s one mistake on 21:36 stating "Integration object can only be created on Account admin role". But, I think it can be created by different roles as well...I dont have account admin access but still I can create storage integration object. COrrect me if I am wrong...
Your role might have got grants to create integration object... but in general accoutadmin can only create integration objects as this is account level object and not database/schema level object.
👏Well done! Great work and a big thank you for sharing it. I have reached this chapter and intend to finish them all. Q : Where can we find the SQL codes and data files used in the sample and tuto ? Thank you
Thank you 🙏 for watching my video and your word of appreciation really means a lot to me. Find the code link in description of respective video. (toppertips.com/) ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡ I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them. 🌐 Snowflake Complete Guide Playlist ➥ bit.ly/3iNTVGI 🌐 SnowPro Guide ➥ bit.ly/35S7Rcb 🌐 Snowflake SQL Series Playlist ➥ bit.ly/3AH6kCq 🌐 SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
@@DataEngineering thank you for your answer. I meant : The respective code of each video I watch on youtube. For example, I cannot find the correspondence on the site of the code used in this present video: "Snowflake Must Know New Objects | Chapter-8 | Snowflake Hands-on Tutorial". And where is the matching code on the site ..how to find it. I don't understand how to find it..? And once more .. very good videos and samples !
@@DataEngineering Thank you very much. In desperate need to have handson. Till now going through has been a start even though I am totally new, at least it's making me to stay float. Thanks a lot!
You are so welcome you can also explore my udemy courses www.udemy.com/course/automatic-data-ingestion-using-snowflake-snowpark-python-api/?couponCode=NEW-YEAR-2024 www.udemy.com/course/snowpark-python-ingest-json-data-automatically-in-snowflake/?couponCode=NEW-YEAR-2024 www.udemy.com/course/snowflake-dynamic-table-masterclass-e2e-data-pipeline/?couponCode=AC7896594913CDFA6155
Thank you so much 😀. Thank you 🙏 for watching my video @BRIGHT SPARK and your word of appreciation really means a lot to me. Do let me if you find the entire series meaningful or only this video "Snowflake Tutorial bit.ly/3iNTVGI"
thank you for this great video but can you please add a link for every specific video to find the resources used I can't find them on the website
will release the SQLs soon.. via my website..
thanks a lot for your content. here I have a doubt in the select query flatten the data. select c.key, c.value from customer_par, lateral flatten(input => my_data)c; here what is my_data attribute?
my_data is a variant column in the table and flatten works with variant data type.
I am seeing your videos like web series 😍
Thank you so much 😀.. your word of appreciation really means a lot to me... Never thought that it would so helpful to all of you.. really happy to hear
@@DataEngineering from where can we get the data you have used one thing is missing unable to find data source you add please
Hi,We unable to see the codes which ur earlier provided...and when we click the topper tips path its showing under maintenance..could you please look into fix as soon as possible...it will help who is learning
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!
I tried to use pipe with azure storage but it is work with storage integration..it only worked when I created notification integration with azure queue service for the storage endpoint
that is true.. if you have cloud provider, then notification service is must to trigger Pipe..and if you want to work without notification.. then you have to watch ch-10 (ua-cam.com/video/PNK49SJvXjE/v-deo.html) of this playlist.
Update sequence option is now present in Snowsight UI, Question: How can I reset the sequence without dropping sequence?
try altering it
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 demo_db.public.sales_consumption(
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');
-----File 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');
------stage objects
--create stg object as CUSTOMER_CSV_STG thru web ui
--go to snow sql
PUT file:///Users/pundrikaxhtripathi/documents/snowflake/customer_csv.csv @CUSTOMER_CSV_STG;
;
list @CUSTOMER_CSV_STG;
--file can be copied into stage by subdir like below
PUT file:///Users/pundrikaxhtripathi/documents/snowflake/customer_csv.csv @CUSTOMER_CSV_STG/csv;
;
copy into customer_csv
from @customer_csv_stg/customer_csv1.csv
file_format=(type=csv) on_error=continue;
select * from customer_csv;
------integration 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;
-- _____________Pipes________
---------------------
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 "MY_DB_08"."MY_SCHEMA_08"."CUSTOMER_CSV"
FROM @"MY_DB_08"."MY_SCHEMA_08"."CUSTOMER_CSV_STG"
FILE_FORMAT = ( FORMAT_NAME = "MY_DB_08"."MY_SCHEMA_08"."CSV_FF" );
select system$pipe_status('my_pipe')
;
select * from CUSTOMER_CSV;
-- _____________Stream_______
---------------------
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');
-- _____________Task_______
---------------------
;
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
system$stream_has_data('customer_stream')
as
insert into customer_01 select * from customer_01 where customer_key =1 ;
"
Thank you so much .. will add to my website so folks can find from there too.
@@DataEngineering thank you, you are doing awesome job, love your videos
hey where did you get the csv file?
This is the most enjoyable snowflake learning cource in the market with detailed level of explanation.....tq so much sir😍
So nice of you and keep watching.
Feel great when community is learning and sharing their experience for others...
Sir, just one correction web ui is supporting 50 MB file size, as per snowsight....
snowflake is adding more and more features.. and yes you are right
Could you please provide SQL Script used in this Chapter-8
did u get the scripts?
why am I able to see only snowsight? I am unable to find the snowflake web ui anywhere
The snowsight is not the default webui for snowflake and the legacy WebUI is no more accessible. If you have an account that has been created long back, there is a thin chance that you can access it but now snowflake is directing all their users to Snowsight.
can you provide the practice files?
Hi sir, How to download a pdfs for snowflake ?
where can i find the TreeMap of this course
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?
You killed it, Thank you...
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?
Thank you 🙏 @Kakashi for watching my video and your word of appreciation really means a lot to me.
SnowPro core does not ask scenario bassed questions, so you don't have to worry about it. The situation based questions come in advance snow certification. Refer my pracrice test in this playlist (SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E)
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them.
🌐 Snowflake Complete Guide Playlist ➥ bit.ly/3iNTVGI
🌐 SnowPro Guide ➥ bit.ly/35S7Rcb
🌐 Snowflake SQL Series Playlist ➥ bit.ly/3AH6kCq
🌐 SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
@@DataEngineering Thank you very much, I have some set of questions wherein I'd like to discuss with you
Which platform can I reach you for this?
@@kawkawshiSan youtube comment is the only way that I can exchange notes. Maybe in the future, I will find a better way to serve my audience. Feel free to drop any query and I will check and respond.
perfect explanation of objects, earlier they were confusing, now its clear what object is used for what. Thank you.
this is an excellent course. However, without SQLs handy (for practice) it's hard to remember what we learned.
Hi can you please help me to export query results into text file with out using CLI, like in Oracle we have spool option. is there any option in Snowflake
This mind map tree is done in Lucid, correct?
Nope.
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!
Thank you for all your Snowflake videos.I am a beginner and i just watched this video. Could you please provide some more insight on how to use sub directory in stage for CDC data capture? Thank you :)
CDC subdirectory in snowflake is just a context so if you have to push data to
marking by date.. you can say maketing/01-jan-2022/my-data.csv .. the stage will automatically create it..
Watch the ch-9 and you will understand it.
ua-cam.com/video/lI5OQPjuj-8/v-deo.html
@@DataEngineering Thank you so much :) I just completed watching videos until Chapter-8 and will now proceed with the remaining chapters. Expecting you to upload the remaining chapter videos . Thank you for all your hard work and this greatly helps people like me.!!
Amazing content and great explanation and coverage of topics. Is there a way I can get Sub Topics and tree map soft copy ? TIA
Great video that summarize some good aspects in snowflakes. thanks! and well done.
Glad you liked it!
You are an angel! Literally!
Thank you 🙏 for watching my video @ Nakul Deshpande , and your word of appreciation really means a lot to me.
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them.
🌐 Snowflake Complete Guide Playlist ➥ bit.ly/3iNTVGI
🌐 SnowPro Guide ➥ bit.ly/35S7Rcb
🌐 Snowflake SQL Series Playlist ➥ bit.ly/3AH6kCq
🌐 SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
Hello sir, Can you help with correct ans for this
Will these queries be considered as same to get the benefit of the Query Result cache? Query 1 : SELECT * FROM t1; Query 2 : select * FROM t1;
yes it will use the query cache and actually, you can try that youself. Dont have any warehouse and just run the query and go to query profile and see if it has used the query cache or not.
Can someone help me with the SQL codes for the above tutorials
came across this question , need 1 correct answer
. Will data cached in a warehouse be lost when the warehouse is resized?
1.Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
2.Yes. because the compute resource is replaced in its entirety with a new compute resource.
3.No. because the size of the cache is independent from the warehouse size
4.Yes. became the new compute resource will no longer have access to the cache encryption key
Snowflake does not clearly say how they have implemented the resizing under the hood... so in my opinion the option(1) is the right answer..
Option(2) is very unlikely.. that is not mentioned anywhere in their documentation.
Option(3) - This is definitely not.
Option(4) - This is not true.
@rajeev, Let me know if you have a different view
Hi can you please provide the tree map repository (link or where is it hosted).
Thank you for making videos. Content is very rich! Many thanks!!
Thank you 🙏 @Kadamp for watching my video and your word of appreciation really means a lot to me.
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them.
🌐 Snowflake Complete Guide Playlist ➥ bit.ly/3iNTVGI
🌐 SnowPro Guide ➥ bit.ly/35S7Rcb
🌐 Snowflake SQL Series Playlist ➥ bit.ly/3AH6kCq
🌐 SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
@@DataEngineering Hi please let me know where to get the CSV files. The link does not have any files or related blogs . please I request you
work you have done by creating these tutorials in overwhelming.
Is pipe like cdc ?
Not exactly.. pipe is an object that runs a copy command and it is a wrapper object that can be triggered automatically based on configuration and move the delta files kept in stage location by running or re-running copy command.
Future chapter covers this topic in detail.
Amazing videos, thanks for making these 👍👍
Glad you like them!
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
Great suggestion.. will plan soon. If you have any specific question.. feel free to ask or reach out to me in my insta account..
if the pipe is in running status and filecount is 0 will it consume any credits for that ?, or only credit comes into picture only when the new file arrival?
Snowflake pipe is serverless component and it is hard to calculate its actual price when it is just listening but not consuming data... that goes to your overall cloud service pricing.
The pipe price can be checked from information schema table for that I would request to watch my information schema video - ch-22 (ua-cam.com/video/kqZRXoFcKo0/v-deo.html)
Hi Loved your videos, Any chance for your series on snowpark and tips to look for the new snowpro certification . Thanks in advance
Snowpark is in my list.. for snowpro... specially for new certification.. you can watch my playlist if not seen so far..
ua-cam.com/play/PLba2xJ7yxHB5X2CMe7qZZu-V4LxNE1HbF.html
❤
thanks
Thank you very much,i have attended many videos classes,i have experienced crystal clear explanation.Thank you is very less...gratitude
You are most welcome
Thank you 🙏 for watching my video and your word of appreciation really means a lot to me.
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them.
🌐 Snowflake Complete Guide Playlist ➥ bit.ly/3iNTVGI
🌐 SnowPro Guide ➥ bit.ly/35S7Rcb
🌐 Snowflake SQL Series Playlist ➥ bit.ly/3AH6kCq
🌐 SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
Hello, great explanation. Where can I find the tree map in the website?
Not available for all the chapter.. will see how can I do it..
----
and yes, I know many of us are not fully aware of snowpark Python API, if you want to manage snowflake more programatically.. you can watch my paid contents (data + code available) .. many folks don't know the power of snowpark... these 2 videos... will help you to broaden your knowledge..
These contents are available in udemy.. (one for JSON and one for CSV).. it can automatically create DDL and DML and also run copy command...
1. www.udemy.com/course/snowpark-python-ingest-json-data-automatically-in-snowflake/
2. www.udemy.com/course/automatic-data-ingestion-using-snowflake-snowpark-python-api/
i am unable to find code of this video at your web
cannot able to find tree map and SQL codes which taught .please help
Treemap is not something which I share easily.. but will publish the screenshot via my website..
please provide csv and json files as well , it would be very helpful for practice
There is a work around. you can generate the data from snowflake sample data. Use the below script then download the data in your local machine: SELECT C_NAME,C_ADDRESS,C_NATIONKEY,C_PHONE,C_ACCTBAL,C_MKTSEGMENT, C_COMMENT
FROM SNOWFLAKE_SAMPLE_DATA.TPCH_SF1.CUSTOMER
Excellent material, but you speak too fast very difficult to follow.
Sorry about that, will try to speak slow and alternatively, you can also change the speed for my existing videos.
Where I can find the datasheets used for all the tutorials. Its really hard to find it from the website.
Will check and upload it in my website toppertips.com
Can you please share the link for all the scripts which you are used in the demo?
I am planning to re-organize them in a different platform, will soon update you, for now they are missing and really sorry for that.
There;s one mistake on 21:36 stating "Integration object can only be created on Account admin role". But, I think it can be created by different roles as well...I dont have account admin access but still I can create storage integration object. COrrect me if I am wrong...
Your role might have got grants to create integration object... but in general accoutadmin can only create integration objects as this is account level object and not database/schema level object.
@@DataEngineering yes I have got access for creating Storage integration objects....
Can you tell me what are schema level objects and what are account level objects?!
It is great videos, I`m learning a lot. Is it possible to share link for the tree map ?
let me see. if I can do it.
Thanks. This is great session.
You're very welcome!
👏Well done!
Great work and a big thank you for sharing it. I have reached this chapter and intend to finish them all.
Q : Where can we find the SQL codes and data files used in the sample and tuto ?
Thank you
Thank you 🙏 for watching my video and your word of appreciation really means a lot to me.
Find the code link in description of respective video. (toppertips.com/)
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them.
🌐 Snowflake Complete Guide Playlist ➥ bit.ly/3iNTVGI
🌐 SnowPro Guide ➥ bit.ly/35S7Rcb
🌐 Snowflake SQL Series Playlist ➥ bit.ly/3AH6kCq
🌐 SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
@@DataEngineering thank you for your answer.
I meant : The respective code of each video I watch on youtube.
For example, I cannot find the correspondence on the site of the code used in this present video:
"Snowflake Must Know New Objects | Chapter-8 | Snowflake Hands-on Tutorial". And where is the matching code on the site ..how to find it.
I don't understand how to find it..?
And once more .. very good videos and samples !
👏Well done!
Great work and a big thank you for sharing it
Many thanks
Awesome content, Thanks.
Glad you liked it!
please upload the SQL script that you used in tutorial
will upload it soon... I did a migration of my website.. and during that some of the pages are lost
I dont get it, how people are doing hands on ? there are no files in the toppertips links as per the videos. Please help!
There is some issues with the link in my website.. will fix it soon..
@@DataEngineering Thank you very much. In desperate need to have handson. Till now going through has been a start even though I am totally new, at least it's making me to stay float. Thanks a lot!
Thanks for sharing. Your videos are very helpful.
Glad you like them!
Always my favourite channel🥰.
You're the best!
could you please share the link for this video blog from where i get the codes ?
Let me check but you can try again
www.toppertips.com/
it's not available there, could you please mention the post heading@@DataEngineering
please provide data also to practice queries
Will do it.. give me some time..
I can't get the code of this video... please help me with this
Visit the website www.toppertips.com/ and you would find all the blogs with SQL scripts.
kindly recheck and share the blog link please
@@DataEngineering
Finished watching
thanks
Thank you 🦋
You are so welcome
you can also explore my udemy courses
www.udemy.com/course/automatic-data-ingestion-using-snowflake-snowpark-python-api/?couponCode=NEW-YEAR-2024
www.udemy.com/course/snowpark-python-ingest-json-data-automatically-in-snowflake/?couponCode=NEW-YEAR-2024
www.udemy.com/course/snowflake-dynamic-table-masterclass-e2e-data-pipeline/?couponCode=AC7896594913CDFA6155
you are the best.....👍
Thank you so much 😀.
Thank you 🙏 for watching my video @BRIGHT SPARK and your word of appreciation really means a lot to me. Do let me if you find the entire series meaningful or only this video "Snowflake Tutorial bit.ly/3iNTVGI"