Ankit Goyal’s Post

Today we are excited to share that we now support importing from Snowflake DDL! If you are a Snowflake user, you can quickly generate a database relationship diagram (ERD) from the DDL of your database objects. 🚀 👉 Read more: https://lnkd.in/gMZPpkXF

I am seeing more and more folks leveraging external tables to easily transfer data in an incremental way from object stores like S3 or GCS into data warehouse environments This is particularly evident with people I speak to on GCP but also on Snowflake which I've written briefly about here https://lnkd.in/dVJQbEht #dataengineering #objectstorage #sql

🚀 Boost Your SQL with Snowflake’s QUALIFY Clause! Looking to simplify your SQL queries? If you are working with Snowflake, the QUALIFY clause is a game-changer when working with window functions! For example, to fetch the most recent transaction for each customer, you can use ROW_NUMBER() combined with QUALIFY to avoid complex subqueries and keep your code clean and efficient. 🔹 Why it rocks: Cleaner code – No subqueries. Improved performance – Less complexity in large datasets. #SQLTips #DataEngineering

Another least known Snowflake function is EXTRACT. It extracts a specified date or time part from a date, time, or timestamp. This function can be particularly useful for breaking down timestamps into more manageable components. Have you ever used it when working with Snowflake or other #sql flavors? There are many alternatives that can be used such as DATE_PART , HOUR / MINUTE / SECOND , YEAR* / DAY* / WEEK* / MONTH / QUARTER, etc. #Snowflake #DataAnalytics #DataEngineering

Snowflake zero copy clone, often referred to as "cloning", is a feature in Snowflake that effectively creates an exact copy of a database, table, or schema without consuming extra storage space, taking up additional time, or duplicating any physical data. #Snowflake #SQL #DataEngineer

🔍 𝗗𝗶𝗱 𝘆𝗼𝘂 𝗸𝗻𝗼𝘄? In Snowflake, you can construct semi-structured arrays and objects using either Snowflake functions or direct notation. This flexibility allows for more dynamic and efficient data manipulation. Check out the example! Here, 𝘰𝘣𝘫𝘦𝘤𝘵_𝘢 is constructed using Snowflake functions, while 𝘰𝘣𝘫𝘦𝘤𝘵_𝘣 uses direct notation. Both methods result in similar objects, giving you the flexibility to choose the best approach for your needs. #Snowflake #SQL #DataEngineering #TechTips #DataAnalytics

#snowflake #limitations #dailybyte #sqlserverVSsnowflake Altering Views in SQL Server vs. Snowflake 🏢 SQL Server ALTER VIEW Statement: In SQL Server, you can modify an existing view using the ALTER VIEW statement. This allows you to change the view definition without dropping and recreating it. ❄ Snowflake ALTER VIEW Limitations: Snowflake’s ALTER VIEW statement is more limited. You cannot change the view definition directly. Instead, you can only modify properties such as renaming the view, adding comments, or converting it to a secure view. Changing View Definition: To change the view definition in Snowflake, you must drop the existing view and recreate it with the new definition.

Lab 5: 🚀 New assignment on Stored Procedures in Snowflake❄️ I'm excited to share my latest assignment on stored procedures in snowflake. ✅Why Stored Procedures? 👉Stored procedures allow to write procedural code that executes SQL. We can use programmatic constructs to perform branching and looping. 👉Stored Procedure is called as an independent statement. 👉As with functions, a stored procedure is created once and can be executed many times. 👉A stored procedure is created with a CREATE PROCEDURE command. Check it out and let me know your thoughts!💬 #DataEngineering #Snowflake #StoredProcedures #RealTimeData #CloudDataWarehouse #BigData #DataAnalytics #SQL #cfbr

🎉 Completed "Getting Started with User-Defined SQL Functions" 🎉 Today, I explored how to create and use User-Defined Functions (UDFs) in Snowflake, which is a game-changer for building custom logic in SQL queries. This hands-on session gave me the tools to write more flexible and reusable SQL code! 🚀 #Snowflake #DataEngineering #SQL #UserDefinedFunctions #LearningJourney

Unlocking Insights with MAX_BY and MIN_BY in Snowflake! CREATE OR REPLACE TEMP TABLE example_table (   id INT,   name VARCHAR,   metric_value INT ); INSERT INTO example_table VALUES  (1, 'A', 50),  (2, 'B', 75),  (3, 'C', 30),  (4, 'D', 90),  (5, 'E', 10); SELECT   MAX_BY(name, metric_value) AS highest_performer,   MIN_BY(name, metric_value) AS lowest_performer FROM example_table; In this query, Snowflake helps us easily identify the highest and lowest performers with a single line of code! #Snowflake #DataEngineering #SQL #DataAnalytics