During the last post we discussed about Data Governance, a feature of Data Quality. In continuation of the same we will talk about the other features i.e. Auditing, Error Handling, Snowsight, Information Schema to identify Stale tables. Auditing: LOGIN_HISTORY: Comprehensive Audit Trail for all the activity by all users from […]
Read More
During this post we will discuss about the Data Quality features in Snowflake. As per the definition, Data quality is a measure of the condition of data based on factors such as accuracy, completeness, consistency, reliability and whether it’s up to date. Example of data Quality are duplicates, missing data, wrong […]
Read More
Read_Sql() and Fetch_Pandas(): During this post we will discuss different ways to get data from Snowflake to Python. Also we will try to compare the performance in terms of time to fetch data from Snowflake. For this discussion we have considered below three functions and measure the time of each […]
Read More
Recently my friend asked very basic but important difference between Truncate and Delete in snowflake. With respect to Oracle, Truncate reset the high water mark of a table back to “zero” and release allocated space back to dba_free_space. Delete physically deletes data row by row and High-water marks are not […]
Read More
Object tagging is use to track sensitive data, such as PII (Personally Identifiable Information) or PHI (Protected Health Information) data. It enables data stewards to track sensitive data for compliance, discovery, protection and auditing. Snowflake stores the tag and its string value as a key-value pair. For a table or […]
Read More
During this post we will discuss about Serverless TASKS in snowflake. Snowflake tasks allow users to schedule the execution of a SQL statement. Before the Serverless task in place, creation of TASK requires the WAREHOUSE parameter or in other words Warehouse was tightly coupled with the task definition. User have to […]
Read More
