{"id":5123,"date":"2026-02-24T12:25:23","date_gmt":"2026-02-24T12:25:23","guid":{"rendered":"https:\/\/www.arivonix.ai\/techsupport\/docs\/adding-sql-transformation\/"},"modified":"2026-03-02T11:26:35","modified_gmt":"2026-03-02T11:26:35","password":"","slug":"adding-sql-transformation","status":"publish","type":"docs","link":"https:\/\/www.arivonix.ai\/documentation\/docs\/adding-sql-transformation\/","title":{"rendered":"Add SQL Transformation"},"content":{"rendered":"<section class=\"documentation-content\">\n<h1>Adding SQL Transformation<\/h1>\n<p>SQL transformations allow users to apply SQL queries to modify and analyze data within workflows.<\/p>\n<ol>\n<li>Click the <strong>Plus<\/strong> icon and select <strong>SQL<\/strong> from the options. <img decoding=\"async\" class=\"img-fluid img-screenshot\" src=\"\/documentation\/tech-image\/Tech\/SQL_Transformation\/image_6.72.png\/\" alt=\"Relevant visual\" \/><\/li>\n<li>Provide the following details:\n<ul>\n<li><strong>Transformation Name<\/strong><\/li>\n<li><strong>Description<\/strong><\/li>\n<\/ul>\n<\/li>\n<li>Review available data tables in the left side panel.<\/li>\n<li>Enter the SQL query in the main panel.<\/li>\n<li>Click the <strong>Run<\/strong> icon in the top right corner to execute the query. <img decoding=\"async\" class=\"img-fluid img-screenshot\" src=\"\/documentation\/tech-image\/Tech\/SQL_Transformation\/image_42.43.png\/\" alt=\"Relevant visual\" \/><\/li>\n<li>Review the query results preview at the bottom of the screen.<\/li>\n<li>Click <strong>Save<\/strong> to preserve the transformation. <img decoding=\"async\" class=\"img-fluid img-screenshot\" src=\"\/documentation\/tech-image\/Tech\/SQL_Transformation\/image_55.25.png\/\" alt=\"Relevant visual\" \/><\/li>\n<li>Click <strong>Close<\/strong> to exit the modal. <img decoding=\"async\" class=\"img-fluid img-screenshot\" src=\"\/documentation\/tech-image\/Tech\/SQL_Transformation\/image_61.01.png\/\" alt=\"Relevant visual\" \/><\/li>\n<\/ol>\n<p>The SQL transformation will now appear in the workflow.<\/p>\n<\/section>\n","protected":false},"excerpt":{"rendered":"<p>Adding SQL Transformation SQL transformations allow users to apply SQL queries to modify and analyze data within workflows. Click the Plus icon and select SQL from the options. Provide the following details: Transformation Name Description Review available data tables in the left side panel. Enter the SQL query in the main panel. Click the Run [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[178],"doc_tag":[],"class_list":["post-5123","docs","type-docs","status-publish","hentry","doc_category-workflow-designer"],"year_month":"2026-04","word_count":97,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"Hari","author_nicename":"hari","author_url":""},"doc_category_info":[{"term_name":"Workflow Designer","term_url":"https:\/\/www.arivonix.ai\/documentation\/docs-category\/workflow-designer\/"}],"doc_tag_info":[],"_links":{"self":[{"href":"https:\/\/www.arivonix.ai\/documentation\/wp-json\/wp\/v2\/docs\/5123","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.arivonix.ai\/documentation\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.arivonix.ai\/documentation\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.arivonix.ai\/documentation\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.arivonix.ai\/documentation\/wp-json\/wp\/v2\/comments?post=5123"}],"version-history":[{"count":2,"href":"https:\/\/www.arivonix.ai\/documentation\/wp-json\/wp\/v2\/docs\/5123\/revisions"}],"predecessor-version":[{"id":5340,"href":"https:\/\/www.arivonix.ai\/documentation\/wp-json\/wp\/v2\/docs\/5123\/revisions\/5340"}],"wp:attachment":[{"href":"https:\/\/www.arivonix.ai\/documentation\/wp-json\/wp\/v2\/media?parent=5123"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www.arivonix.ai\/documentation\/wp-json\/wp\/v2\/doc_category?post=5123"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.arivonix.ai\/documentation\/wp-json\/wp\/v2\/doc_tag?post=5123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}