A Compact List of Snowflake Features
- Decoupling of storage and compute in Snowflake
- Auto-Resume, Auto-Suspend, Auto-Scale
- Workload Separation and Concurrency
- Snowflake Administration
- Cloud Agnostic
- Semi-structured Data Storage
- Data Exchange
- Time Travel
- Cloning
- Snowpark
- Snowsight
- Security Features
- Snowflake Pricing
Let’s deep-dive:
1. Decoupling of storage and compute in Snowflake
Snowflake's decoupling of storage and compute features facilitates virtual warehouses and storage as separate entities. Leveraging this functionality of Snowflake, businesses can achieve greater flexibility in choosing the compute of their choice and incrementally pay for what they store and compute. Users can scale up / down or in/out based on the business SLA requirement. Scale up – Scale-out features do not require downtime and are almost instant.
2. Auto-Resume, Auto-Suspend, Auto-Scale
Snowflake's auto-resume and auto-suspend features provide minimal administration. Using auto-resume, Snowflake starts a compute cluster when a query is triggered and suspends compute clusters after a set time of inactivity. These two features ensure performance optimisation, cost management, and flexibility.
In business circumstances where more users are querying heterogeneous queries, setting up auto-scaling can help automatically expand the number of clusters from 1 to 10 at an increment of 1 based on the volume of queries sent to a compute simultaneously.
3. Workload Separation and Concurrency
Concurrency is no longer a problem for Snowflake, unlike traditional data warehouses with concurrency issues where users and processes must compete for resources. Because of Snowflake's multi-cluster architecture, concurrency is not an issue anymore.
This architecture also helps to divide workloads into their virtual warehouse and channel the traffic to each virtual warehouse (compute) by functions or departments.
4. Snowflake Administration
A data cloud as a service is provided by Snowflake (DWaas). Businesses can set up and administer a system without significant assistance from DBA or IT teams. Unlike the on-premise platforms, neither hardware commissioning nor software installation patch-update is s necessary. Snowflake manages software updates and introduces new functions and patches without downtime.
Snowflake automatically creates micro-partitioning. This feature reduces the requirement of manually indexing and clustering tables though these are available features in Snowflake.
5. Cloud Agnostic
Being a cloud-agnostic platform, Snowflake can migrate its workloads with other cloud providers. So, Snowflake is accessible on all three cloud providers: AWS, Azure, and GCP. Customers can easily integrate Snowflake into their existing cloud architecture and choose to deploy in locations preferred by their companies.
6. Semi-structured Data Storage
The requirement to manage semi-structured data, often in JSON format, gave rise to NoSQL database solutions. Data pipelines are created to extract attributes from JSON and mix them with structured data. By leveraging VARIANT, a schema on read data type, Snowflake's design enables storing structured and semi-structured data in the exact location. Both organised and semi-structured data can be stored using the VARIANT data type. Snowflake eliminates the need for data extraction pipelines by automatically analysing data, extracting properties, and saving it in a columnar format.
Snowflake can connect to staging areas like s3 bucket, Azure blob or GCP blob storage to retrieve and transform files stored in these platforms. This is regardless of the cloud Snowflake is hosted. A snowflake-managed staging area is also available. Tasks/ Streams or Snowpipe can be set to retrieve data at a scheduled time or almost instantly, respectively. Snowflake can work with CSV, JSON, XML, Avro, ORC, and Parquet file formats. Snowflake can also store metadata of unstructured data stored in the staging area.
7. Data Exchange
A wide range of data, data services, and applications are available on the Marketplace. From some of the world's top data and solution suppliers, you can find, assess, and buy data, data services, and apps through Marketplace. Direct access to data ready for querying and pre-built SaaS connections virtually eliminates the expenses and delays associated with conventional ETL operations and integration. The risk and hassle of duplicating and relocating outdated material should be avoided. Instead, you can receive automatic updates that are close to real-time and have secure access to shared, controlled, and live data.
8. Time Travel
One of the distinctive Snowflake elements is time travel. You may follow the evolution of data through time by using time travel. All accounts have access to this Snowflake feature, free and enabled by default for everyone. Additionally, this Snowflake feature allows you to retrieve a Table's historical data. At any moment throughout the previous 90 days, one can access the table's appearance.
Time travel encompasses the undrop feature. If an object has not been removed yet by the system, a dropped object can be recovered using the undrop command in Snowflake. When an object is undropped, it returns to its original condition. The option to undrop schemas or tables is also available.
9. Cloning
The clone capability allows us to quickly duplicate anything, including databases, schemas, tables, and other Snowflake objects, in almost real time. Therefore, cloning an object involves editing its metadata rather than duplicating its storage contents. You can quickly produce a clone of the whole production database for testing purposes.
10. Snowpark
With the help of the Snowpark feature, data scientists and data engineers proficient in Python, Scala, R, and Java may create and manage their codes in Snowflake. Snowpark helps to employ the computing capabilities of Snowflake to retrieve, transform, train and apply data science models on the data stored in Snowflake, which has a more apparent performance advantage,
11. Snowsight
The new Snowflake web user interface, Snowsight, replaces the traditional Snowflake SQL Worksheet and enables you to easily construct basic charts and dashboards that can be shared or explored by many users, do data validation while loading data and conduct ad-hoc data analysis. The Snowflake dashboards tool is an excellent option because it works well for individuals or small group users in an organisation who wish to generate straightforward visualisations and share information among themselves.
12. Security Features
Snowflake assures security for its users through the following methods:
- • By adding IP addresses to a whitelist, you may control network policies and limit who can access your account.
- • By supporting several authentication techniques, including federated authentication and two-factor authentication for SSO.
- • Using a hybrid approach of role-based access control and discretionary access control. In role-based access control, privileges are assigned to roles which are then transferred to users. Still, in discretionary access control, each object in the account has an owner who controls access to the object. This hybrid strategy offers a substantial level of flexibility and control.
AES 256 strong encryption is used to automatically encrypt all data, both in transit and at rest.
13. Snowflake Pricing
The advantages of Snowflake pricing are:
- • Pay for actual consumption only.
- • We can cut back on resource use to save costs.
- • Flexible payment. We can either pay on-demand or in advance (pre-purchased).
- • Scale up or down the use of cloud services, computing, and data storage automatically based on your needs.
- • There are no chances of overbuying or overprovisioning.
Optimisation of Snowflake spending through integration with innovative cost-monitoring platforms.
Snowflake stands as an ideal and popular choice because of its unique and updated features. It is also available across many data cloud providers and regions, making it accessible and suitable for all organisations. Why wait? Let’s experience Snowflake. Try now: https://beinex.com/snowflake/.

