Snowflake Developer Community @snowflakecomputing Channel on Telegram

Snowflake Developer Community

@snowflakecomputing

The Channel is a forum to share knowledge on Snowflake Data warehouse.

Snowflake Developer Community (English)

Are you passionate about Snowflake Data warehouse and looking to connect with like-minded developers? Look no further than the Snowflake Developer Community on Telegram! As the go-to forum for sharing knowledge and insights on all things Snowflake, this channel is a must-join for developers, data engineers, and anyone interested in maximizing their potential with this cutting-edge technology

Who is the Snowflake Developer Community? This vibrant community is made up of individuals who are dedicated to exploring and utilizing the power of Snowflake Data warehouse. Whether you're a seasoned developer looking to expand your skills or a newcomer eager to learn more about Snowflake, you'll find a supportive and knowledgeable network of peers here

What is the Snowflake Developer Community? This Telegram channel serves as a hub for discussions, tips, best practices, and resources related to Snowflake Data warehouse. From troubleshooting common issues to sharing success stories, members of this community come together to collaborate and grow together

Joining the Snowflake Developer Community means gaining access to a wealth of expertise and insights that can help you elevate your data warehousing projects to new heights. Whether you're seeking advice on optimizing queries, exploring advanced functionalities, or simply looking to connect with fellow Snowflake enthusiasts, this channel has something for everyone

Don't miss out on the opportunity to be part of this dynamic and supportive community of Snowflake developers. Join the Snowflake Developer Community on Telegram today and start expanding your knowledge and network in the exciting world of Snowflake Data warehouse!

Snowflake Developer Community

18 Jul, 09:20

Deep Dive - Snowflake Architecture
Wednesday, Jul 21 • 6:00 – 7:00 PM (GMT+5:30)
Google Meet joining info
Video call link: https://meet.google.com/ayn-qeoy-smq
30,739
Snowflake Developer Community

17 Jun, 08:03

Channel name was changed to «Snowflake Developer Community»
0
Snowflake Developer Community

17 Jun, 07:48

https://t.me/snowflakedevforum

Join the group to interact with other members and get your queries answered.
31,142
Snowflake Developer Community

10 Jun, 10:43

Questions specific to warehouse :

1. Size of warehouse in project and how did you decide it.
2. When do we require to use multi-cluster and auto-scaling warehouses.
3. How does a multi cluster warehouse setup works.
4. Different types of caching in Snowflake.
5. Is a warehouse and database dependent on each other.
6. Can a warehouse be mapped to different databases.
7. Two modes in which a multi-cluster warehouse can run.
8. Idea on snowflake warehouse pricing.
9. How do define role access control on warehouse.
10. Auto suspension and auto resumption
11.Monitoring warehouse load - good to know.
12. How is Virtual warehouses and storage independent of each other ?
13. How does a query processing happen on a warehouse.
14. Does virtual warehouse share resources with other warehouses ?
15. When you resize a warehouse how does it affect any running query in process using it.
32,082
Snowflake Developer Community

06 Jun, 16:15

Questions specific to data loading/unloading :

1. Difference between copy and put command.
2. Steps involved in creation of stages.
3. Different type of stages.
4. Rejected/bad records- how to view them.
5. Considering a scenario where you need to load files as soon as it arrives, how would you implement it.
6. Loading semi structured data - through variant column.
7. How does snowflake always load the incremental data files ignoring the ones already loaded.
8. How would you force to load all the files in a given folder/directory.
9. Can you query data on external storage without loading them, if yes how ?
10. Bulk vs Continuous loading.
24,147
Snowflake Developer Community

05 Jun, 09:37

Probable Interview Questions on Snowflake :

Snowflake being relatively new most of the interview questions would be based on how you have implemented and used it in your project.

Some which I could recall are -

