Configuring Alteryx

To configure the Alteryx analytics conversion stage, follow the below steps:

In Source Type, select the source data source as Alteryx.
In Original Data Source, upload the files that you need to transform to the target source.

In Target Type, select the preferred target type, such as AWS Glue Notebook, Databricks Lakehouse, or Spark.
Click Data Configuration.

The Input column in the table below provides the input requirements based on the Target Type selection.

Source Type	Target Type	Input
Alteryx	AWS Glue Notebook	In Output Type, select Python as the output type format for the generated artifacts. In Source Database Connection, select the required source database to load the data such as Oracle, SQL Server, Teradata, Netezza, DB2, Vertica. In S3 Bucket Base Path, provide the S3 storage repository path where you need to store the source and target files. In Artifacts Location, specify the location from where you need to call external files such as parameter files, orchestration scripts.
	Databricks Lakehouse	In Output Type, select Python as the output type format for the generated artifacts. In Source Database Connection, select the required source database to load the data such as Oracle, SQL Server. In DBFS File Base Path, specify the DBFS (Databricks File System) location where you need to fetch the input files and store the transformed data. In other words, it is a base path for input files and output data.
	Spark	In Output Type, select Python as the output type format for the generated artifacts. In Source Database Connection, select the required source database to load the data such as Oracle, SQL Server, Teradata, Netezza, DB2, Vertica. In File Base Path, specify the base path for input files and output data. In Artifacts Location, specify the location from where you need to call external files such as parameter files, orchestration scripts.

Click Save to update the changes.
Click to provide a preferred pipeline name.
Click to execute the pipeline. Clicking (Execute) navigates you to the listing page which shows your pipeline status as Running state. It changes its state to Success when it is completed successfully.
Click pipeline card to see report.

To view the Alteryx Transformation Stage report, visit Alteryx Transformation Report