PinnedConnect 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 datasets such as data from partners, suppliers and customers as well as third party datasets including industry datasets, government, geographic and environment datasets. …Snowflake4 min readSnowflake4 min read
Dec 21, 2022Snowflake Query Optimiser Eliminating Redundant JoinsRecently Snowflake introduced an optimisation which leverages Primary and Foreign keys. In essence it is possible for the query optimiser to decide not to perform a join if none of the data from the joined table is required to satisfy the query. You could argue that this mainly applies to…3 min read3 min read
Nov 26, 2022Oracle-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. Unfortunately, there is no Oracle Transparent Gateway for Snowflake and the ODBC connector is not very robust, however Snowflake partner Data Consulting have developed a connector which leverages…6 min read6 min read
Sep 2, 2022Snowflake 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 your adverts were on billboards, posters, in newspapers and magazines and on (linear) TV mainly had to rely on customer surveys and questionnaires “How did you hear about…Snowflake6 min readSnowflake6 min read
Sep 2, 2022Snowflake 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 your adverts were on billboards, posters, in newspapers and magazines and on (linear) TV mainly had to rely on customer surveys and questionnaires “How did you hear about…Snowflake6 min readSnowflake6 min read
Feb 7, 2022Optimize Exadata with Gluent’s Live Migration to SnowflakeGluent’s Live Migration capability allows you to migrate as much or as little of your data warehouse workloads from Exadata to Snowflake. This ranges from no code query offload to full migration. The key is Gluent’s ability to run Oracle data warehouse workloads with Snowflake acting as a super-smart backend…4 min read4 min read
Jan 13, 2022Oracle Data Warehouse to Snowflake: Incremental Migration with GluentMigrating from an Oracle Data Warehouse is a long-term project. Whether the end goal is to fully migrate, reduce the strain on your Oracle Data Warehouse to avoid expanding your Oracle footprint or to leverage the best of Oracle and Snowflake combined with a Hybrid Transactional and Analytics Processing (HTAP)…Snowflake Data Warehouse7 min readSnowflake Data Warehouse7 min read
Nov 10, 2021Accelerate Oracle Data Warehouse Queries with Gluent and SnowflakeFaster, Smarter storage One method to increase the performance of data warehouse is to attach faster storage. Data warehouse queries rely heavily on scanning large volumes of data so high throughput low latency storage is an effective way to improve performance without having to tune or change any SQL code. An even better…Data Warehousing4 min readData Warehousing4 min read
Oct 19, 2021Shrink Oracle and quickly leverage Snowflake with GluentOne of the many things Gluent has in common with Snowflake is it appears too good to be true. …7 min read7 min read
Aug 4, 2021Oracle Customers can now seamlessly use the Snowflake Data CloudSnowflake’s Data Grid underpinned by our Data Sharing capability is unique in the industry for its ease of use, security, cross cloud, global reach and rapidly growing range of datasets and data providers through our Data Marketplace. …Snowflake Data Cloud4 min readSnowflake Data Cloud4 min read
