title
What is Snowflake Database | Snowflake Tutorial | Snowflake Architecture | Edureka

description
🔥Edureka Snowflake Certification Training (Use Code: YOUTUBE20): https://www.edureka.co/snowflake-certification-training This Edureka video on 'What is Snowflake' will give you an overview of Snowflake data warehouse software as a service as well the key features & architecture of Snowflake and will help you understand various important concepts that concern Snowflake. Following pointers are covered in this Snowflake Tutorial: 00:00:00 Agenda 00:01:22 What is a Data Warehouse? 00:02:30 Why Snowflake? 00:04:28 What is Snowflake? 00:05:52 Snowflake Key Features 00:08:28 Snowflake Working Architecture 00:13:20 Snowflake Walkthrough 00:18:44 Data Visualization using Snowflake 00:26:00 Pricing Options ------------------------------------ 🔴Subscribe to our channel to get video updates. Hit the subscribe button above: https://goo.gl/6ohpTV Twitter: https://twitter.com/edurekain LinkedIn: https://www.linkedin.com/company/edureka Instagram: https://www.instagram.com/edureka_learning/ Facebook: https://www.facebook.com/edurekaIN/ SlideShare: https://www.slideshare.net/EdurekaIN Castbox: https://castbox.fm/networks/505?country=in Meetup: https://www.meetup.com/edureka/ ---------𝐄𝐝𝐮𝐫𝐞𝐤𝐚 𝐎𝐧𝐥𝐢𝐧𝐞 𝐓𝐫𝐚𝐢𝐧𝐢𝐧𝐠 𝐚𝐧𝐝 𝐂𝐞𝐫𝐭𝐢𝐟𝐢𝐜𝐚𝐭𝐢𝐨𝐧--------- 🔵 Data Science Online Training: https://bit.ly/2NCT239 🟣 Python Online Training: https://bit.ly/2CQYGN7 🔵 AWS Online Training: https://bit.ly/2ZnbW3s 🟣 RPA Online Training: https://bit.ly/2Zd0ac0 🔵 DevOps Online Training: https://bit.ly/2BPwXf0 🟣 Big Data Online Training: https://bit.ly/3g8zksu 🔵 Java Online Training: https://bit.ly/31rxJcY ---------𝐄𝐝𝐮𝐫𝐞𝐤𝐚 𝐌𝐚𝐬𝐭𝐞𝐫𝐬 𝐏𝐫𝐨𝐠𝐫𝐚𝐦𝐬--------- 🟣Machine Learning Engineer Masters Program: https://bit.ly/388NXJi 🔵DevOps Engineer Masters Program: https://bit.ly/2B9tZCp 🟣Cloud Architect Masters Program: https://bit.ly/3i9z0eJ 🔵Data Scientist Masters Program: https://bit.ly/2YHaolS 🟣Big Data Architect Masters Program: https://bit.ly/31qrOVv 🔵Business Intelligence Masters Program: https://bit.ly/2BPLtn2 -----------------𝐄𝐝𝐮𝐫𝐞𝐤𝐚 PGD 𝐂𝐨𝐮𝐫𝐬𝐞𝐬--------------- 🔵Artificial Intelligence and Machine Learning PGD: https://bit.ly/2Ziy7b1 #edureka #edurekawhatissnowflake #whatissnowflake #snowflaketutorial #snowflakearchitecture #snowflakepricing #snowflakefeature #snowflakedatawarehouse #snowflakeschema #edurekatraining -------------------------------------------------------------------- For more information, please write back to us at sales@edureka.in or call us at IND: +91-9606058418 / US: 18338555775

