Відео

WHERE IS CODE

Thank you so much for sharing this video..

what if multiple records come from source for same business key. how do you handle type2 and close old record and keep latest record as active

excellent tutorial, thank you !

excellent tutorial, thanks !

excelent playlist, clear and concise explanations, thank you !

@RajivGuptaEverydayLearning i am looking snowflake admin online training . Will you able to provide training if yes please ping mail id so that i can contact you

Hi good to see this

Very informative 🎉

Thank you so much sir. It's a great help for the learning students

I am a senior DBA and planning to learn snowflake , Does snowflake admin alone have scope or we need to learn development as well as snowflake is SAAS once we deploy services everything managed by snowflake right ? Please do suggest which works better for DBAs

I'm a bit confused, this is what the official documentation of snowflake says about database roles, why are the database roles cloned on your example? For database roles: A database role is not cloned when you run the CREATE CLONE command to clone a database or other objects that are contained in the database. You must use the CREATE DATABASE ROLE … CLONE command to clone a database role to the target database. If the database role is already cloned to the target database, the command fails. If this occurs, drop the database role from the target database and try the CLONE command again.

Nice information but why do we have to make SCD1(Supplier_Landing) and then make SCD2(Supplier_Staging) from it?

Can you provide me the commands

This series is enough to learn sniwflake admin or else i need to learn any thing more apart from this because i working as snowflake develiper could you please suggest me

Superb useful, Thanks lot❤

Super useful, Thanks lot❤

HI Rajiv, can the replication be done on Enterprise Edition?

It wud be great if u can share the code

Sir I am working as a Hadoop Administrator, Is it beneficial to switch to Snowflake Admin have any good job opportunity.

Rajiv your Everyday learning is awesome ,, in appreciation this is everyday referal, everyday tips , it's a Bible to learners

Hi Rajiv, I am getting compilation error. get @internal_stage_json/file://c:\ajay\snowflake\TRAINING\unloadingdata; 001003 (42000): SQL compilation error: syntax error line 1 at position 73 unexpected ';'.

Short and sweet! Very nice!

when SF is not going to be used as a OLTP then what scenario streams are significant?

Hi I've a query. I have a requirement where a new file comes to my local system every day at a specific location. I have to create an internal stage on Snowflake and have to exceute put command on snowsql to upload this file data into snowflake table . I want to orchestrate this daily. How to achieve this

Nicely explained. Thank you sir

It would be more helpful if you can explain what is sample rows mean and what is the purpose of SEED. We get these definition from the Snowflake documents, but does not explain with a good example.

Hi Rajiv, when i am adding a another file, it is skipping the file as saying Ignoring non-change file ... can you please suggest what is the issue

Thanks for the work & I can understand 16 mins of video needs atleast 3-4 hours of efforts. Keep it up!!!

Thank you

Well explained. Small doubt sir, few objects are not replicate like internal stage, what we can d9 for those objects.?

Very good video on snowflake replication ever seen. Great thanks for sharing this video sir. I have one query.. In step 2 why you have enabled replication for 2 servers. I mean to ask, our plan is primary to secondary replication and secondary server to standard server data sharing. for 3rd server also we need to enable replication even we are doing data sharing?

can we do Modeling in Snowflake ? Could you pls share some videos on this pls

In my primary database, all objects like tables/views are created with sysadmin role, I want to replicate with same role, how can I do that?

very nice explanation but I have one doubt where actually we do transformations, make one video making transformations after loading into snowflake table take any scenario and do bro if possible only

How to complete certifications like 1) Hands On Essentials - Data Lake 2) Hands On Essentials - Data Engineering 3)SnowPro Subject Matter Expert All these are Free or Paid certifications? Could please guide.

Great video... thanks

🌟 P r o m o S M

SHOW DATABASE ROLES IN DATABASE DBROLE; would be the command to list database roles in that db.

Nicely presented but where is the code ? If you don't provide the code, how can learners practice and learn?

good presentation... If you could share the source code it would be good.

Is it possible to use schema detection in external tables ?

HOW TO SEE THE LAST ACTION MADE ON THE TABLE IN SNOWFLAKE

Hi Rajiv - Can you please share the scripts ?

thanks, but this unload ndjson and not json, there is any idea to do it and exceed 16mb ( limit with array_agg) ?

Thank you sir for the information. i am from non IT background but understood it.

crystal clear explination

How can we disable local authentication and force federated auth? i assume there's SP initiated settings but can't figure out how to do that

where can i find ddl commands for your videos?

what if you have multiple tables in database and you want to replicate only one table?