Writing tab delimited file to Azure Blob Container

Question

I want to connect to HANA DB, grab some data from there and write it to an Azure Blob container.  I know the HANA part is supported in Alteryx Designer.  Is the writing the file from HANA to an Azure Blob Container supported?  If so, where is the documentation and an example of how to do this?

BrandonB · Answer

Even if a platform doesn't have a connector but does have a REST API, it is possible to make API calls using the Download tool with the appropriate HTTP Actions (Get Post Put Delete Head, etc)

Here is a guide to creating your own connector: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Guide-to-Creating-Your-Own-Connector-Series/ta-p/23578

toddcoder23 · Answer

You know how when you choose snowflake as an output file option, it gives you choice of using S3 or local.  When will you have a choice there that says Azure OR how can I create a solution myself that will use Azure Blob containers as an intermediate step to stage my files before being copied into Snowflake?  That is another question I have.  Thanks.

BrandonB · Answer

Microsoft Azure Data lake is natively supported by Alteryx: https://help.alteryx.com/current/designer/microsoft-azure-data-lake-store

Other services that aren't officially listed here https://help.alteryx.com/current/designer/data-sources can often still be connected to via Alteryx, but you may need to leverage API calls using the Download tool or Python/R Libraries.

There are some individuals have been building their own API calls as seen here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Azure-Blob-Storage-Download-amp-Upload-Tool/td-p/559067. These aren't official Alteryx tools, but it may be useful to take a look at if you are interested in understanding how something like this could be done.