Snowflake Micro-Partitions

When data is loaded into Snowflake, it is automatically divided into micro-partitions, which are contiguous units of storage. Tables are transparently partitioned using the ordering of the data as it is inserted/loaded and groups of rows in tables are mapped into individual micro-partitions, organized in a columnar fashion. This size and structure allows for extremely granular pruning of very large tables, which can be comprised of millions, or even hundreds of millions, of micro-partitions. There are a variety of benefits associated with micro-partitioning and we’ll cover some of them in this event. Additional Information on Snowflake Micro-Partitions can be found here 👉 https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions and here 👉 https://community.snowflake.com/s/article/understanding-micro-partitions-and-data-clustering Anyone interested in the code we use during our events can check us out on GitHub 👉 https://github.com/aicglabs/meetups-a... You can also access blog posts associated with our content at: https://medium.com/datalakehouse https://www.aicg.com/blog/ https://www.datalakehouse.io/resources/blog/ And you can find all videos from our events on the AICG YouTube channel here 👉 https://www.youtube.com/channel/UCXn_... 👋 Please take 2 seconds to Follow us on LinkedIn and Twitter 🙂 https://www.linkedin.com/company/data... https://twitter.com/datalakehouse We're also on Instagram and Facebook if you prefer those platforms: https://www.instagram.com/datalakehouse/ https://www.facebook.com/DataLakeHouse Feel free to comment any questions you have for us and we'll be sure to answer them as soon as possible. Invite a friend or colleague and join us for our next event 👉 https://www.meetup.com/carolinas-snow... Plus, we've gone pro now and are associated with the Modern Data Professionals Meetup Network where you can find other great data-driven Meetup groups to join. You can check it out here 👉https://www.meetup.com/pro/modern-dat... ❄️ Interested in trying Snowflake for free? Get started here 👉 https://trial.snowflake.com/?owner=SP... Find a Snowflake Data for Breakfast World Tour Event near you 👉 https://www.snowflake.com/data-for-breakfast/ Join the DataLakeHouse Slack Community 👉 https://www.datalakehouse.io/join-the-datalakehouse-community/ --- Lastly, we're always looking for contributors to our events. If you're a company currently using Snowflake for your business data demands please reach out and let us know if you'd like to tell us about how you're using Snowflake with your data and business requirements.