Snowflake Developer Community
رفتن به کانال در Telegram
The Channel is a forum to share knowledge on Snowflake Data warehouse.
نمایش بیشترکشور مشخص نشده استدسته بندی مشخص نشده است
6 705
مشترکین
+224 ساعت
+357 روز
+15830 روز
در حال بارگیری داده...
کانالهای مشابه
ابر برچسبها
هیچ دادهای
مشکلی وجود دارد؟ لطفاً صفحه را تازه کنید یا با مدیر پشتیبانی ما تماس بگیرید.
اشارات ورودی و خروجی
---
---
---
---
---
---
جذب مشترکین
دسامبر '24
دسامبر '24
+54
در 0 کانالها
نوامبر '24
+46
در 0 کانالها
Get PRO
اکتبر '24
+221
در 0 کانالها
Get PRO
سپتامبر '24
+170
در 0 کانالها
Get PRO
اوت '24
+143
در 0 کانالها
Get PRO
ژوئیه '24
+95
در 0 کانالها
Get PRO
ژوئن '24
+80
در 0 کانالها
Get PRO
مه '24
+116
در 0 کانالها
Get PRO
آوریل '24
+162
در 0 کانالها
Get PRO
مارس '24
+70
در 0 کانالها
Get PRO
فوریه '24
+36
در 0 کانالها
Get PRO
ژانویه '24
+196
در 0 کانالها
Get PRO
دسامبر '23
+1 942
در 0 کانالها
Get PRO
نوامبر '230
در 0 کانالها
Get PRO
اکتبر '230
در 0 کانالها
Get PRO
سپتامبر '230
در 0 کانالها
Get PRO
اوت '230
در 0 کانالها
Get PRO
ژوئیه '230
در 0 کانالها
Get PRO
ژوئن '230
در 0 کانالها
Get PRO
مه '230
در 0 کانالها
Get PRO
آوریل '230
در 0 کانالها
Get PRO
مارس '230
در 0 کانالها
Get PRO
فوریه '230
در 0 کانالها
Get PRO
ژانویه '230
در 0 کانالها
Get PRO
دسامبر '22
+308
در 0 کانالها
Get PRO
نوامبر '22
+274
در 0 کانالها
Get PRO
اکتبر '220
در 0 کانالها
Get PRO
سپتامبر '22
+327
در 0 کانالها
Get PRO
اوت '22
+672
در 0 کانالها
Get PRO
ژوئیه '220
در 0 کانالها
Get PRO
ژوئن '220
در 0 کانالها
Get PRO
مه '22
+153
در 0 کانالها
Get PRO
آوریل '22
+778
در 0 کانالها
Get PRO
مارس '220
در 0 کانالها
Get PRO
فوریه '220
در 0 کانالها
Get PRO
ژانویه '22
+93
در 0 کانالها
Get PRO
دسامبر '21
+170
در 0 کانالها
Get PRO
نوامبر '21
+180
در 0 کانالها
Get PRO
اکتبر '21
+1 644
در 0 کانالها
| تاریخ | رشد مشترکین | اشارات | کانالها | |
| 21 دسامبر | 0 | |||
| 20 دسامبر | +6 | |||
| 19 دسامبر | +1 | |||
| 18 دسامبر | +6 | |||
| 17 دسامبر | +3 | |||
| 16 دسامبر | +3 | |||
| 15 دسامبر | +7 | |||
| 14 دسامبر | +1 | |||
| 13 دسامبر | +2 | |||
| 12 دسامبر | +9 | |||
| 11 دسامبر | +2 | |||
| 10 دسامبر | +2 | |||
| 09 دسامبر | 0 | |||
| 08 دسامبر | +2 | |||
| 07 دسامبر | 0 | |||
| 06 دسامبر | +3 | |||
| 05 دسامبر | 0 | |||
| 04 دسامبر | +5 | |||
| 03 دسامبر | +2 | |||
| 02 دسامبر | 0 | |||
| 01 دسامبر | 0 |
پستهای کانال
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
| 2 | https://t.me/snowflakedevforum
Join the group to interact with other members and get your queries answered. | 0 |
| 3 | 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. | 0 |
| 4 | 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. | 0 |
| 5 | 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. | 0 |
| 6 | Emailing SQL-1.pdf | 0 |
| 7 | Emailing SQL Cheat Sheet.pdf | 0 |
| 8 | Databricks Developer Forum
https://t.me/databricksdevforum
Join the group to post queries related to Databricks. | 0 |
| 9 | https://t.me/snowflakedevforum
Join the group to post your queries related to Snowflake. | 0 |
| 10 | Please do share for benefit of others. | 0 |
| 11 | 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 | 0 |
| 12 | https://cloudedjudgement.substack.com/p/the-modern-data-cloud-warehouse-vs | 0 |
| 13 | https://guides.snowflake.com/ | 0 |
| 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 | 0 |
| 15 | Introduction to External Functions — Snowflake Documentation
https://docs.snowflake.com/en/sql-reference/external-functions-introduction.html | 0 |
| 16 | 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. | 0 |
| 17 | Queries related to Snowflake, please hit the Discuss tab to join the Forum and get inputs from other members of group. | 0 |
| 18 | https://resources.snowflake.com/snowflake-videos/dynamic-data-masking-artin-avanes | 0 |
| 19 | https://www.snowflake.com/blog/column-level-security-in-snowflake/ | 0 |
| 20 | “Snowflake’s SnowPro Certification Exam Preparation Guide — How to pass in 3 days” by Jeno Yamma https://link.medium.com/MhsljnhJX7 | 0 |
