PinnedDavid RuthvenConnect Oracle to the Snowflake Data CloudThe Snowflake Data Cloud provides instant access to a substantial and growing library of valuable datasets. This includes second party…Mar 24, 20211Mar 24, 20211
David RuthvenSnowflake as a Query Engine Agnostic Data Distribution NetworkWhat do I mean by Query Engine Agnostic Data Distribution Network?Apr 18Apr 18
David RuthvenManage Cloud Costs with SnowflakeAll cloud based solutions are usually accused at some point of being expensive. This is because they generally make it easier to consume…Dec 6, 2023Dec 6, 2023
David RuthvenVertica to Snowflake Migration: Lessons LearnedBetter than imaginedNov 15, 20231Nov 15, 20231
David RuthvenPython Dataframes — via Snowpark an alternative to Oracle PL/SQLIt is difficult to find an alternative to PL/SQL for Data Engineering. PL/SQL is extremely efficient at querying and manipulating data and…Sep 29, 2023Sep 29, 2023
David RuthvenSnowpark for Python … Code FasterOne of the primary reasons that programming languages like Python are so popular with data engineers, data scientist and application…Mar 27, 2023Mar 27, 2023
David RuthvenSnowflake Query Optimiser Eliminating Redundant JoinsRecently Snowflake introduced an optimisation which leverages Primary and Foreign keys. In essence it is possible for the query optimiser…Dec 21, 2022Dec 21, 2022
David RuthvenOracle-Snowflake Connector from Snowflake Partner dataconsulting.plAmongst my many highly popular blog posts (😃) some of the most popular are those that talk about connecting Oracle to Snowflake…Nov 26, 2022Nov 26, 2022
David RuthvenSnowflake for Marketing Analytics: Siloes to SalesMarketing is something every company must invest in, even well-known brands. In the past, understanding who to market to and how effective…Sep 2, 2022Sep 2, 2022