Using Grant All tables in db to share command can we share future tables also creared in provider DB? And if prev shared tables updated in provider side then consumer can see those changes??
nice explanation sir and i ihave one dobut streams, pipes ,stages ,fileformats,tasks stored procedures ni sahre cheyalema only views and tables ni matrame share cheyagalama and one more question database share chesi usage previllages ichamu alage create schema previllages isthe schema create cheyacha shared database lo and inka tables and etc..create cheyacha
@@mrjana520 Mee Instagram I'd chepthara sir personal ga contact avadaniki SQL and Snowflake Mee daggara nerchukovadaniki poorthiga ante inka baaga real time work kuda .
sir okate share ki multiple databases and multiple schemas ki usage grant ivvacha leda multiple databases share cheyalante multiple shares create cheylanaa? sir please reply me
@@mrjana520 no sir work avvatledu okka database ki oka share create cheyalsinde nenu try chesa sir indaakane avvatledu.. already oka database assign chesina share ki inko database assign avatledu.( database does not belong to the database that is being shared.)ani vastundi sir malli vere share create chesi assign chesthe avutundi .. ante okko database ki okko share create cheyalanukuntunna sir..
While education people used to by-hearting only faqs instead of understanding the concepts, they are following the same thing in job search as well, they just need direct question and answers. Guys have patience and understand the concepts fully and practice as well..
Hi, with just this error line, I can't help. If you follow the steps in the same order I have explained you will not get any error. pls check all the steps once.
Just Making things simple and easy in manner......Your Vedio just amazing .
Thank you so much sir for your videos.
Nice explanation. Please make a video on how to do migration from Dev to Test environment.
Nice video sir ...very helpful..pls keep posting snowflake related videos more
great explanation
It's really helpful sir thank you
please make one video on Data sampling
Please order your snowflake playlist, so that we can follow easily. Thanks for sharing your knowledge
Done!
Thank you so much, also could u please add numbers beside the video name
In what all snowflake editions we can implement shares? can we implement shares in snowflake business critical & VPS editions?
Not sure about VPS, but we can in enterprise and business critical
Using Grant All tables in db to share command can we share future tables also creared in provider DB? And if prev shared tables updated in provider side then consumer can see those changes??
Yes, you can
Also, Could you please create tutorials on Clustering and Snowpipe
Will do
nice explanation sir and i ihave one dobut streams, pipes ,stages ,fileformats,tasks stored procedures ni sahre cheyalema only views and tables ni matrame share cheyagalama and one more question database share chesi usage previllages ichamu alage create schema previllages isthe schema create cheyacha shared database lo and inka tables and etc..create cheyacha
Answer is there in this video itself. And you can't create schemas and tables in the shared databases.
@@mrjana520 haa sir thank you and Mee anni videos nenu chusanu sir Mee videos chuse nen snowflake nerchukunna...
@@mrjana520 Mee Instagram I'd chepthara sir personal ga contact avadaniki SQL and Snowflake Mee daggara nerchukovadaniki poorthiga ante inka baaga real time work kuda .
My mail id is available in the description of every video. Reach me on jana.snowflake2@gmail.com
sir how can we load data in an external system into our snowflake account and is there any way to host the tables in our account to others
What is meant by external system?
is there any way to host the tables in our account to others?
Yes through data sharing and data replication.
@@mrjana520ok sir
sir okate share ki multiple databases and multiple schemas ki usage grant ivvacha leda multiple databases share cheyalante multiple shares create cheylanaa? sir please reply me
I never tried but as per my knowledge 1 share is enough for multiple databases
@@mrjana520 no sir work avvatledu okka database ki oka share create cheyalsinde nenu try chesa sir indaakane avvatledu.. already oka database assign chesina share ki inko database assign avatledu.( database does not belong to the database that is being shared.)ani vastundi sir malli vere share create chesi assign chesthe avutundi .. ante okko database ki okko share create cheyalanukuntunna sir..
Oh k, thanks for the information
@@mrjana520 ha sir parledu no thanks Mee vallane nen teluskuntunna motham ,meeru okasari try cheyandi sir..
How to share if the accounts are in different region? Please provide step by step details or point to any video of yours. Thanks
There is a concept called data replication, clearly explained in Snowflake documentation
What is difference between data sharing, zero copy cloning and replications in snowflake
It can't be answered in a single word or sentence, just watch data sharing video and zero copy cloning video fully, you will understand the concepts
While education people used to by-hearting only faqs instead of understanding the concepts, they are following the same thing in job search as well, they just need direct question and answers. Guys have patience and understand the concepts fully and practice as well..
Don't we need to provide grant usage, privileges if we do it through web ui ?
It will be done automatically if do using ui, grants are mandatory, if you want to check, use web ui and then check the grants by using SQL query
Can we do DML opeartions like Insert,delet,update on the shared tables?
No, you can't
I am unable to add another Snowflake account it is showing the following error
Error: The following accounts cannot be added to this share: ME******
Hi, with just this error line, I can't help. If you follow the steps in the same order I have explained you will not get any error. pls check all the steps once.
I am unable to add another snowflake account its showing following error Errror:Following accounts cannot be added to this share:lq47367
Both accounts are from same region?
@@mrjana520No the accounts are in different region