@DRubanov3 how would you be looking to connect to Clickhouse? Is there an ODBC driver or API available?
ODBC connection guide: https://knowledge.alteryx.com/index/s/article/Connecting-to-an-ODBC-Datasource-1583459849470
Take note, there's a GENERIC ODBC option that you could configure: https://help.alteryx.com/20241/en/designer/data-sources/odbc-and-oledb-database-connections.html#odb...
However, it doesn't guarantee a connection, I found this in the second article:
Generic ODBC Option
From the Connect In-DB tool, you can select the Generic ODBC option to attempt a connection to an unsupported data source. This option does not guarantee a successful connection to unsupported data sources
If you want to go down an API connection route, you could use Python (as there's a Python tool within Alteryx) or you could leverage the Download tool and follow along the examples in this article to learn how to connect to an API: https://community.alteryx.com/t5/Engine-Works/APIs-for-Beginners-Integrate-All-the-Systems/ba-p/8074...
Please note, these types of connection will be processed in memory when the data is pulled into Alteryx. You could get around this by using IN-DB tools (https://help.alteryx.com/20232/en/designer/tools/in-database-overview.html) if Clickhouse was supported but it doesn't look like it is currently. You could vote for the feature to be made available here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/Support-ClickHouse-especially-for-in...
All the best,
BS
@DRubanov3 ODBC connection can be added from Alteryx through: Input tool->Set Up a connection->Data sources->Generic (or) select any ODBC link->click on ODBC Admin in the pop-up.
Or Simply search for 'ODBC' in Search bar of your system, select(preferably 64-bit) add the ODBC connection.
