{"id":3603,"date":"2026-04-20T13:35:01","date_gmt":"2026-04-20T12:35:01","guid":{"rendered":"https:\/\/france.magicsoftware.com\/blog\/?p=3603"},"modified":"2026-04-20T17:07:07","modified_gmt":"2026-04-20T16:07:07","slug":"databricks-magicxpi","status":"publish","type":"post","link":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/databricks-magicxpi\/","title":{"rendered":"databricks &#8211; Magicxpi"},"content":{"rendered":"\n<p><strong>Goal : run a databricks job through REST api with Magic xpi<\/strong><\/p>\n\n\n\n<p><strong>Prequisites :<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>access to databricks endpoint<\/li>\n\n\n\n<li>PAT (Personal Access Token for free edition) or Oauth2 ( for enterprise edition).<\/li>\n\n\n\n<li>table defined in catalog<\/li>\n\n\n\n<li>notebook<\/li>\n<\/ul>\n\n\n\n<p>1\/ Generate your PAT in the user\/developer settings<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"317\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG2-1024x317.png\" alt=\"\" class=\"wp-image-3607\" style=\"width:853px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG2-1024x317.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG2-300x93.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG2-768x238.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG2-1536x475.png 1536w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG2.png 1897w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>2\/ Create a table in your catalog<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"278\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG4-1024x278.png\" alt=\"\" class=\"wp-image-3610\" style=\"width:865px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG4-1024x278.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG4-300x81.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG4-768x208.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG4-1536x417.png 1536w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG4.png 1902w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"390\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG3-1024x390.png\" alt=\"\" class=\"wp-image-3609\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG3-1024x390.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG3-300x114.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG3-768x293.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG3-1536x586.png 1536w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG3.png 1875w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>3\/ create a notebook in your workspace<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"290\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG5-1024x290.png\" alt=\"\" class=\"wp-image-3612\" style=\"width:844px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG5-1024x290.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG5-300x85.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG5-768x218.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG5-1536x436.png 1536w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG5.png 1900w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Copy\/Paste the below python script<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import json\nfrom pyspark.sql import Row\n\ndbutils.widgets.text(\"payload\", \"{}\")\nraw = dbutils.widgets.get(\"payload\")\ndata = json.loads(raw)\n\n# Transforme en DataFrame (1 ligne)\ndf = spark.createDataFrame(&#91;Row(\n    order_id=data&#91;\"order_id\"],\n    customer_id=data&#91;\"customer\"]&#91;\"id\"],\n    customer_name=data&#91;\"customer\"]&#91;\"name\"],\n    total=float(data&#91;\"total\"]),\n    items_json=json.dumps(data&#91;\"items\"]),\n    ingested_at=spark.sql(\"SELECT current_timestamp()\").collect()&#91;0]&#91;0]\n)])\n\n# \u00c9crit en mode append dans une table Delta (Unity Catalog)\ndf.write.mode(\"append\").saveAsTable(\"workspace.default.orders\")\n\ndbutils.notebook.exit(json.dumps({\"status\": \"ok\", \"order_id\": data&#91;\"order_id\"]}))<\/code><\/pre>\n\n\n\n<p>4\/ create a Job<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"288\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG6-1024x288.png\" alt=\"\" class=\"wp-image-3613\" style=\"width:900px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG6-1024x288.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG6-300x84.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG6-768x216.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG6-1536x432.png 1536w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG6.png 1905w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>set the previous notebook<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"472\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG7-1024x472.png\" alt=\"\" class=\"wp-image-3615\" style=\"width:881px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG7-1024x472.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG7-300x138.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG7-768x354.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG7-1536x708.png 1536w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG7.png 1894w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>5\/ Before running the job, you can populate your payload with a valid json<\/p>\n\n\n\n<p>Go to Job parameters, set the <strong>key <\/strong>to : <strong>payload<\/strong> and the <strong>value <\/strong>to <strong>{\u00ab\u00a0order_id\u00a0\u00bb:\u00a0\u00bbA130&Prime;,\u00a0\u00bbcustomer\u00a0\u00bb:{\u00ab\u00a0id\u00a0\u00bb:43,\u00a0\u00bbname\u00a0\u00bb:\u00a0\u00bbSaad\u00a0\u00bb},\u00a0\u00bbitems\u00a0\u00bb:[{\u00ab\u00a0sku\u00a0\u00bb:\u00a0\u00bbX1&Prime;,\u00a0\u00bbqty\u00a0\u00bb:3},{\u00ab\u00a0sku\u00a0\u00bb:\u00a0\u00bbY7&Prime;,\u00a0\u00bbqty\u00a0\u00bb:9}],\u00a0\u00bbtotal\u00a0\u00bb:303}<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"242\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG8-1024x242.png\" alt=\"\" class=\"wp-image-3617\" style=\"width:926px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG8-1024x242.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG8-300x71.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG8-768x181.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG8-1536x363.png 1536w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG8.png 1681w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>You can run the job and check that everything is ok.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"96\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG9-1024x96.png\" alt=\"\" class=\"wp-image-3619\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG9-1024x96.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG9-300x28.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG9-768x72.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG9.png 1158w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>6\/ Check with postman<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>check that the databricks REST API endpoint is working<\/li>\n<\/ul>\n\n\n\n<p>You can post the json below on the url : {{workspace_url}}\/api\/2.1\/jobs\/run-now<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>{\n  \"job_id\": {{job_id}},\n  \"job_parameters\": {\n    \"payload\": \"{\\\"order_id\\\":\\\"A131\\\",\\\"customer\\\":{\\\"id\\\":43,\\\"name\\\":\\\"Saad\\\"},\\\"items\\\":&#91;{\\\"sku\\\":\\\"X1\\\",\\\"qty\\\":3},{\\\"sku\\\":\\\"Y7\\\",\\\"qty\\\":9}],\\\"total\\\":303}\"\n  }\n}\n<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"422\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG10-1024x422.png\" alt=\"\" class=\"wp-image-3623\" style=\"width:757px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG10-1024x422.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG10-300x124.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG10-768x316.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG10.png 1282w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>7\/ Create a Magic xpi REST Client resource<\/p>\n\n\n\n<p>Create 2 paths :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\/api\/2.1\/jobs\/run-now<\/li>\n\n\n\n<li>\/api\/2.1\/jobs\/runs\/get?run_id={run_id}&amp;include_history=false<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"246\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG11-1024x246.png\" alt=\"\" class=\"wp-image-3625\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG11-1024x246.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG11-300x72.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG11-768x184.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG11-1536x368.png 1536w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG11.png 1647w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Don&rsquo;t forget to set in the header the Content-Type with application.json and the Authorization with the PAT.<\/p>\n\n\n\n<p>8\/ Use a Flow data component to set the JSON payload.<\/p>\n\n\n\n<p>Don&rsquo;t forget to set the \\ before double quotes in the payload key<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>'{\n  \"job_id\": 778971122069395,\n  \"notebook_params\": {\n    \"payload\": \"{\\\"order_id\\\":\\\"A129\\\",\\\"customer\\\":{\\\"id\\\":42,\\\"name\\\":\\\"Alice\\\"},\\\"items\\\":&#91;{\\\"sku\\\":\\\"X1\\\",\\\"qty\\\":1},{\\\"sku\\\":\\\"Y7\\\",\\\"qty\\\":1}],\\\"total\\\":100}\"\n  }\n}'<\/code><\/pre>\n\n\n\n<p>9\/ Drag and drop a REST Client component to set the path (\/api2.3\/jobs\/run-now)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"591\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG12-1024x591.png\" alt=\"\" class=\"wp-image-3627\" style=\"width:638px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG12-1024x591.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG12-300x173.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG12-768x444.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG12.png 1231w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>10\/ Use a datamapper with a json schema to retrieve the runid<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"119\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG13-1024x119.png\" alt=\"\" class=\"wp-image-3628\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG13-1024x119.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG13-300x35.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG13-768x89.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG13.png 1416w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>11\/ Use the previous runid to retrieve the job status<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"974\" height=\"721\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG14.png\" alt=\"\" class=\"wp-image-3629\" style=\"width:578px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG14.png 974w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG14-300x222.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG14-768x569.png 768w\" sizes=\"auto, (max-width: 974px) 100vw, 974px\" \/><\/figure>\n\n\n\n<p>12\/ Use a Datamapper with a json schema to retrieve the State and Code job<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"525\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG15-1024x525.png\" alt=\"\" class=\"wp-image-3631\" style=\"width:696px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG15-1024x525.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG15-300x154.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG15-768x394.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG15.png 1155w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>13\/ Use the SQL Editor in databroicks<\/p>\n\n\n\n<p>Run the SQL statment below<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT customer_name, SUM(total) AS ca\nFROM workspace.default.orders\nGROUP BY customer_name\nORDER BY ca DESC;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"998\" height=\"620\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG16.png\" alt=\"\" class=\"wp-image-3633\" style=\"width:607px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG16.png 998w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG16-300x186.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG16-768x477.png 768w\" sizes=\"auto, (max-width: 998px) 100vw, 998px\" \/><\/figure>\n\n\n\n<p>14\/ Create a new dashboard<\/p>\n\n\n\n<p>Choose the Datasets (orders) with the previous sql query<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"639\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG17-1024x639.png\" alt=\"\" class=\"wp-image-3634\" style=\"width:593px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG17-1024x639.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG17-300x187.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG17-768x479.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG17.png 1147w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>15\/ Click on the 2nd tab control to build your dashboard<\/p>\n\n\n\n<p>To display a Pie, choose SUM in the <strong>Angle <\/strong>and customer_name in the <strong>Color<\/strong> properties.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"450\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG18-1024x450.png\" alt=\"\" class=\"wp-image-3635\" style=\"width:807px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG18-1024x450.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG18-300x132.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG18-768x338.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG18-1536x676.png 1536w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG18.png 1903w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>16\/ Documentations<\/p>\n\n\n\n<p>(*) https:\/\/docs.databricks.com\/api\/workspace\/jobs\/runnow<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Goal : run a databricks job through REST api with Magic xpi Prequisites : 1\/ Generate your PAT in the user\/developer settings 2\/ Create a table in your catalog 3\/ create a notebook in your workspace Copy\/Paste the below python script 4\/ create a Job set the previous notebook 5\/ Before running the job, you [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3641,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[101,4,97],"tags":[24,14,99],"class_list":["post-3603","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analytique","category-magic-xpi","category-observability","tag-data-management-framework","tag-magic-xpi","tag-observability"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG1.png","_links":{"self":[{"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/posts\/3603","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/comments?post=3603"}],"version-history":[{"count":21,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/posts\/3603\/revisions"}],"predecessor-version":[{"id":3643,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/posts\/3603\/revisions\/3643"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/media\/3641"}],"wp:attachment":[{"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/media?parent=3603"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/categories?post=3603"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/tags?post=3603"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}