1. Snowflake Architecture and it's various components
2. Data loading and challenges faced
3. Data loading include copy command, how do you create stages, various stage - table/internal/external.
4. How does stages differ from each other.
5. How to create external stage referencing S3 bucket/ADSL
6. Scenarios like how do you handle duplicates as integrity constraints are not enforced in SF.
7. What are warehouses and how do you design it.
8. Performance optimization - Auto Scaling, Caching and clustering
9. Scenarios where you have used time travel feature.
10. UDF and how have you used it.
11. Restrictions in SF as compared to RDBMS database.
12. If you have worked on migration what are challenges faced and how did you overcome it.
13. Task, streams implementation scenario.
14. Structured/semi- structured files how have you loaded them.
15. Volume of data you have handled.
16. Architecture of your project.
17. Orchestration of SF pipelines - tools being used for it.
18. How do you handle transactional transactions in Snowflake.
19. Snowpipe
20.Data Unloading.
21. Role based access management - important to have knowledge on this.
22. How does normal views and materials views differ in Snowflake

There can be various scenario based question based on what you explain about your project and how knowledgeable interviewer is.

With Snowflake you need to have basic to intermediate knowledge on cloud technology and orchestration will be add on.
22,202
Snowflake Developer Community

01 Jun, 16:57

Emailing SQL-1.pdf
17,706
Snowflake Developer Community

01 Jun, 16:55

Emailing SQL Cheat Sheet.pdf
17,347
Snowflake Developer Community

30 May, 09:00

Databricks Developer Forum
https://t.me/databricksdevforum


Join the group to post queries related to Databricks.
16,664
Snowflake Developer Community

30 May, 08:16

https://t.me/snowflakedevforum

Join the group to post your queries related to Snowflake.
15,620
Snowflake Developer Community

09 May, 09:22

Please do share for benefit of others.
15,359
Snowflake Developer Community

09 May, 09:22

Hey folks,
I'm Shoaib, data engineer with 5+ years of experience with expertise in SQL, Spark, Python, Big data and cloud technology.
I would like to train and mentor individuals on the different tech stack.
Starting off with *SQL Bootcamp* which will cover basics to advanced sql skill training.
The target audience would be final year engineering students, freshers and individuals having less than an year of working experience.
The training would be *Free of Cost* and the batch size would be 10-15 people only.
Registration closes by 15th May 2021.

Interested people please fill out the form :
https://forms.gle/cXvmALf5WJ4qVmN77
15,814
Snowflake Developer Community

07 Feb, 22:06

https://cloudedjudgement.substack.com/p/the-modern-data-cloud-warehouse-vs
15,040
Snowflake Developer Community

02 Feb, 20:09

https://guides.snowflake.com/
13,906
Snowflake Developer Community

21 Jan, 05:14

The Most Awesome New Snowflake features for Data Science & Engineering.
https://www.linkedin.com/pulse/most-awesome-new-snowflake-features-data-science-nick-akincilar
14,632
Snowflake Developer Community

08 Jan, 16:40

Introduction to External Functions — Snowflake Documentation
https://docs.snowflake.com/en/sql-reference/external-functions-introduction.html
13,034
Snowflake Developer Community

30 Nov, 18:54

Queries related to Snowflake, ideas on preparing for certification.. please hit the Discuss tab to join the Forum and get inputs from other members of group.
12,769
Snowflake Developer Community

31 Aug, 20:46

Snowflake Developer Community pinned «Queries related to Snowflake, please hit the Discuss tab to join the Forum and get inputs from other members of group.»
0
Snowflake Developer Community

31 Aug, 20:44

Queries related to Snowflake, please hit the Discuss tab to join the Forum and get inputs from other members of group.
12,570
Snowflake Developer Community

10 Jul, 09:21

https://resources.snowflake.com/snowflake-videos/dynamic-data-masking-artin-avanes
12,570

2024 All Right Reserved

Disclaimer: The content displayed on this website is solely provided by the respective Telegram channels. We hold no ownership or responsibility for the content shared by these channels.