Hi all,
I'm currently running an Alteryx Pilot, trying to build value as fast as I can. I've done some research but can seem to find exactly what I need.
I'm trying to create a view in Hadoop, with a LIMIT of a few hundred records. For context, I prefer using a view because our data changes daily, and I don't want to go thru the trouble of updating the table daily. I'm sure this could be automated in the back-en, but I'm just an end-user here, limited technical skills and permissions.
My Alteryx workflow is all made using In-DB tools.
Today, the way we get our extracts onto tableau server is by :
- Create a view in HUE with a LIMIT in our query
- Connect to the View in Tableau desktop
- Publish the datasource Extract to Server
- Setup the data extract refresh schedule
- Go back in HUE, and run an ALTER statement to remove the LIMIT in the query
I'm unsure how to accomplish steps 1 and 5 with Alteryx. I'm assuming I could run the workflow twice, once with a limit, and re-run without said limit. The Write Data In-DB tool doesnt have a limit parameter.
Any ideas? Thanks in advance.
