Predictive In-Database Support for Snowflake

[Christopher_Done]

Hi Alteryx,

Can we get the R tools/models to work in database for SNOWFLAKE.

In-Database Overview | Alteryx Help

I understand that Snowflake currently doesn't support R through their UDFs yet; therefore, you might be waiting for them to add it.

I hear Python is coming soon, which is good & Java already available..

However, what about the ‘DPLYR’ package? https://db.rstudio.com/r-packages/dplyr/

My understanding is that this can translate the R code into SQL, so it can run in-DB?

https://docs.snowflake.com/en/release-notes/2015-09.html#snowflake-extension-for-dplyr-pre-productio...

Could this R code package be appended to the Alteryx R models? (maybe this isn’t possible, but wanted ask).

Many Thanks,

Chris

[CristonS]

hi @Christopher_Done, thanks for the feedback. (I included the predictive tag for maximum visibility.) It would be greatly beneficial for our teams to understand how many users would value this sort of update, so be sure to share this with any other Predictive and In-Database users you'd believe would benefit! 

[Christopher_Done]

Hi @CristonS,

Thanks for responding to my suggestion above & tagging it "predictive" for maximum visibility.

I believe multiple people within our wider Alteryx development team would find this useful.

But this could be usefully to ALL companies/alteryx users that use both Snowflake & Alteryx.

I've also ask my Snowflake Rep. to suggest this development upgrade to you/alteryx as well (or at least research to see if it is feasible/possible).

Happy to jump on a quick call & discuss.

Thanks,

Chris