Snowflake support

[fatagun]

Hello,

is snowflake supported? if not is there a plan to support it or timeline ?

Thank you.
Firat.

[aaronburtle]

Snowflake is not currently supported; I will get back to you on future plans.

[aaronburtle]

Hi @fatagun following up, we won't be able to implement the support for Snowflake any time soon, however, as this is an open-source project, we would be willing to accept external contributions to support this and can help you get the work across the finish line if you wanted to contribute.

You can find the currently support database types here: https://github.com/Azure/data-api-builder/blob/main/src/Config/ObjectModel/DatabaseType.cs

Adding snowflake would start with expanding these database types and the various other classes that require individual logic to support those. You'd want to look at DataSource.cs, QueryExecutors, the different engines (query, mutation, etc), metadata providers, and graph ql schema generation (SchemaConverter.cs and SuportedTypes.cs). This will also require additional config validation and Snowflake specific parsing may be required in the RuntimeConfigLoader.cs, along with support through the CLI.

Lastly, some testing would be needed to validate the changes made. We are happy to help you complete this work if it's something you wish to take on.