Forum Discussion

cpshort7186's avatar
cpshort7186
Advocate I
1 year ago

Using Alteryx with Fabric

Is anyone successfully using Alteryx in combination with Fabric?  I have struggled to get alteryx to connect to a lakehouse or data warehouse and am finding that there does not seem to be much/any su...
data warehouse
spencer_sa's avatar
spencer_sa
Impactful Individual
1 year ago

My experiences with Alteryx and Fabric

  • I have successfully read and written csv files to the Files area of a lakehouse using the Alteryx Python tool and the ADLS DFS API.  (I had initial issues using the Blob storage tool so wrote my own in python)
  • I have successfully read from the SQL Endpoint using the Python tool - I've not tried just using the SQL Server connection yet - something for the future. (but as Anonymous shows, it is possible using the ODBC tools)

All of these work with both AZCLI authentication (bleh) and Service Principals (the One True way).  The SQL Endpoint connection requires the SQL Server Driver version 18? or above. (I think 17 was preview only)

 

  • I've not yet tried reading/writing Parquet (mostly a library thing - Arrow), but that is a next step.  I wouldn't try to write a Delta table, simply because I'm pretty sure Fabric does a better job of doing V-Ordering than any python library would - I'd probably just use a Copy Data activity to move to tables.

Going the other way, I've not yet tried triggering an Alteryx Server job from with Fabric using the API, but I have got it working from the command line.  I suspect I'm going to have networking/security issues to make sure that Fabric can connect to the internal network-connected Alteryx Server.