Snowflake Notebooks
32:14
Ай бұрын
Пікірлер
@SowmyaAS-x7t
@SowmyaAS-x7t 13 сағат бұрын
Excellent
@SowmyaAS-x7t
@SowmyaAS-x7t 13 сағат бұрын
Excellent explanation.
@AJEETKUMAR-yj8tv
@AJEETKUMAR-yj8tv 15 сағат бұрын
couple of SQL Script file link is not working as ch-17,ch-18,showing error file does not exist ,pls look into it and also for few chapter has not give SQL script link into description such ch-8,ch-9, could you please provide it ?
@basharatsaigal9800
@basharatsaigal9800 Күн бұрын
The dataset in the gitlab is only for 30 days and the forex date is also different for what you have. Can you please crosscheck the files and share the correct ones?
@udayrajd
@udayrajd Күн бұрын
Current UI in the trial account looks much different e..g the wizard does not come up for creating a file format, it has to be done through sql. Is there any setting that i need to modify to get the UI wizards to create various objects ? Please advise. Thanks.
@tradelover7078
@tradelover7078 3 күн бұрын
Hi you have any play list for migration ?
@positivejostyle3169
@positivejostyle3169 3 күн бұрын
I think this is how explanation is done without wasting hours.
@ambarsingh6959
@ambarsingh6959 4 күн бұрын
you are doing god's work.
@shashankreddysai
@shashankreddysai 6 күн бұрын
Very Helpful. But good number of questions were very tricky. This playlist is a great start. However, some questions are having confusing options
@letsgosud
@letsgosud 6 күн бұрын
Enroll showing closed now please help
@DataEngineering
@DataEngineering 6 күн бұрын
you can drop a email to certification support team and they are very quick responding your queries.
@Ikilledthebanks
@Ikilledthebanks 7 күн бұрын
One of not the best channels appreciate the deep dives.
@nikkysingh4968
@nikkysingh4968 7 күн бұрын
Hi @Data engineering simplified , I have watched your videos and cleared snowflake core exam last month. Thank you for making such a great content. Now I am preparing for snowflake advance data engineer certification but I didn't find any playlist or roadmap to prepare for snowflake advance data engineer exam. Could you please share a playlist or a video of roadmap to prepare for this exam. It will be very helpful. Thanks
@ALS-j4l
@ALS-j4l 7 күн бұрын
Why do your write Snowpark code that again coverts to SQL that would be SLOW? Why not directly use Snowflake Scripting using External table that would be FASTER?
@DataEngineering
@DataEngineering 6 күн бұрын
if you have an existing spark code or python code that interacts with database and now your db or dwh is snowflake, you don't need migrate all your codebase to SQL. There are other use cases where doing it programmatically is much easier than writing sql code, like xl processing and then put it in snowflake, such use cases can not be done using sql and in that case Snowpark shine a lot.
@e.s.1710
@e.s.1710 8 күн бұрын
Excellent video - exactly what I needed at the right time. Thank you!
@DataEngineering
@DataEngineering 6 күн бұрын
welcome.
@komminenihema2271
@komminenihema2271 8 күн бұрын
Hi can you share the link of snowflake web UI link I was able to login only snowflake snowsight can you share the link of web UI
@pagalshaitan6495
@pagalshaitan6495 8 күн бұрын
Nice sir
@DataEngineering
@DataEngineering 6 күн бұрын
Thanks and welcome
@ritika29
@ritika29 9 күн бұрын
Useful Info. Thanks! Quick question : Is time travel supported on stream object?
@DataEngineering
@DataEngineering 9 күн бұрын
Stream does not support a time travel feature... as it is just an offset attribute on existing table.
@puchki2015-gf9zf
@puchki2015-gf9zf 9 күн бұрын
Do you have any course which covers end to end as you described in this video
@DataEngineering
@DataEngineering 9 күн бұрын
there are couple of them available in my channel as well as in my udemy kzbin.info/www/bejne/Z5umamuOhtx1kNk Udemy - www.udemy.com/course/snowflake-complete-end-to-end-data-project-hands-on-guide/
@PrathyushK-m5p
@PrathyushK-m5p 10 күн бұрын
Where do I get the data files from?
@DataEngineering
@DataEngineering 9 күн бұрын
check the description
@AnudeepKolluri
@AnudeepKolluri 10 күн бұрын
What is the tool used at 1:12:24?
@AnudeepKolluri
@AnudeepKolluri 10 күн бұрын
found it DBeaver
@DataEngineering
@DataEngineering 6 күн бұрын
good.
@AnudeepKolluri
@AnudeepKolluri 10 күн бұрын
sir, I have tried to build the project along side you. Everything went fine until I am setting primary and foreign keys in snowflake. Please update in medium blog. Ty.
@DataEngineering
@DataEngineering 6 күн бұрын
Let me check
@nagasairamtaluri8933
@nagasairamtaluri8933 12 күн бұрын
on quick recap chapter :voice is on mute we cant hear you
@DataEngineering
@DataEngineering 11 күн бұрын
probably yes.. I made this video long long back.. so not able to recall why it muted..
@surafeb7
@surafeb7 12 күн бұрын
ACCOUNTADMIN, USERADMIN, and SECURITYADMIN can create users. However, USERADMIN is the role typically designated for user management tasks!
@Pinea_pples
@Pinea_pples 13 күн бұрын
Finally i found this video today.. hope i will be mastering the snowflakes with help by
@DataEngineering
@DataEngineering 6 күн бұрын
enjoy the learning.
@venkatvujji8077
@venkatvujji8077 13 күн бұрын
Thanks for the detailed information regarding core certification. Your videos are helped me to clear the exam. I appreciate you effort.
@DataEngineering
@DataEngineering 9 күн бұрын
It's my pleasure
@Pawaidaar
@Pawaidaar 13 күн бұрын
Great content bro
@DataEngineering
@DataEngineering 13 күн бұрын
Glad you think so!
@EGSTCEvergreenSkillsTrainingCe
@EGSTCEvergreenSkillsTrainingCe 14 күн бұрын
good explation
@DataEngineering
@DataEngineering 9 күн бұрын
Glad you liked it
@deepikanechlani6916
@deepikanechlani6916 14 күн бұрын
So for external stage and table load we do not need to create pipe?
@DataEngineering
@DataEngineering 13 күн бұрын
yes, the default file format will be considered and it is CSV.
@deepikanechlani6916
@deepikanechlani6916 15 күн бұрын
So if there is no file format associated with internal stage so we can not store semistructured data?
@DataEngineering
@DataEngineering 13 күн бұрын
Yes... it is not necessary that you should have file format when you create stage.. and default consideration is CSV... so if there is CSV file.. without the file format you can query the stage files.
@KameshKamble-7020
@KameshKamble-7020 15 күн бұрын
Very Useful session sir...Thank you so much
@DataEngineering
@DataEngineering 13 күн бұрын
Always welcome
@joshisf6565
@joshisf6565 16 күн бұрын
Hi can you share the UDEMY complete snowflake developer course link.
@DataEngineering
@DataEngineering 13 күн бұрын
there are the video published in udemy. www.udemy.com/course/automatic-data-ingestion-using-snowflake-snowpark-python-api/ www.udemy.com/course/snowpark-python-ingest-json-data-automatically-in-snowflake/ www.udemy.com/course/snowflake-dynamic-table-masterclass-e2e-data-pipeline/ www.udemy.com/course/snowflake-complete-end-to-end-data-project-hands-on-guide/
@sahilgupta006
@sahilgupta006 16 күн бұрын
from where I can download Customer Data - Master Data, Item Data - Master Data, Order Data - Transactional or Fact Data ? need link to download data in csv format
@DataEngineering
@DataEngineering 13 күн бұрын
check the description of the video...
@DisorderedFleshAutomata-sm8cd
@DisorderedFleshAutomata-sm8cd 17 күн бұрын
Q4 isn't C also technically correct? If you increase the maximum number of clusters then it can result in B.
@kamalprajapati9955
@kamalprajapati9955 17 күн бұрын
Suppose the account was created on GCP cloud and in the coming years there is a need of 5x and 6x size compute and GCP does not have that available. In that case a new account under AWS or Azure would have to be created to facilitate the need, Am I right or is there any other feasible solution?
@DataEngineering
@DataEngineering 13 күн бұрын
yes ..right.... or as work around.. you can use multicluster to get the same number within the same account.
@kunalshah-e4h
@kunalshah-e4h 17 күн бұрын
unable to load ODBC snowflake in MS EXCEL in "MAC OS". Error: (file system sandbox blocked open()) - can you guide?
@DataEngineering
@DataEngineering 13 күн бұрын
it should not be an issue.. with mac OS.. there must be a security issue..
@kunalshah-e4h
@kunalshah-e4h 12 күн бұрын
How to resolve?
@Praveen_Kumar_R_CBE
@Praveen_Kumar_R_CBE 17 күн бұрын
Very useful stuff.. eagerly awaiting for the Cortex series
@DataEngineering
@DataEngineering 13 күн бұрын
Very soon!
@ramnathjayachandran2181
@ramnathjayachandran2181 17 күн бұрын
Thanks for sharing this approach. Can you pls suggest how to handle the scenario if the key to mask exists two or 3 levels down from the root node of json ? As in handling masking of keys inside a nested variant
@DataEngineering
@DataEngineering 13 күн бұрын
you need to nest the object function 3 level down.... or you have to write a recursive function using python
@NandhiniRamakrishnan-o4w
@NandhiniRamakrishnan-o4w 18 күн бұрын
I am a BI Engineer and trying to expand my portfolio to Data Engineering as well! Man, no paid courses give such realistic demos and explanations in real-time scenarios. Thank You for teaching us all free. This course is amazing and wonderfully curated.
@DataEngineering
@DataEngineering 9 күн бұрын
Glad it was helpful! I do have paid courses that has lot of content to practice.... you can try them www.udemy.com/user/data-engineering-simplified/
@Aman-lv2ee
@Aman-lv2ee 18 күн бұрын
is not the snowflake jobs are decreasing in india? also what to learn along with snowlake and airflow to better job opportunity?
@chengjoseph9459
@chengjoseph9459 18 күн бұрын
Very practical video. I've used it for my work! thanks alot.
@DataEngineering
@DataEngineering 9 күн бұрын
Glad it was helpful!
@DisorderedFleshAutomata-sm8cd
@DisorderedFleshAutomata-sm8cd 19 күн бұрын
Do they seriously ask questions about Snowflake Partners on the exam? It seems absolutely ridiculous that they expect you to just know what type of partner a random selection is from a list of literally hundreds, some with overlapping categories. Its not a test of knowledge, but memorisation.
@DataEngineering
@DataEngineering 9 күн бұрын
yes they do..
@sanilkumarbarik9151
@sanilkumarbarik9151 21 күн бұрын
Currently I am working as a Data Analyst and want to transition to Data Engineering. So is this playlist enough for learning about snowflake or do I need to refer any other video apart from this?
@DataEngineering
@DataEngineering 9 күн бұрын
it will help you a lot, I have lot of playlist you can also reveiw my udemy course www.udemy.com/user/data-engineering-simplified/
@sahilgupta006
@sahilgupta006 22 күн бұрын
why toppertips website showing under maintenance ?
@DataEngineering
@DataEngineering 21 күн бұрын
it is fixed now and you must be able to access it.
@MrBengals
@MrBengals 23 күн бұрын
Is it possible to assign multiple string/text values into one single Snowflake variable? I have a use case where I'm trying to set a variable containing multiple field names and query it in one go vs. creating several variables or hardcoding the fields in my where clause
@kanagalanagasri704
@kanagalanagasri704 23 күн бұрын
Is there a way to check if resultset is empty and then raise exception ?
@rameshchidurala3822
@rameshchidurala3822 23 күн бұрын
@DataEngineering I got account admin by default, Should I use that or do i need to switch it to system admin? I am confused.
@rameshchidurala3822
@rameshchidurala3822 24 күн бұрын
@DataEngineering I am unable to create a table under the database I have created. I am not seeing an option to create a table. When I try to create a table from the main page, it gives me four different options to create a table, but each option requires me to write an SQL query to create a table. It is not showing me an option to simply give it a name so it can write the SQL query in the backend. Could you please help me with this? Thanks. By the way, I am using the ADMIN account.
@GaneshHurgule
@GaneshHurgule 25 күн бұрын
Is it work with external table
@Siddhant7620
@Siddhant7620 25 күн бұрын
Now I'm SnowPro Core certified. Thank you for the videos. It helped a lot.
@tusharr9036
@tusharr9036 26 күн бұрын
your video won't be complete unless you provide data files for us to use and build project with you.