So, whenever I open the workbook or the extract is refreshed, Tableau displays the unique values within the range specified, giving more control over the parameter values displayed.
Multiple Marks Layer Support for Maps
This is an exceptional feature to bring multiple spatial layers and context together to better understand and analyze geospatial data and map views. I will be able to include multiple marks layers from a data source to map visualizations and enhance the geospatial analysis. I can present more context in a single map view and perform further analysis with this feature.
Block Comments in Calculations
Block comments is a simple yet one of the most useful features for me, which Tableau has announced in 2020.4. I often used to add comments in complex calculations for easy understanding in future references. Earlier, only single-line comments were possible, limiting the description I could add. But from now on, I can add comments of any length to calculation windows with block comments by simply starting the comment with /* and ending with */.
What makes it unique is that the new multi-line block comment feature is consistent with other popular programming languages. This feature is an example of Tableau’s on-going effort to provide its customers with an intuitive user experience.
Tableau Server
Web Authoring Enhancements
Starting from Tableau 2020.4, it is possible to author dashboards from the browser just like how we design it in Tableau Desktop. With this web authoring enhancements, I can include Highlight actions, Format Mark Labels, apply filters to worksheets, create fixed sets, and even create extract in my workbooks from the browser itself. I no longer have to make changes from Tableau Desktop and publish it to the server. I can directly do it from the browser itself.
Offline Map Support for Tableau Server
Rendering dashboards with maps is now faster compared to previous versions. Now, I can create maps using the offline map style in web authoring, ensuring the performance of map views in Tableau Server. Offline map support is a great deal for organizations with strict internet access restrictions, assuring that map view access to all its users.
Tableau Server Management (TSM) Improvements
Tableau Server Administration activities like installation, upgrade and backup are now easy like never before. I can retry installation or upgrade from the last checkpoint in case of an unexpected issue or error during installation or upgrade, saving my efforts to obliterate tableau server.
Backups can be performed twice as fast as previous versions, and I can monitor the progress with the new progress bar giving visibility into what step the backup is on and how much time is remaining.
Backups can also be scheduled using TSM command starting from 2020.4 and that is awesome. I no longer need to prepare batch script and depend on the windows task scheduler to schedule the backups on regular intervals; instead, I can schedule it with just a single command.
Multiple Key Activation on Tableau Server Prior to TSM Initialization
During Tableau Server installation, it is now possible to activate multiple license keys prior to TSM initialization. I will be able to save a lot of time by eliminating the need to restart after the installation is completed to activate multiple licenses and experience a smoother installation.
Analytics Extension for Tableau Online
The power of the Analytics extension is now unlocked in Tableau Online too. The feature was already available in Tableau Server, and it helped us dynamically perform advanced analysis with models and functions in R, Python and other platforms.
Analytics extension in Tableau Online significantly enhances the scope of using Advanced Analytics by the common users.
Merge Duplicate External Assets
Earlier, the Database or Table with similar names used to appear as multiple assets within Tableau Catalog. But, the new feature helps me to merge those multiple assets into a single one. I can manage assets easily and keep an organized view of External assets by merging the common ones.
Tableau Prep
Tableau Prep Builder in the Browser
Prepare the data for visualizations from anywhere using a browser! Starting from 2020.4, Tableau is bringing the data prep process into one integrated platform on the web. Now I can easily prepare and manage prep flows from anywhere using a browser.
Conclusion
Tableau is progressively evolving as a single platform for data preparations, visualization, and collaboration with every update and version release.
Author : Firdous Maqbool
Images Courtesy : Tableau