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Күн бұрын
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Күн бұрын
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.
@tradelover70783 күн бұрын
Hi you have any play list for migration ?
@positivejostyle31693 күн бұрын
I think this is how explanation is done without wasting hours.
@ambarsingh69594 күн бұрын
you are doing god's work.
@shashankreddysai6 күн бұрын
Very Helpful. But good number of questions were very tricky. This playlist is a great start. However, some questions are having confusing options
@letsgosud6 күн бұрын
Enroll showing closed now please help
@DataEngineering6 күн бұрын
you can drop a email to certification support team and they are very quick responding your queries.
@Ikilledthebanks7 күн бұрын
One of not the best channels appreciate the deep dives.
@nikkysingh49687 күн бұрын
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-j4l7 күн бұрын
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?
@DataEngineering6 күн бұрын
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.17108 күн бұрын
Excellent video - exactly what I needed at the right time. Thank you!
@DataEngineering6 күн бұрын
welcome.
@komminenihema22718 күн бұрын
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
@pagalshaitan64958 күн бұрын
Nice sir
@DataEngineering6 күн бұрын
Thanks and welcome
@ritika299 күн бұрын
Useful Info. Thanks! Quick question : Is time travel supported on stream object?
@DataEngineering9 күн бұрын
Stream does not support a time travel feature... as it is just an offset attribute on existing table.
@puchki2015-gf9zf9 күн бұрын
Do you have any course which covers end to end as you described in this video
@DataEngineering9 күн бұрын
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-m5p10 күн бұрын
Where do I get the data files from?
@DataEngineering9 күн бұрын
check the description
@AnudeepKolluri10 күн бұрын
What is the tool used at 1:12:24?
@AnudeepKolluri10 күн бұрын
found it DBeaver
@DataEngineering6 күн бұрын
good.
@AnudeepKolluri10 күн бұрын
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.
@DataEngineering6 күн бұрын
Let me check
@nagasairamtaluri893312 күн бұрын
on quick recap chapter :voice is on mute we cant hear you
@DataEngineering11 күн бұрын
probably yes.. I made this video long long back.. so not able to recall why it muted..
@surafeb712 күн бұрын
ACCOUNTADMIN, USERADMIN, and SECURITYADMIN can create users. However, USERADMIN is the role typically designated for user management tasks!
@Pinea_pples13 күн бұрын
Finally i found this video today.. hope i will be mastering the snowflakes with help by
@DataEngineering6 күн бұрын
enjoy the learning.
@venkatvujji807713 күн бұрын
Thanks for the detailed information regarding core certification. Your videos are helped me to clear the exam. I appreciate you effort.
@DataEngineering9 күн бұрын
It's my pleasure
@Pawaidaar13 күн бұрын
Great content bro
@DataEngineering13 күн бұрын
Glad you think so!
@EGSTCEvergreenSkillsTrainingCe14 күн бұрын
good explation
@DataEngineering9 күн бұрын
Glad you liked it
@deepikanechlani691614 күн бұрын
So for external stage and table load we do not need to create pipe?
@DataEngineering13 күн бұрын
yes, the default file format will be considered and it is CSV.
@deepikanechlani691615 күн бұрын
So if there is no file format associated with internal stage so we can not store semistructured data?
@DataEngineering13 күн бұрын
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-702015 күн бұрын
Very Useful session sir...Thank you so much
@DataEngineering13 күн бұрын
Always welcome
@joshisf656516 күн бұрын
Hi can you share the UDEMY complete snowflake developer course link.
@DataEngineering13 күн бұрын
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/
@sahilgupta00616 күн бұрын
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
@DataEngineering13 күн бұрын
check the description of the video...
@DisorderedFleshAutomata-sm8cd17 күн бұрын
Q4 isn't C also technically correct? If you increase the maximum number of clusters then it can result in B.
@kamalprajapati995517 күн бұрын
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?
@DataEngineering13 күн бұрын
yes ..right.... or as work around.. you can use multicluster to get the same number within the same account.
@kunalshah-e4h17 күн бұрын
unable to load ODBC snowflake in MS EXCEL in "MAC OS". Error: (file system sandbox blocked open()) - can you guide?
@DataEngineering13 күн бұрын
it should not be an issue.. with mac OS.. there must be a security issue..
@kunalshah-e4h12 күн бұрын
How to resolve?
@Praveen_Kumar_R_CBE17 күн бұрын
Very useful stuff.. eagerly awaiting for the Cortex series
@DataEngineering13 күн бұрын
Very soon!
@ramnathjayachandran218117 күн бұрын
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
@DataEngineering13 күн бұрын
you need to nest the object function 3 level down.... or you have to write a recursive function using python
@NandhiniRamakrishnan-o4w18 күн бұрын
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.
@DataEngineering9 күн бұрын
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-lv2ee18 күн бұрын
is not the snowflake jobs are decreasing in india? also what to learn along with snowlake and airflow to better job opportunity?
@chengjoseph945918 күн бұрын
Very practical video. I've used it for my work! thanks alot.
@DataEngineering9 күн бұрын
Glad it was helpful!
@DisorderedFleshAutomata-sm8cd19 күн бұрын
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.
@DataEngineering9 күн бұрын
yes they do..
@sanilkumarbarik915121 күн бұрын
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?
@DataEngineering9 күн бұрын
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/
@sahilgupta00622 күн бұрын
why toppertips website showing under maintenance ?
@DataEngineering21 күн бұрын
it is fixed now and you must be able to access it.
@MrBengals23 күн бұрын
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
@kanagalanagasri70423 күн бұрын
Is there a way to check if resultset is empty and then raise exception ?
@rameshchidurala382223 күн бұрын
@DataEngineering I got account admin by default, Should I use that or do i need to switch it to system admin? I am confused.
@rameshchidurala382224 күн бұрын
@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.
@GaneshHurgule25 күн бұрын
Is it work with external table
@Siddhant762025 күн бұрын
Now I'm SnowPro Core certified. Thank you for the videos. It helped a lot.
@tusharr903626 күн бұрын
your video won't be complete unless you provide data files for us to use and build project with you.