Re: Snowflake on Oracle
Date: Thu, 13 Apr 2023 12:12:05 -0400
Message-Id: <90DB723D-753D-453A-A522-683CEB4084F2_at_gmail.com>
Kyle - I was about to make the same point. I have worked on a number of projects to move Oracle data to Snowflake for DW . Golden Gate has an adapter / agent to support Snowflake . There are also products from Fivetran , Confluent , and Delphix . I do not work on Snowflake directly , but my colleagues do , and the SQL interoperability with oracle is pretty good . Keep in mind that Snowflake is a cloud hosted system and not available as a product you can download , but I think a dev account is easy to get . All of my projects used SF on Azure but AWS and GCS also host it.
Sent from my Atari 2600
> On Apr 13, 2023, at 12:31 AM, kyle Hailey <kylelf_at_gmail.com> wrote:
>
>
>
> Totally new databse which is amazing ... ie that someone would try and write a database from scratch but these aren't just anybody . The principal architects are Thierry and Benoit who were kernel architects from Oracle, so no surprise there there might be some Oracle look and feel. The other founder Marcin had worked on a few database kernels though all I see via google searches is his DB Vectorwise.
>
>> On Wed, Apr 12, 2023 at 7:44 PM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:
>>> On 4/12/23 19:50, Alan Sterger wrote: >>> So the question, does anyone know if Snowflake is built on top of Oracle?
>> Snowflake is a columnar store database, not meant for OLTP. The data is stored in a series of columns, with compression, of course. It is not related to Oracle in any shape or form. Having said that, they're both RDBMS-es which run on Linux. That's as far as the similarity goes. Snowflake is written completely anew, so it's not a derivative of any other database. It supports ANSI 2000 SQL without anything resembling PL/SQL. However, SF is a data warehouse software so it doesn't need PL/SQL. If you need something to compare SF to, think Vertica, not Oracle. SF isn't PostgreSQL compatible but the rest is quite similar: compression, columnar store and optimization for math.
>>
>> --
>> Mladen Gogala
>> Database Consultant
>> Tel: (347) 321-1217
>> https://dbwhisperer.wordpress.com
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 13 2023 - 18:12:05 CEST