Introduction Azure Databricks: A Deep Dive Azure Databricks, built on Apache Spark, stands as a powerful analytics platform optimized for Microsoft Azure. It’s designed to facilitate seamless collaboration among data scientists, data engineers, and business analysts. …

At Snowflake, we understand the importance of simplifying the process of working with data. One of Snowflake’s highly compelling features is its native support for semi-structured data, offering flexibility and efficiency to data professionals. …

Abstract The Snowflake Snowpark ecosystem represents a transformative leap in the world of data processing and analytics. With native language support for Java, Scala, and Python, along with a powerful DataFrame API, Snowpark empowers data professionals to harness the full potential of Snowflake’s data platform. …

The Snowpark library offers a user-friendly toolkit for querying and processing data at scale within the Snowflake platform. With Snowpark, you can develop applications that handle data within Snowflake without the need to move data to an external system where your application code resides. …

SQL Updates Introduction of New Function: IS_DATABASE_ROLE_IN_SESSION In this latest release, we introduce a new function: Function Name IS_DATABASE_ROLE_IN_SESSION Description This function is designed to verify whether a database role is within the user’s active primary or secondary role hierarchy for the ongoing session. It can also check if the…

Data Governance Management in Snowsight — Now Generally Available With this release 7.32, snowflake announced the general availability of the Data Governance interface within Snowsight. The Governance interface encompasses a Dashboard tab for monitoring the utilization of the most frequently employed masking policies, row access policies, and tags in relation…

Snowflake has recently introduced an exciting feature that allows SQL commands EXECUTE IMMEDIATE FROM to be triggered directly from files stored in an internal stage. These files can contain SQL statements or scripting blocks. The EXECUTE IMMEDIATE FROM command is designed to execute SQL statements specified within a file located…

Introduction Dynamic tables are a revolutionary feature introduced during the Snowflake Summit 2023 that serve as the fundamental building blocks for declarative data transformation pipelines. They offer a streamlined and automated approach to data engineering in Snowflake, enabling efficient and cost-effective data transformation for consumption. …

Microsoft Fabric and Snowflake are both data platforms that cater to enterprise-level customers, but they have distinct differences in their architecture and functionality. Here’s a brief comparison of the two: Architecture: Microsoft Fabric: Microsoft Fabric, also known as Azure Service Fabric, is a distributed systems platform designed for building scalable…