In database tools for Alteryx Designer Cloud

[simonaubert_bd]

Hello

Imagine the dream : Alteryx Designer Cloud with in database tools.

Well, that would be so great I won't write more....

Best regards,

Simon

[MichelleK]

Hello, 

I am excited to announce that all of the tools in the Designer Cloud experience support Snowflake push-down today. I would love to hear more about your idea and other sources you might be looking for.

[simonaubert_bd]

Hello @MichelleK 

Thanks but Snowflake is one cloud database among many... I would like to adress any "big database" that already works with Alteryx Designer on desktop, live MySQL, Hive, etc. and also cloud native database such as Clickhouse.

I'm not sure to understand what you mean by "push-down" ? On Alteryx "classic on premise", in database tools are used to build one or several queries that are executed by the remote database, meaning there are no data transfer on the computer executing the workflow.

On Designer Cloud, we have "import" and "publish". This is highly confusing in my opinion. Import what ? I guess data.. Publish what ? Also data ? Or do you mean "publish query"?  Maybe you should adopt other termes like "import for in memory, write for in-memory, usable for in-database workflow"

Best regards,

Simon

[simonaubert_bd]

Hello,

@MichelleK  Some clarifications made here : https://community.alteryx.com/t5/What-s-New/Building-Connections-in-Designer-Cloud/tac-p/1109254#M4

"In-database (work in progress):
In AAC, this capability you’re asking about has been called pushdown. In the future, this will mean that if the following is true:

• data is hosted in a datastore where this is supported
• data is being written back to the same datastore
• additional technical requirements have been met

Then:

• The transformation is executed in the database

This work is in progress for AAC."2


Best regards,

Simon