Did you know that Snowflake is working on integrating Microsoft Azure Open AI service? Companies that use Snowflake as their Data Warehousing solution, can now use Azure Open AI through Snowflake CortexAI - Snowflake's managed AI…
After so many years of writing SQL queries, I cannot believe I never came across a QUALIFY query clause. It feels like discovering a treasure in the depths of the database ocean.Even ChatGPT was not aware of it!QUALIFY query clause was…
One Data Engineer had to replicate data from one well-known database vendor to a less-known database vendor.He used select count(*) to validate that tables row counts were equal on the source and target.It worked so slowly, that he got…
