Amulya Kumar pandaSome Easy approaches to removing duplicate records from a table in Snowflake?We are encountering a significant challenge in managing duplicate records in our Snowflake table, especially when dealing with high data…Jun 22Jun 22
Amulya Kumar pandaLoad file in Snowflake using Jupyter Notebook.How to connect snowflake to Jupyter notebook ?Apr 2Apr 2
Amulya Kumar pandaManaging complex hierarchies and relationships can be challenging, but Snowflake makes using…Joins a table to itself to process hierarchical data in the table. The CONNECT BY subclause of the FROM clause iterates to process the…Jan 7Jan 7
Amulya Kumar pandainDev GeniusTask scheduling and triggered tasks both perform the same function in Snowflake, but task…Triggered tasks execute when a stream has data. They were originally set to run every minute with SCHEDULE=’1 minute’ and WHEN…Jan 42Jan 42
Amulya Kumar pandainDev GeniusChanges and Stream are working the same type in Snowflake.CHANGES The CHANGES clause enables querying the change tracking metadata for a table or view within a specified interval without creating a…Jan 3Jan 3
Amulya Kumar pandaWe insert and update data directly in the Snowflake table from the blob stage without using an…We can load data from the Azure blob stage to the Snowflake table without any intermediate stage and we can also update and insert in the…Nov 13, 2023Nov 13, 2023
Amulya Kumar pandaADD and DROP a column in the ALTER TABLE in a snowflake.ALTER TABLE: Support for IF [NOT] EXISTS with ADD COLUMN and DROP COLUMN.Oct 25, 2023Oct 25, 2023
Amulya Kumar pandaDynamic tables compared to streams and tasks.Like streams and tasks, dynamic tables provide a way to transform data in your pipeline.Oct 21, 2023Oct 21, 2023
Amulya Kumar pandaColumn aliases for aggregates and the GROUP BY ALL clause.Previously, if a SELECT statement with a GROUP BY ALL clause defined and referred to a column alias for an aggregate, the statement would…Oct 19, 2023Oct 19, 2023
Amulya Kumar pandaDifference between DIV0 and DIV0NULL in Snowflake.Div0 and Div0null is an interesting arithmetic function in Snowflake.Oct 18, 2023Oct 18, 2023