detail
{'title': 'What is Snowflake Database | Snowflake Tutorial | Snowflake Architecture | Edureka', 'heatmap': [{'end': 164.568, 'start': 146.213, 'weight': 1}, {'end': 1168.978, 'start': 1130.37, 'weight': 0.77}], 'summary': 'Tutorial on snowflake database provides a comprehensive overview of its cloud-based data warehousing solution, emphasizing its features, working architecture, pricing options, flexibility, scalability, high performance, user-friendly ui, and data visualization capabilities, along with detailed insights into its pricing structure and data transfer costs across different regions and cloud providers.', 'chapters': [{'end': 133.829, 'segs': [{'end': 67.277, 'src': 'embed', 'start': 24.621, 'weight': 0, 'content': [{'end': 32.405, 'text': 'One of the first decisions that organizations take is adopting a cloud-based model that offers flexibility, scalability, and high performance.', 'start': 24.621, 'duration': 7.784}, {'end': 38.187, 'text': 'So Snowflake is one cloud-based data warehouse platform provided as software as a service.', 'start': 33.186, 'duration': 5.001}, {'end': 45.709, 'text': 'Hello everyone, this is Drup from Edureka and I welcome you all to this session where I will be talking about what is Snowflake.', 'start': 39.008, 'duration': 6.701}, {'end': 49.57, 'text': "So without any further ado, let's take a look at today's agenda.", 'start': 46.23, 'duration': 3.34}, {'end': 57.633, 'text': 'So we will start this session by first understanding what is a data warehouse and why one should choose Snowflake data warehouse tool,', 'start': 50.271, 'duration': 7.362}, {'end': 58.873, 'text': 'and what actually it is.', 'start': 57.633, 'duration': 1.24}, {'end': 67.277, 'text': 'Moving ahead, we will understand the key features of Snowflake, its working architecture, and we will also have a walkthrough through Snowflake tool.', 'start': 59.534, 'duration': 7.743}], 'summary': 'Organizations adopt cloud-based model for flexibility, scalability, and high performance. snowflake is a cloud-based data warehouse platform provided as software as a service. drup from edureka discusses what snowflake is, its key features, and working architecture.', 'duration': 42.656, 'max_score': 24.621, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/7M13d03LP_8/pics/7M13d03LP_824621.jpg'}, {'end': 116.462, 'src': 'embed', 'start': 88.084, 'weight': 1, 'content': [{'end': 94.725, 'text': 'is system used for reporting and data analysis and is considered a core component of business intelligence.', 'start': 88.084, 'duration': 6.641}, {'end': 101.568, 'text': 'Data warehouses are central repositories of integrated data from one or more disparate sources.', 'start': 95.386, 'duration': 6.182}, {'end': 110.571, 'text': 'They store current and historical data in one single place that are used for creating analytical reports for workers throughout the enterprise.', 'start': 102.268, 'duration': 8.303}, {'end': 116.462, 'text': 'The data stored in the warehouse is uploaded from the operational systems as marketing or sales.', 'start': 111.252, 'duration': 5.21}], 'summary': 'Data warehouse is a core business intelligence component storing integrated data for analytical reports.', 'duration': 28.378, 'max_score': 88.084, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/7M13d03LP_8/pics/7M13d03LP_888084.jpg'}], 'start': 7.714, 'title': 'Snowflake: cloud-based data warehousing', 'summary': 'Discusses the shift to snowflake, a cloud-based data warehousing solution, emphasizing its features, working architecture, pricing options, flexibility, scalability, and high performance for processing big data.', 'chapters': [{'end': 133.829, 'start': 7.714, 'title': 'Snowflake: cloud-based data warehousing', 'summary': 'Discusses the shift from traditional data warehousing to cloud-based solutions like snowflake, highlighting its features, working architecture, and pricing options for data visualization, emphasizing the benefits of flexibility, scalability, and high performance in processing big data.', 'duration': 126.115, 'highlights': ['Snowflake is a cloud-based data warehouse platform provided as software as a service. Snowflake is a cloud-based data warehouse platform offered as software as a service, providing flexibility and scalability.', 'Data warehouses are central repositories of integrated data from one or more disparate sources, used for creating analytical reports for workers throughout the enterprise. Data warehouses serve as central repositories of integrated data used for creating analytical reports for workers, enhancing data-driven decision-making.', 'The session covers key features, working architecture, and pricing options of Snowflake, emphasizing its benefits in processing big data. The session covers key aspects of Snowflake, including its features, architecture, and pricing options, highlighting its benefits in processing big data.']}], 'duration': 126.115, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/7M13d03LP_8/pics/7M13d03LP_87714.jpg', 'highlights': ['Snowflake is a cloud-based data warehouse platform provided as software as a service, offering flexibility and scalability.', 'Data warehouses serve as central repositories of integrated data used for creating analytical reports for workers, enhancing data-driven decision-making.', 'The session covers key aspects of Snowflake, including its features, architecture, and pricing options, highlighting its benefits in processing big data.']}, {'end': 750.504, 'segs': [{'end': 226.165, 'src': 'heatmap', 'start': 146.213, 'weight': 0, 'content': [{'end': 149.436, 'text': 'So for that, we need to understand the uniqueness of Snowflake.', 'start': 146.213, 'duration': 3.223}, {'end': 155.381, 'text': "So now let's understand what makes Snowflake a real deal and why should one consider Snowflake as a solution.", 'start': 149.876, 'duration': 5.505}, {'end': 158.123, 'text': 'First thing is its performance and speed.', 'start': 156.021, 'duration': 2.102}, {'end': 164.568, 'text': 'From multiple virtual warehouses, automatic query optimization, cluster tuning micropartitions.', 'start': 158.763, 'duration': 5.805}, {'end': 168.231, 'text': 'the whole Snowflake architecture is built to allow faster query processing.', 'start': 164.568, 'duration': 3.663}, {'end': 171.477, 'text': 'Second thing is its user-friendly UI.', 'start': 168.835, 'duration': 2.642}, {'end': 177.021, 'text': 'So the Snowflake interface is user-friendly for both users with and without coding experience.', 'start': 171.897, 'duration': 5.124}, {'end': 180.324, 'text': 'ENSA SQL language is used to support general users.', 'start': 177.602, 'duration': 2.722}, {'end': 182.605, 'text': 'Third is its on-demand pricing.', 'start': 180.944, 'duration': 1.661}, {'end': 191.953, 'text': 'So Snowflake offers on-demand pricing meaning that you will only pay based on the amount of data you store and the compute hours per minutes you use.', 'start': 183.026, 'duration': 8.927}, {'end': 198.65, 'text': 'Unlike a traditional data warehouse, Snowflake also gives you the flexibility easily set up the ideal time,', 'start': 192.433, 'duration': 6.217}, {'end': 201.692, 'text': "so you don't need to pay if the warehouse is inactive.", 'start': 198.65, 'duration': 3.042}, {'end': 205.954, 'text': 'Coming to the fourth point, which is Snowflake is highly compatible.', 'start': 202.452, 'duration': 3.502}, {'end': 214.018, 'text': 'So you can query large data sets from various BI tools, means business intelligence tools like Tableau or Einstein Analytics or Tableau CRM.', 'start': 206.274, 'duration': 7.744}, {'end': 222.283, 'text': 'It also provides support for many programming languages such as Python, R, Java, .NET, Go, C, Node.js, etc.', 'start': 214.599, 'duration': 7.684}, {'end': 226.165, 'text': 'Coming to the fifth point, which makes it unique is zero administration cost.', 'start': 222.843, 'duration': 3.322}], 'summary': 'Snowflake offers superior performance, user-friendly ui, on-demand pricing, high compatibility, and zero administration cost.', 'duration': 70.144, 'max_score': 146.213, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/7M13d03LP_8/pics/7M13d03LP_8146213.jpg'}, {'end': 535.366, 'src': 'embed', 'start': 506.602, 'weight': 2, 'content': [{'end': 513.006, 'text': 'Now, with understanding of why choosing Snowflake as a solution and what actually it does, as well as understanding its key features.', 'start': 506.602, 'duration': 6.404}, {'end': 516.398, 'text': "Let's move on to understand the working architecture of Snowflake.", 'start': 513.717, 'duration': 2.681}, {'end': 522.441, 'text': "So Snowflake's architecture is a hybrid of traditional shared disk and shared nothing database architecture.", 'start': 516.878, 'duration': 5.563}, {'end': 527.883, 'text': "Before moving ahead, let's first understand what is shared disk and shared nothing database architectures.", 'start': 523.02, 'duration': 4.863}, {'end': 535.366, 'text': 'So a shared disk architecture, as shown here, is a distributed computing architecture in which the nodes share same disk devices,', 'start': 528.583, 'duration': 6.783}], 'summary': 'Snowflake uses a hybrid architecture combining shared disk and shared nothing, offering a unique solution for data management.', 'duration': 28.764, 'max_score': 506.602, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/7M13d03LP_8/pics/7M13d03LP_8506602.jpg'}, {'end': 738.938, 'src': 'embed', 'start': 708.223, 'weight': 4, 'content': [{'end': 712.785, 'text': 'so? virtual warehouse, often referred to simply as a warehouse, is a cluster of compute resources.', 'start': 708.223, 'duration': 4.562}, {'end': 719.348, 'text': 'in snowflake, a warehouse provides the required resources, such as cpu, memory and temporary storage,', 'start': 712.785, 'duration': 6.563}, {'end': 722.73, 'text': 'to perform the following operations in a snowflake session.', 'start': 719.348, 'duration': 3.382}, {'end': 724.704, 'text': 'So what are these following operations?', 'start': 723.223, 'duration': 1.481}, {'end': 729.249, 'text': 'These are like executing SQL select statements that require compute resources.', 'start': 725.185, 'duration': 4.064}, {'end': 731.391, 'text': 'example, retrieving rows from tables and views.', 'start': 729.249, 'duration': 2.142}, {'end': 738.938, 'text': 'Second operation is performing DML operations such as updating rows in tables like delete, insert or update,', 'start': 732.032, 'duration': 6.906}], 'summary': 'Snowflake virtual warehouse provides compute resources for executing sql select and dml operations.', 'duration': 30.715, 'max_score': 708.223, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/7M13d03LP_8/pics/7M13d03LP_8708223.jpg'}], 'start': 133.829, 'title': 'Snowflake data warehousing overview', 'summary': 'Provides an overview of snowflake data warehousing, highlighting its uniqueness and key features such as performance and speed, user-friendly ui, on-demand pricing, compatibility with bi tools, zero administration cost, and easy data sharing. it also explains the working architecture of snowflake using a hybrid of traditional shared disk and shared nothing database architecture, and its three key layers - database storage, query processing, and virtual warehouses.', 'chapters': [{'end': 750.504, 'start': 133.829, 'title': 'Snowflake data warehousing overview', 'summary': 'Provides an overview of snowflake data warehousing, highlighting its uniqueness and key features, including its performance and speed, user-friendly ui, on-demand pricing, compatibility with bi tools, zero administration cost, and easy data sharing. it also explains the working architecture of snowflake, using a hybrid of traditional shared disk and shared nothing database architecture, and its three key layers - database storage, query processing, and virtual warehouses.', 'duration': 616.675, 'highlights': ["Snowflake offers on-demand pricing, meaning that users will only pay based on the amount of data they store and the compute hours per minutes they use. Snowflake's on-demand pricing model provides cost flexibility based on actual usage, offering potential cost savings for users.", "Snowflake provides compatibility with various BI tools like Tableau, Einstein Analytics, and Tableau CRM, as well as support for multiple programming languages such as Python, R, Java, .NET, Go, C, and Node.js. Snowflake's compatibility with BI tools and programming languages enhances its versatility and integration capabilities for diverse user needs.", "Snowflake's architecture consists of three key layers - database storage, query processing, and virtual warehouses, utilizing a hybrid of traditional shared disk and shared nothing database architecture. Understanding Snowflake's architecture is crucial for users to comprehend its data management simplicity, performance, and scale-out benefits.", "Snowflake processes queries using massively parallel processing compute clusters where each node in the cluster stores a portion of the entire data set locally, offering the data management simplicity of a shared disk architecture with the performance and scale-out benefits of a shared nothing architecture. The unique query processing approach of Snowflake ensures optimized data processing and scalability for users' diverse query requirements.", "Snowflake's virtual warehouses provide the required resources, such as CPU, memory, and temporary storage, for executing SQL select statements, DML operations, and data loading and unloading operations within a Snowflake session. Understanding the capabilities and usage of virtual warehouses is essential for optimizing query performance and data operations within Snowflake."]}], 'duration': 616.675, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/7M13d03LP_8/pics/7M13d03LP_8133829.jpg', 'highlights': ['Snowflake offers on-demand pricing, providing cost flexibility based on actual usage, offering potential cost savings for users.', 'Snowflake provides compatibility with various BI tools and programming languages, enhancing its versatility and integration capabilities for diverse user needs.', "Understanding Snowflake's architecture is crucial for users to comprehend its data management simplicity, performance, and scale-out benefits.", "The unique query processing approach of Snowflake ensures optimized data processing and scalability for users' diverse query requirements.", 'Understanding the capabilities and usage of virtual warehouses is essential for optimizing query performance and data operations within Snowflake.']}, {'end': 1190.538, 'segs': [{'end': 795.944, 'src': 'embed', 'start': 770.231, 'weight': 0, 'content': [{'end': 776.418, 'text': 'the cloud Services layer also runs on compute instances provisioned by Snowflake from the cloud provider.', 'start': 770.231, 'duration': 6.187}, {'end': 784.241, 'text': 'Services managed in the layer include authentication, infrastructure management, metadata management, query parsing and optimization,', 'start': 776.918, 'duration': 7.323}, {'end': 785.461, 'text': 'as well as access control.', 'start': 784.241, 'duration': 1.22}, {'end': 792.303, 'text': "So this is how the complete architecture of Snowflake looks like as I have explained you all the layers and they're working.", 'start': 786.041, 'duration': 6.262}, {'end': 795.944, 'text': 'I hope with this you understand the working architecture of Snowflake.', 'start': 792.823, 'duration': 3.121}], 'summary': "Snowflake's cloud services layer runs on compute instances provisioned by snowflake, managing authentication, infrastructure, metadata, queries, and access control.", 'duration': 25.713, 'max_score': 770.231, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/7M13d03LP_8/pics/7M13d03LP_8770231.jpg'}, {'end': 853.009, 'src': 'embed', 'start': 810.32, 'weight': 2, 'content': [{'end': 815.603, 'text': 'And then in the next page, you will be asked to choose a cloud provider as well on which you want to host.', 'start': 810.32, 'duration': 5.283}, {'end': 821.406, 'text': "So suppose if you're hosting on AWS and Azure or GCP, there are three options only for that.", 'start': 816.223, 'duration': 5.183}, {'end': 824.608, 'text': 'Like host on any of them your Snowflake service.', 'start': 821.946, 'duration': 2.662}, {'end': 827.489, 'text': 'And similarly, the charges will be charged on the basis of that.', 'start': 824.908, 'duration': 2.581}, {'end': 830.611, 'text': "So here you have like today's free trial of Snowflake.", 'start': 828.15, 'duration': 2.461}, {'end': 834.714, 'text': 'So after your signup process, you will receive a activation link on your mail.', 'start': 831.351, 'duration': 3.363}, {'end': 841.92, 'text': 'You can just go to your mail and activate your account from there, create an email and password and log into that user name and password.', 'start': 834.854, 'duration': 7.066}, {'end': 844.121, 'text': 'Like I already created, I completed the process.', 'start': 841.94, 'duration': 2.181}, {'end': 847.544, 'text': 'So I just log into my account.', 'start': 844.862, 'duration': 2.682}, {'end': 849.065, 'text': "So here's my account.", 'start': 848.345, 'duration': 0.72}, {'end': 853.009, 'text': 'Remember that because it is hosted on a cloud provider.', 'start': 849.526, 'duration': 3.483}], 'summary': 'Choose a cloud provider to host snowflake with three available options, and receive a free trial after signing up.', 'duration': 42.689, 'max_score': 810.32, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/7M13d03LP_8/pics/7M13d03LP_8810320.jpg'}, {'end': 1036.609, 'src': 'embed', 'start': 1008.94, 'weight': 5, 'content': [{'end': 1012.302, 'text': 'You can see a different kind of data sets are available here.', 'start': 1008.94, 'duration': 3.362}, {'end': 1015.263, 'text': 'Like with financial, with marketing or commerce.', 'start': 1012.802, 'duration': 2.461}, {'end': 1017.264, 'text': 'Now coming to warehouses.', 'start': 1016.004, 'duration': 1.26}, {'end': 1024.809, 'text': 'So this is whatever warehouse you are going to create that will be available here with all its features showing here, like its size, clusters.', 'start': 1017.485, 'duration': 7.324}, {'end': 1029.547, 'text': 'And when it is resumed, when it is stopped, when it is created, everything and who is the owner of it.', 'start': 1025.546, 'duration': 4.001}, {'end': 1036.609, 'text': 'Now, similarly, if you come to Workshree, this Workshree is same that which we open, which comes in front of the snowflake.', 'start': 1030.308, 'duration': 6.301}], 'summary': 'Various data sets and warehouses available for financial, marketing, and commerce, with details like size, clusters, and ownership.', 'duration': 27.669, 'max_score': 1008.94, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/7M13d03LP_8/pics/7M13d03LP_81008940.jpg'}, {'end': 1121.269, 'src': 'embed', 'start': 1092.146, 'weight': 6, 'content': [{'end': 1093.146, 'text': 'Coming to the partner connect.', 'start': 1092.146, 'duration': 1}, {'end': 1095.448, 'text': 'You can connect to Snowflake, whatever you require.', 'start': 1093.186, 'duration': 2.262}, {'end': 1097.389, 'text': 'Then there is this help option.', 'start': 1095.468, 'duration': 1.921}, {'end': 1102.773, 'text': 'If you require any kind of help, you can like refer the documentation as if you have forgot some step or something.', 'start': 1097.69, 'duration': 5.083}, {'end': 1105.255, 'text': 'How to do something on this data warehousing hosting.', 'start': 1102.813, 'duration': 2.442}, {'end': 1107.997, 'text': 'So you can refer the documentation as well.', 'start': 1105.715, 'duration': 2.282}, {'end': 1109.918, 'text': 'Then you can come to notification.', 'start': 1108.496, 'duration': 1.422}, {'end': 1113.461, 'text': 'Whatever notification has been shown, they are being shown here in the notification panel.', 'start': 1109.978, 'duration': 3.483}, {'end': 1115.563, 'text': 'So this is a simple walkthrough.', 'start': 1114.022, 'duration': 1.541}, {'end': 1121.269, 'text': 'Now there is a snow site as well that I will show you how it works.', 'start': 1116.184, 'duration': 5.085}], 'summary': 'Partner connect allows connection to snowflake, access to documentation, and notification display.', 'duration': 29.123, 'max_score': 1092.146, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/7M13d03LP_8/pics/7M13d03LP_81092146.jpg'}, {'end': 1157.217, 'src': 'embed', 'start': 1130.37, 'weight': 4, 'content': [{'end': 1138.112, 'text': "But that's the cool thing about Snowflake that you don't require any additional like BI tool for that for data visualization.", 'start': 1130.37, 'duration': 7.742}, {'end': 1141.713, 'text': 'So a lot of the visualization can be done internally within the Snowflake.', 'start': 1138.472, 'duration': 3.241}, {'end': 1143.694, 'text': 'So you can just go to Snow site for that.', 'start': 1142.193, 'duration': 1.501}, {'end': 1147.235, 'text': 'Here you will see all the worksheet dashboards, a different kind of window.', 'start': 1144.474, 'duration': 2.761}, {'end': 1148.355, 'text': 'This is like a preview window.', 'start': 1147.275, 'duration': 1.08}, {'end': 1150.115, 'text': 'These kind of details are there.', 'start': 1149.055, 'duration': 1.06}, {'end': 1152.576, 'text': 'We are just going to create a dashboard for right now.', 'start': 1150.495, 'duration': 2.081}, {'end': 1157.217, 'text': 'So you can see like I have created two dashboards already that have been shown here.', 'start': 1153.016, 'duration': 4.201}], 'summary': 'Snowflake enables data visualization internally, no need for additional bi tool. can create dashboards within snowflake.', 'duration': 26.847, 'max_score': 1130.37, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/7M13d03LP_8/pics/7M13d03LP_81130370.jpg'}, {'end': 1168.978, 'src': 'heatmap', 'start': 1130.37, 'weight': 0.77, 'content': [{'end': 1138.112, 'text': "But that's the cool thing about Snowflake that you don't require any additional like BI tool for that for data visualization.", 'start': 1130.37, 'duration': 7.742}, {'end': 1141.713, 'text': 'So a lot of the visualization can be done internally within the Snowflake.', 'start': 1138.472, 'duration': 3.241}, {'end': 1143.694, 'text': 'So you can just go to Snow site for that.', 'start': 1142.193, 'duration': 1.501}, {'end': 1147.235, 'text': 'Here you will see all the worksheet dashboards, a different kind of window.', 'start': 1144.474, 'duration': 2.761}, {'end': 1148.355, 'text': 'This is like a preview window.', 'start': 1147.275, 'duration': 1.08}, {'end': 1150.115, 'text': 'These kind of details are there.', 'start': 1149.055, 'duration': 1.06}, {'end': 1152.576, 'text': 'We are just going to create a dashboard for right now.', 'start': 1150.495, 'duration': 2.081}, {'end': 1157.217, 'text': 'So you can see like I have created two dashboards already that have been shown here.', 'start': 1153.016, 'duration': 4.201}, {'end': 1158.698, 'text': "So I'm going to create a new one.", 'start': 1157.657, 'duration': 1.041}, {'end': 1159.738, 'text': 'You can just go to dashboard.', 'start': 1158.718, 'duration': 1.02}, {'end': 1161.076, 'text': 'Give a name to it.', 'start': 1160.336, 'duration': 0.74}, {'end': 1165.637, 'text': "I suppose I'm going to give SF demo and visualization.", 'start': 1161.476, 'duration': 4.161}, {'end': 1166.978, 'text': "We'll create a dashboard here.", 'start': 1165.937, 'duration': 1.041}, {'end': 1168.978, 'text': 'Now select the new tile here.', 'start': 1167.618, 'duration': 1.36}], 'summary': 'Snowflake enables internal data visualization without additional bi tools, allowing easy creation of dashboards.', 'duration': 38.608, 'max_score': 1130.37, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/7M13d03LP_8/pics/7M13d03LP_81130370.jpg'}], 'start': 750.504, 'title': 'Snowflake architecture, setup, and data visualization', 'summary': "Covers snowflake's architecture, detailing its layers and setup process, and demonstrates its use for data visualization, including querying, creating dashboards, and utilizing sample data, with a focus on features and options within snowflake.", 'chapters': [{'end': 853.009, 'start': 750.504, 'title': 'Snowflake architecture and setup', 'summary': 'Explains the architecture of snowflake, detailing its three layers: storage, compute, and cloud services, and the setup process, including the choice of cloud provider and the activation of a free trial account.', 'duration': 102.505, 'highlights': ['Snowflake architecture consists of three layers: storage, compute, and cloud services, which coordinate activities across snowflake and run on compute instances provisioned by Snowflake from the cloud provider. The architecture of Snowflake consists of three layers: storage, compute, and cloud services, which coordinate activities and run on compute instances provided by Snowflake.', 'The cloud services layer manages authentication, infrastructure and metadata, query optimization, and access control, tying together all the data components of Snowflake to process user requests from login to query dispatch. The cloud services layer manages authentication, infrastructure, metadata, query optimization, and access control to process user requests from login to query dispatch.', 'During the setup process, users are required to choose a cloud provider (AWS, Azure, or GCP) to host their Snowflake service, with charges being based on the selected provider. During the setup, users choose a cloud provider (AWS, Azure, or GCP) to host their Snowflake service, with charges based on the selected provider.', 'After the signup process, users receive an activation link via email to create a username and password, allowing them to log into their account, noting that the service is hosted on a cloud provider. After signup, users receive an activation link via email to create a username and password and log into their account, hosted on a cloud provider.']}, {'end': 1190.538, 'start': 853.549, 'title': 'Using snowflake for data visualization', 'summary': 'Demonstrates how to use snowflake for data visualization, showcasing features such as querying, creating dashboards, and utilizing sample data for visualization, and highlights the availability of different features and options within snowflake, including creating databases, sharing data, and managing warehouses.', 'duration': 336.989, 'highlights': ['Snowflake offers features for querying, creating dashboards, and visualizing data internally, eliminating the need for additional BI tools, with the ability to select and pin sample data for visualization.', 'Users can create databases, share data, and manage warehouses within Snowflake, providing options for creating new databases, sharing data through a data marketplace, and managing warehouses with details on size, clusters, and ownership.', 'The transcript discusses various features and options within Snowflake, including the ability to change roles for specific worksheets, select databases for querying, manage warehouses with details on usage and billing, and access partner connect for additional functionalities and help documentation.', "The walkthrough includes an overview of Snowflake's interface, showcasing options for querying, creating dashboards, and accessing features such as Partner Connect, help documentation, and notifications, highlighting the comprehensive capabilities of Snowflake for data warehousing and data visualization."]}], 'duration': 440.034, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/7M13d03LP_8/pics/7M13d03LP_8750504.jpg', 'highlights': ['The architecture of Snowflake consists of three layers: storage, compute, and cloud services, which coordinate activities and run on compute instances provided by Snowflake.', 'The cloud services layer manages authentication, infrastructure, metadata, query optimization, and access control to process user requests from login to query dispatch.', 'During the setup, users choose a cloud provider (AWS, Azure, or GCP) to host their Snowflake service, with charges based on the selected provider.', 'After signup, users receive an activation link via email to create a username and password and log into their account, hosted on a cloud provider.', 'Snowflake offers features for querying, creating dashboards, and visualizing data internally, eliminating the need for additional BI tools, with the ability to select and pin sample data for visualization.', 'Users can create databases, share data, and manage warehouses within Snowflake, providing options for creating new databases, sharing data through a data marketplace, and managing warehouses with details on size, clusters, and ownership.', "The walkthrough includes an overview of Snowflake's interface, showcasing options for querying, creating dashboards, and accessing features such as Partner Connect, help documentation, and notifications, highlighting the comprehensive capabilities of Snowflake for data warehousing and data visualization.", 'The transcript discusses various features and options within Snowflake, including the ability to change roles for specific worksheets, select databases for querying, manage warehouses with details on usage and billing, and access partner connect for additional functionalities and help documentation.']}, {'end': 1522.354, 'segs': [{'end': 1216.714, 'src': 'embed', 'start': 1190.538, 'weight': 3, 'content': [{'end': 1194.842, 'text': 'you can go to tables first and then you can pin the customers.', 'start': 1190.538, 'duration': 4.304}, {'end': 1199.026, 'text': 'that will come here, customers, and then you can pin orders.', 'start': 1194.842, 'duration': 4.184}, {'end': 1204.451, 'text': 'suppose it will come to a main window and then you can like also pin line item.', 'start': 1199.026, 'duration': 5.425}, {'end': 1205.792, 'text': 'so all these are being pinned here.', 'start': 1204.451, 'duration': 1.341}, {'end': 1207.514, 'text': "that's yeah.", 'start': 1205.792, 'duration': 1.722}, {'end': 1214.721, 'text': 'so here you can see whatever details are there in customer, all the customer names and addresses like, whatever the phone details, account balance.', 'start': 1207.514, 'duration': 7.207}, {'end': 1216.714, 'text': 'These kind of things are we presented here?', 'start': 1215.273, 'duration': 1.441}], 'summary': 'Pin customers, orders, and line items to main window for easy access and view details like customer names, addresses, phone details, and account balance.', 'duration': 26.176, 'max_score': 1190.538, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/7M13d03LP_8/pics/7M13d03LP_81190538.jpg'}, {'end': 1271.353, 'src': 'embed', 'start': 1245.134, 'weight': 0, 'content': [{'end': 1250.198, 'text': 'So you can see all the details of the customer and their order date, total price, everything is being provided here.', 'start': 1245.134, 'duration': 5.064}, {'end': 1256.462, 'text': 'And here you can see different kind of visualizations for the different features that have been shown here like for order date, total price.', 'start': 1250.798, 'duration': 5.664}, {'end': 1260.945, 'text': 'You can see it here and you can get out some meaningful insights from that.', 'start': 1256.482, 'duration': 4.463}, {'end': 1262.526, 'text': 'A clear selection here.', 'start': 1260.965, 'duration': 1.561}, {'end': 1264.128, 'text': 'So this is how it has been done.', 'start': 1263.087, 'duration': 1.041}, {'end': 1269.391, 'text': "Now what you can do is suppose like you can see here there's a different date thing is there, order date.", 'start': 1264.568, 'duration': 4.823}, {'end': 1271.353, 'text': 'So we can filter out the dates as well.', 'start': 1269.411, 'duration': 1.942}], 'summary': 'Detailed customer order information with visualizations for insights and date filtering.', 'duration': 26.219, 'max_score': 1245.134, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/7M13d03LP_8/pics/7M13d03LP_81245134.jpg'}, {'end': 1378.773, 'src': 'embed', 'start': 1354.304, 'weight': 4, 'content': [{'end': 1360.406, 'text': "And it'll be showing here whatever you want to choose for the sum and like data x-axis and y-axis.", 'start': 1354.304, 'duration': 6.102}, {'end': 1361.747, 'text': 'So that you can choose.', 'start': 1360.766, 'duration': 0.981}, {'end': 1363.167, 'text': 'And here you can see the chart type.', 'start': 1361.827, 'duration': 1.34}, {'end': 1364.708, 'text': "Like right now it's line chart.", 'start': 1363.227, 'duration': 1.481}, {'end': 1366.228, 'text': 'We can go for bar as well.', 'start': 1364.728, 'duration': 1.5}, {'end': 1367.269, 'text': "It's been provided here.", 'start': 1366.249, 'duration': 1.02}, {'end': 1369.51, 'text': 'Scatter, heat grid, scorecard, everything is presented.', 'start': 1367.289, 'duration': 2.221}, {'end': 1371.31, 'text': "So let's have a bar graph for it.", 'start': 1369.93, 'duration': 1.38}, {'end': 1374.552, 'text': 'So there are like multiple insights you can see here for this filter.', 'start': 1371.871, 'duration': 2.681}, {'end': 1376.933, 'text': 'Now you can like return to SM demo.', 'start': 1375.192, 'duration': 1.741}, {'end': 1378.773, 'text': 'That is a Snowflake demo of course.', 'start': 1377.313, 'duration': 1.46}], 'summary': 'Demo interface offers various chart types: line, bar, scatter, heat grid, and scorecard. multiple insights available for filter.', 'duration': 24.469, 'max_score': 1354.304, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/7M13d03LP_8/pics/7M13d03LP_81354304.jpg'}, {'end': 1446.539, 'src': 'embed', 'start': 1414.511, 'weight': 1, 'content': [{'end': 1416.552, 'text': 'it and paste it here.', 'start': 1414.511, 'duration': 2.041}, {'end': 1417.112, 'text': "that's it.", 'start': 1416.552, 'duration': 0.56}, {'end': 1418.593, 'text': 'so i will run this.', 'start': 1417.112, 'duration': 1.481}, {'end': 1420.474, 'text': 'so here you can see the total number of orders.', 'start': 1418.593, 'duration': 1.881}, {'end': 1421.995, 'text': "they're 15 000.", 'start': 1420.474, 'duration': 1.521}, {'end': 1423.375, 'text': 'it is after june 1998.', 'start': 1421.995, 'duration': 1.38}, {'end': 1426.517, 'text': 'all the others for 15 000 orders are already here.', 'start': 1423.375, 'duration': 3.142}, {'end': 1429.478, 'text': 'we can just go to this demo just a second.', 'start': 1426.517, 'duration': 2.961}, {'end': 1431.299, 'text': "let's come back to it.", 'start': 1429.478, 'duration': 1.821}, {'end': 1433.24, 'text': 'have it here 15 000.', 'start': 1431.299, 'duration': 1.941}, {'end': 1439.383, 'text': 'so the orders we have got, we can just place it here and we can place this one here.', 'start': 1433.24, 'duration': 6.143}, {'end': 1446.539, 'text': 'so the next thing is, we need to create a heat grid so that can be created from here in this code, a new tile from worksheet.', 'start': 1439.383, 'duration': 7.156}], 'summary': 'Total number of orders is 15,000 after june 1998, and a heat grid needs to be created.', 'duration': 32.028, 'max_score': 1414.511, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/7M13d03LP_8/pics/7M13d03LP_81414511.jpg'}, {'end': 1510.47, 'src': 'embed', 'start': 1481.251, 'weight': 5, 'content': [{'end': 1483.653, 'text': "what's the order status on the basis of that different rankings?", 'start': 1481.251, 'duration': 2.402}, {'end': 1485.855, 'text': "it's been placed here on the basis of rank.", 'start': 1483.653, 'duration': 2.202}, {'end': 1489.598, 'text': 'so for heat grid we are going to customize the data in a different manner.', 'start': 1485.855, 'duration': 3.743}, {'end': 1492.881, 'text': 'like for rows, i will give the customer name.', 'start': 1489.598, 'duration': 3.283}, {'end': 1495.963, 'text': 'for columns, i will give the order status.', 'start': 1492.881, 'duration': 3.082}, {'end': 1498.265, 'text': "so now you can see how it's been summed up.", 'start': 1495.963, 'duration': 2.302}, {'end': 1502.088, 'text': 'for customer wise, This is way better like what we have got before.', 'start': 1498.265, 'duration': 3.823}, {'end': 1506.149, 'text': 'This is a proper segmentation, not the perfect one, but at least to some level.', 'start': 1502.388, 'duration': 3.761}, {'end': 1507.429, 'text': 'So this is the heat grid here.', 'start': 1506.529, 'duration': 0.9}, {'end': 1510.47, 'text': "And now let's go back to the SF demo visualization.", 'start': 1507.649, 'duration': 2.821}], 'summary': 'Customized data arranged by customer name and order status for better segmentation in heat grid.', 'duration': 29.219, 'max_score': 1481.251, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/7M13d03LP_8/pics/7M13d03LP_81481251.jpg'}], 'start': 1190.538, 'title': 'Data visualization and insights', 'summary': 'Covers querying and visualizing customer order data, including table pinning and data presentation, with the ability to extract insights through visualizations and queries. it also includes creating visualizations like line charts, bar graphs, and heat grids and obtaining insights such as 15,000 orders after june 1998 and customer order status rankings.', 'chapters': [{'end': 1264.128, 'start': 1190.538, 'title': 'Data query and visualization', 'summary': 'Demonstrates the process of querying and visualizing customer order data, including details on table pinning and data presentation, with the ability to extract meaningful insights through visualizations and queries.', 'duration': 73.59, 'highlights': ['The chapter emphasizes the process of querying and visualizing customer order data, showcasing the ability to align orders by customers and presenting details such as customer names, addresses, phone details, account balance, order status, order date, and order priority.', 'Demonstrates the utilization of visualizations for different features, enabling the extraction of meaningful insights from the data, such as order date and total price, providing a clear selection for analysis.', 'Illustrates the process of pinning tables, including customers, orders, and line items, to a main window, highlighting the comprehensive data presentation and accessibility.']}, {'end': 1522.354, 'start': 1264.568, 'title': 'Data visualization and insights', 'summary': 'Covers the process of filtering data, creating visualizations like line charts, bar graphs, and heat grids, and obtaining insights such as 15,000 orders after june 1998 and customer order status rankings.', 'duration': 257.786, 'highlights': ['There are 15,000 orders after June 1998. The speaker mentions that all the orders are for 15,000 orders after June 1998, indicating a significant amount of data.', 'The process of creating visualizations like line charts, bar graphs, and heat grids is described. The transcript explains the process of creating various visualizations such as line charts, bar graphs, and heat grids, providing insights into the data through different visual representations.', 'The speaker emphasizes the customization of data for heat grids, providing a proper segmentation for customer-wise order status. The speaker emphasizes customizing data for heat grids to provide a proper segmentation for customer-wise order status, indicating a detailed and focused approach to visualization.']}], 'duration': 331.816, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/7M13d03LP_8/pics/7M13d03LP_81190538.jpg', 'highlights': ['The chapter emphasizes querying and visualizing customer order data, showcasing the ability to align orders by customers and presenting details such as customer names, addresses, phone details, account balance, order status, order date, and order priority.', 'There are 15,000 orders after June 1998, indicating a significant amount of data.', 'Demonstrates the utilization of visualizations for different features, enabling the extraction of meaningful insights from the data, such as order date and total price, providing a clear selection for analysis.', 'Illustrates the process of pinning tables, including customers, orders, and line items, to a main window, highlighting the comprehensive data presentation and accessibility.', 'The process of creating visualizations like line charts, bar graphs, and heat grids is described, providing insights into the data through different visual representations.', 'The speaker emphasizes the customization of data for heat grids, providing a proper segmentation for customer-wise order status, indicating a detailed and focused approach to visualization.']}, {'end': 1811.393, 'segs': [{'end': 1567.846, 'src': 'embed', 'start': 1540.918, 'weight': 2, 'content': [{'end': 1544.219, 'text': 'and they can have the right to see your dashboard.', 'start': 1540.918, 'duration': 3.301}, {'end': 1547.42, 'text': 'Also, if you give the right to view and run, they can run as well.', 'start': 1544.299, 'duration': 3.121}, {'end': 1550.536, 'text': 'you can just view the result or you can also give like.', 'start': 1548.055, 'duration': 2.481}, {'end': 1553.818, 'text': 'you can block them from seeing it, so you can just give an odd view.', 'start': 1550.536, 'duration': 3.282}, {'end': 1554.859, 'text': "that's been done here.", 'start': 1553.818, 'duration': 1.041}, {'end': 1558.401, 'text': 'so this is all about how visualization can be done in snowflake.', 'start': 1554.859, 'duration': 3.542}, {'end': 1563.243, 'text': 'so this was all about the how digitalization can be done in snowflake.', 'start': 1558.401, 'duration': 4.842}, {'end': 1567.846, 'text': "now let's understand the pricing options in different pricing criteria in snowflakes.", 'start': 1563.243, 'duration': 4.603}], 'summary': 'Snowflake allows visualization and digitalization with diverse pricing options.', 'duration': 26.928, 'max_score': 1540.918, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/7M13d03LP_8/pics/7M13d03LP_81540918.jpg'}, {'end': 1716.728, 'src': 'embed', 'start': 1691.9, 'weight': 0, 'content': [{'end': 1697.925, 'text': 'So you can see the charges here, like $46 per terabyte per month for customers deployed in AWS Mumbai.', 'start': 1691.9, 'duration': 6.025}, {'end': 1700.787, 'text': 'Because of course my snowflake is hosted on AWS.', 'start': 1698.185, 'duration': 2.602}, {'end': 1703.069, 'text': "That's why this is the price I will be charged with.", 'start': 1700.807, 'duration': 2.262}, {'end': 1707.393, 'text': 'And if similarly, if someone else is hosted on Azure, that will be a different price.', 'start': 1703.149, 'duration': 4.244}, {'end': 1709.755, 'text': 'And similarly for GCP, they will be different price.', 'start': 1707.613, 'duration': 2.142}, {'end': 1711.396, 'text': 'This was all about on demand.', 'start': 1710.295, 'duration': 1.101}, {'end': 1716.728, 'text': 'If you want to make a pre-purchase capacity, Snowflake provides customers the option pre-purchase capacity.', 'start': 1711.766, 'duration': 4.962}], 'summary': 'Snowflake charges $46 per terabyte per month for customers deployed in aws mumbai, offering pre-purchase capacity options.', 'duration': 24.828, 'max_score': 1691.9, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/7M13d03LP_8/pics/7M13d03LP_81691900.jpg'}, {'end': 1778.543, 'src': 'embed', 'start': 1750.096, 'weight': 1, 'content': [{'end': 1752.778, 'text': "Then if you're going to transfer different region, but the same cloud.", 'start': 1750.096, 'duration': 2.682}, {'end': 1757.24, 'text': "So like, suppose if I want to check for Mumbai, I'll be charged $86.", 'start': 1753.218, 'duration': 4.022}, {'end': 1762.382, 'text': "And similarly, if I've been transferring different cloud, remember this, this is the unit as a per terabyte.", 'start': 1757.24, 'duration': 5.142}, {'end': 1767.525, 'text': "So in Mumbai, I'll be charged $109 for data transfer to a different cloud.", 'start': 1762.943, 'duration': 4.582}, {'end': 1773.82, 'text': 'And this is the price for Microsoft Azure, like similar, in the similar manner to the same cloud provider or different cloud provider,', 'start': 1768.317, 'duration': 5.503}, {'end': 1775.121, 'text': 'or for the same region or different region.', 'start': 1773.82, 'duration': 1.301}, {'end': 1778.543, 'text': 'Similarly, same criteria is for GCP as well.', 'start': 1775.461, 'duration': 3.082}], 'summary': 'Data transfer cost: $86 within same cloud, $109 to different cloud in mumbai.', 'duration': 28.447, 'max_score': 1750.096, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/7M13d03LP_8/pics/7M13d03LP_81750096.jpg'}], 'start': 1522.374, 'title': 'Snowflake pricing and visualization', 'summary': 'Details snowflake visualization, sharing options, access rights, and pricing options, including standard, enterprise, business critical, and virtual private snowflake, with charges of $46 per terabyte per month for on-demand usage in aws mumbai and $25 per terabyte per month for pre-purchase capacity. it also covers data transfer prices for different regions and cloud providers, with costs ranging from $0 to $109 per terabyte.', 'chapters': [{'end': 1669.719, 'start': 1522.374, 'title': 'Snowflake visualization and pricing options', 'summary': 'Details how visualization can be done in snowflake, including sharing options and access rights, and explains the different pricing options and criteria in snowflake, such as standard, enterprise, business critical, and virtual private snowflake, along with the associated features and charges.', 'duration': 147.345, 'highlights': ['Snowflake visualization sharing options include giving different access rights like view run or view results, and the ability to block users from viewing, with the option to share the dashboard via a link. The sharing options in Snowflake allow giving different access rights and blocking users from viewing, with the ability to share the dashboard via a link.', 'Snowflake offers different pricing options including standard, enterprise, business critical, and virtual private snowflake, each with specific features such as multi-cluster data warehouse and dynamic data masking, and associated services like hipa support and azure private link support. Snowflake provides various pricing options with specific features and services tailored to different needs, such as multi-cluster data warehouse and dynamic data masking for enterprise, and hipa support and azure private link support for business critical.', 'Snowflake charges based on storage for virtual data warehouses and cloud services, using credits as a unit of measure, which are consumed when using resources such as virtual warehouses or serverless features. Snowflake charges based on storage and cloud services using credits, which are consumed when using resources like virtual warehouses or serverless features.']}, {'end': 1732.175, 'start': 1669.719, 'title': 'Snowflake pricing and regional charges', 'summary': 'Discusses the pricing of snowflake based on region selection, with charges of $46 per terabyte per month for on-demand usage in aws mumbai, and $25 per terabyte per month for pre-purchase capacity.', 'duration': 62.456, 'highlights': ['Snowflake charges $46 per terabyte per month for on-demand usage in AWS Mumbai, and $25 per terabyte per month for pre-purchase capacity in the same region.', 'Different pricing for on-demand usage based on regions such as AWS, Azure, and GCP.', 'Capacity purchase option with a specific dollar commitment to Snowflake, charged on a monthly basis.']}, {'end': 1811.393, 'start': 1732.195, 'title': 'Snowflake data transfer pricing', 'summary': 'Covers the data transfer prices for different regions and cloud providers, with specific costs for transferring within the same region or to a different cloud, with prices ranging from $0 to $109 per terabyte, concluding with an invitation for queries and a call to action for engagement and learning.', 'duration': 79.198, 'highlights': ['The data transfer prices vary based on the region and whether the transfer is within the same region or to a different cloud provider, with costs ranging from $0 for transfers within the same region to $109 per terabyte for transferring to a different cloud in Mumbai.', 'The pricing structure is similar for different cloud providers such as Microsoft Azure and GCP, with specific costs outlined for transfers within the same cloud provider or to a different cloud provider.', 'The session concludes with an invitation for queries and a call to action for engagement and learning, urging viewers to leave comments, like the video, and subscribe to the Edureka channel for more learning opportunities.']}], 'duration': 289.019, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/7M13d03LP_8/pics/7M13d03LP_81522374.jpg', 'highlights': ['Snowflake charges $46 per terabyte per month for on-demand usage in AWS Mumbai, and $25 per terabyte per month for pre-purchase capacity in the same region.', 'The data transfer prices vary based on the region and whether the transfer is within the same region or to a different cloud provider, with costs ranging from $0 for transfers within the same region to $109 per terabyte for transferring to a different cloud in Mumbai.', 'Snowflake visualization sharing options include giving different access rights like view run or view results, and the ability to block users from viewing, with the option to share the dashboard via a link.']}], 'highlights': ['Snowflake offers on-demand pricing, providing cost flexibility based on actual usage, offering potential cost savings for users.', "The unique query processing approach of Snowflake ensures optimized data processing and scalability for users' diverse query requirements.", 'Understanding the capabilities and usage of virtual warehouses is essential for optimizing query performance and data operations within Snowflake.', 'The architecture of Snowflake consists of three layers: storage, compute, and cloud services, which coordinate activities and run on compute instances provided by Snowflake.', 'The cloud services layer manages authentication, infrastructure, metadata, query optimization, and access control to process user requests from login to query dispatch.', 'During the setup, users choose a cloud provider (AWS, Azure, or GCP) to host their Snowflake service, with charges based on the selected provider.', 'Snowflake offers features for querying, creating dashboards, and visualizing data internally, eliminating the need for additional BI tools, with the ability to select and pin sample data for visualization.', 'The chapter emphasizes querying and visualizing customer order data, showcasing the ability to align orders by customers and presenting details such as customer names, addresses, phone details, account balance, order status, order date, and order priority.', 'Snowflake charges $46 per terabyte per month for on-demand usage in AWS Mumbai, and $25 per terabyte per month for pre-purchase capacity in the same region.', 'The data transfer prices vary based on the region and whether the transfer is within the same region or to a different cloud provider, with costs ranging from $0 for transfers within the same region to $109 per terabyte for transferring to a different cloud in Mumbai.']}