Snowflake support

[brettrowberry]

@plexus mentioned in his talk at ClojureConj 2023, BI and Reporting for Datomic, that it would be possible to have Plenish publish to Snowflake. How might one go about this?

[humorless]

Hi @brettrowberry,

I do not have first hand experience on using Plenish with Snowflake. I heard some of my friends told me that the SQL of Postgres are quite similar to Snowflake, so I think you can first assume the subset of SQL that Plenish use are the same.

With the assumption, you can try like this:
(1) Use the example here.
(2) Read the README and setup most of the things, but change Postgres to Snowflake.
(3) You probably also need to change the deps.edn, so it can connect to Snowflake.
(4) Change this line.

[plexus]

In general plenish can be adapted to any jdbc compatible database that has an upsert operation. Currently things are hard coded to use postgres sql and data types, but a next iteration will likely add a level of abstraction so we can easily extend the number of databases we support.

Companies interested in specific target databases should get in touch with us at Gaiwan.co, ideally we can find multiple interested parties that want to contribute, so each can shoulder a small part of the development cost.

[humorless]

@brettrowberry

Hell Brett,

Recently, I just added the DuckDB support into Plenish. Through this process, I changed a few internal implementation of Plenish to make it easier to be extended. For example, now, you can create a DB adapter and then swap out the critical functions inside the Plenish.

Ref

Hope that it will make you feel easier to implement a Snowflake adapter. If it is company's interest, please consider to reach out us.