Curious Question: Export SQL query (script) from Alteryx Workflows
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Community
I have a question out of curiosity.
Can I export a SQL query out of Alteryx workflows I have created? If yes, How do I do that? Can you please point me to the right direction?
If yes, then I have multiple environments AWS or Azure. Currently, I am using .csv files and applying joins into/calculations but, if i was to extract the data out from the server can I extract a sql query out from Alteryx? How?
Thanks,
Solved! Go to Solution.
- Labels:
- Database Connection
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Speaking from a SQL Server perspective, the way I would do this is move the data extraction code onto the server as a view (or stored procedure). Then you make Alteryx read from the that as per your normal workflow.
To get the SQL text out, write another view that uses INFORMATION.SCHEMA (or equivalent) to extract the SQL text from the server to get that into your workflow.
Hope this helps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @udles5666 ,
Yes you can do that if you are using the In-DB Tools.
Those In-DB tools generate SQL in the back and you can extract the query using the Dynamic Output In-DB tool.
Best regards
Phil
