CD2 Adding new dialect - Snowflake
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-14-2024
09:50 AM
Hi all,
We'd like to sync Canvas Data2 to our data warehouse, which is on Snowflake. Snowflake uses its own SQL dialect.
The DAP Client documentation states that it only supports Postgres and MySQL. Prior to the release of v1.0.0, there were instructions on how to create plugins for other SQL dialects for the DAP client (previously at the URL https://data-access-platform-api.s3.amazonaws.com/client/plugins.html), but the instructions are no longer available.
Is it still possible to extend the DAP Client to other SQL languages? We just starting up with Canvas, but we have experience with Python and databases, so if the process is a little complicated, that's fine.