{"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 class=\"wp-block-paragraph\"><strong>Goal : run a databricks job through REST api with Magic xpi<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">5\/ Before running the job, you can populate your payload with a valid json<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">7\/ Create a Magic xpi REST Client resource<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">8\/ Use a Flow data component to set the JSON payload.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">13\/ Use the SQL Editor in databroicks<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">14\/ Create a new dashboard<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">15\/ Click on the 2nd tab control to build your dashboard<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">16\/ Documentations<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">(*) https:\/\/docs.databricks.com\/api\/workspace\/jobs\/runnow<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/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":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"Goal : run a databricks job through REST api with Magic xpi Prequisites : access to databricks endpoint PAT (Personal Access Token for free edition) or Oauth2 ( for enterprise edition). table defined in catalog notebook 1\/ Generate your PAT in the user\/developer settings 2\/ Create a table in your catalog 3\/ create a notebook\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Sa\u00e2d Alem\"\/>\n\t<meta name=\"google-site-verification\" content=\"5yLZLt_RgZVqkETQDrOlMUHaNTra2i5W8dtHQoCMueY\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/databricks-magicxpi\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.0.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"fr_FR\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Le Blog Techno | Magic Software France\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"databricks \u2013 Magicxpi | Le Blog Techno\" \/>\n\t\t<meta property=\"og:description\" content=\"Goal : run a databricks job through REST api with Magic xpi Prequisites : access to databricks endpoint PAT (Personal Access Token for free edition) or Oauth2 ( for enterprise edition). table defined in catalog notebook 1\/ Generate your PAT in the user\/developer settings 2\/ Create a table in your catalog 3\/ create a notebook\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/databricks-magicxpi\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2023\/11\/Magic.ico\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2023\/11\/Magic.ico\" \/>\n\t\t<meta property=\"og:image:width\" content=\"16\" \/>\n\t\t<meta property=\"og:image:height\" content=\"16\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2026-04-20T12:35:01+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-04-20T16:07:07+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/MagicSoftwareEnterprises\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@MagicSoftware\" \/>\n\t\t<meta name=\"twitter:title\" content=\"databricks \u2013 Magicxpi | Le Blog Techno\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Goal : run a databricks job through REST api with Magic xpi Prequisites : access to databricks endpoint PAT (Personal Access Token for free edition) or Oauth2 ( for enterprise edition). table defined in catalog notebook 1\/ Generate your PAT in the user\/developer settings 2\/ Create a table in your catalog 3\/ create a notebook\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@MagicSoftware\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2023\/11\/Magic.ico\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/databricks-magicxpi\\\/#blogposting\",\"name\":\"databricks \\u2013 Magicxpi | Le Blog Techno\",\"headline\":\"databricks &#8211; Magicxpi\",\"author\":{\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/author\\\/saad\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/DCKS_MG1.png\",\"width\":516,\"height\":101},\"datePublished\":\"2026-04-20T13:35:01+01:00\",\"dateModified\":\"2026-04-20T17:07:07+01:00\",\"inLanguage\":\"fr-FR\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/databricks-magicxpi\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/databricks-magicxpi\\\/#webpage\"},\"articleSection\":\"Analytique, Magic xpi, Observability, Data Management Framework, Magic xpi, Observability\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/databricks-magicxpi\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog#listItem\",\"position\":1,\"name\":\"Domicile\",\"item\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/category\\\/magic-xpi\\\/#listItem\",\"name\":\"Magic xpi\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/category\\\/magic-xpi\\\/#listItem\",\"position\":2,\"name\":\"Magic xpi\",\"item\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/category\\\/magic-xpi\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/category\\\/magic-xpi\\\/observability\\\/#listItem\",\"name\":\"Observability\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog#listItem\",\"name\":\"Domicile\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/category\\\/magic-xpi\\\/observability\\\/#listItem\",\"position\":3,\"name\":\"Observability\",\"item\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/category\\\/magic-xpi\\\/observability\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/databricks-magicxpi\\\/#listItem\",\"name\":\"databricks &#8211; Magicxpi\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/category\\\/magic-xpi\\\/#listItem\",\"name\":\"Magic xpi\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/databricks-magicxpi\\\/#listItem\",\"position\":4,\"name\":\"databricks &#8211; Magicxpi\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/category\\\/magic-xpi\\\/observability\\\/#listItem\",\"name\":\"Observability\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/#organization\",\"name\":\"Blog Magic France\",\"description\":\"Magic Software France\",\"url\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/\",\"telephone\":\"+33149105858\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/Magic.ico\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/databricks-magicxpi\\\/#organizationLogo\",\"width\":16,\"height\":16},\"image\":{\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/databricks-magicxpi\\\/#organizationLogo\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/MagicSoftwareEnterprises\",\"https:\\\/\\\/twitter.com\\\/MagicSoftware\",\"https:\\\/\\\/youtube.com\\\/MagicSoftware\",\"https:\\\/\\\/linkedin.com\\\/company\\\/magic-software-enterprises\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/author\\\/saad\\\/#author\",\"url\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/author\\\/saad\\\/\",\"name\":\"Sa\\u00e2d Alem\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/databricks-magicxpi\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/38fae53569553d87ce6ffb3b936e4df6feecf6069ddb238526105d8d906273c4?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Sa\\u00e2d Alem\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/databricks-magicxpi\\\/#webpage\",\"url\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/databricks-magicxpi\\\/\",\"name\":\"databricks \\u2013 Magicxpi | Le Blog Techno\",\"description\":\"Goal : run a databricks job through REST api with Magic xpi Prequisites : access to databricks endpoint PAT (Personal Access Token for free edition) or Oauth2 ( for enterprise edition). table defined in catalog notebook 1\\\/ Generate your PAT in the user\\\/developer settings 2\\\/ Create a table in your catalog 3\\\/ create a notebook\",\"inLanguage\":\"fr-FR\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/databricks-magicxpi\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/author\\\/saad\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/author\\\/saad\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/DCKS_MG1.png\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/databricks-magicxpi\\\/#mainImage\",\"width\":516,\"height\":101},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/databricks-magicxpi\\\/#mainImage\"},\"datePublished\":\"2026-04-20T13:35:01+01:00\",\"dateModified\":\"2026-04-20T17:07:07+01:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/\",\"name\":\"Blog Magic France\",\"description\":\"Magic Software France\",\"inLanguage\":\"fr-FR\",\"publisher\":{\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"databricks \u2013 Magicxpi | Le Blog Techno","description":"Goal : run a databricks job through REST api with Magic xpi Prequisites : access to databricks endpoint PAT (Personal Access Token for free edition) or Oauth2 ( for enterprise edition). table defined in catalog notebook 1\/ Generate your PAT in the user\/developer settings 2\/ Create a table in your catalog 3\/ create a notebook","canonical_url":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/databricks-magicxpi\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"google-site-verification":"5yLZLt_RgZVqkETQDrOlMUHaNTra2i5W8dtHQoCMueY","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/databricks-magicxpi\/#blogposting","name":"databricks \u2013 Magicxpi | Le Blog Techno","headline":"databricks &#8211; Magicxpi","author":{"@id":"https:\/\/france.magicsoftware.com\/blog\/author\/saad\/#author"},"publisher":{"@id":"https:\/\/france.magicsoftware.com\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG1.png","width":516,"height":101},"datePublished":"2026-04-20T13:35:01+01:00","dateModified":"2026-04-20T17:07:07+01:00","inLanguage":"fr-FR","mainEntityOfPage":{"@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/databricks-magicxpi\/#webpage"},"isPartOf":{"@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/databricks-magicxpi\/#webpage"},"articleSection":"Analytique, Magic xpi, Observability, Data Management Framework, Magic xpi, Observability"},{"@type":"BreadcrumbList","@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/databricks-magicxpi\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/france.magicsoftware.com\/blog#listItem","position":1,"name":"Domicile","item":"https:\/\/france.magicsoftware.com\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/#listItem","name":"Magic xpi"}},{"@type":"ListItem","@id":"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/#listItem","position":2,"name":"Magic xpi","item":"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/","nextItem":{"@type":"ListItem","@id":"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/observability\/#listItem","name":"Observability"},"previousItem":{"@type":"ListItem","@id":"https:\/\/france.magicsoftware.com\/blog#listItem","name":"Domicile"}},{"@type":"ListItem","@id":"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/observability\/#listItem","position":3,"name":"Observability","item":"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/observability\/","nextItem":{"@type":"ListItem","@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/databricks-magicxpi\/#listItem","name":"databricks &#8211; Magicxpi"},"previousItem":{"@type":"ListItem","@id":"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/#listItem","name":"Magic xpi"}},{"@type":"ListItem","@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/databricks-magicxpi\/#listItem","position":4,"name":"databricks &#8211; Magicxpi","previousItem":{"@type":"ListItem","@id":"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/observability\/#listItem","name":"Observability"}}]},{"@type":"Organization","@id":"https:\/\/france.magicsoftware.com\/blog\/#organization","name":"Blog Magic France","description":"Magic Software France","url":"https:\/\/france.magicsoftware.com\/blog\/","telephone":"+33149105858","logo":{"@type":"ImageObject","url":"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2023\/11\/Magic.ico","@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/databricks-magicxpi\/#organizationLogo","width":16,"height":16},"image":{"@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/databricks-magicxpi\/#organizationLogo"},"sameAs":["https:\/\/www.facebook.com\/MagicSoftwareEnterprises","https:\/\/twitter.com\/MagicSoftware","https:\/\/youtube.com\/MagicSoftware","https:\/\/linkedin.com\/company\/magic-software-enterprises"]},{"@type":"Person","@id":"https:\/\/france.magicsoftware.com\/blog\/author\/saad\/#author","url":"https:\/\/france.magicsoftware.com\/blog\/author\/saad\/","name":"Sa\u00e2d Alem","image":{"@type":"ImageObject","@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/databricks-magicxpi\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/38fae53569553d87ce6ffb3b936e4df6feecf6069ddb238526105d8d906273c4?s=96&d=mm&r=g","width":96,"height":96,"caption":"Sa\u00e2d Alem"}},{"@type":"WebPage","@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/databricks-magicxpi\/#webpage","url":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/databricks-magicxpi\/","name":"databricks \u2013 Magicxpi | Le Blog Techno","description":"Goal : run a databricks job through REST api with Magic xpi Prequisites : access to databricks endpoint PAT (Personal Access Token for free edition) or Oauth2 ( for enterprise edition). table defined in catalog notebook 1\/ Generate your PAT in the user\/developer settings 2\/ Create a table in your catalog 3\/ create a notebook","inLanguage":"fr-FR","isPartOf":{"@id":"https:\/\/france.magicsoftware.com\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/databricks-magicxpi\/#breadcrumblist"},"author":{"@id":"https:\/\/france.magicsoftware.com\/blog\/author\/saad\/#author"},"creator":{"@id":"https:\/\/france.magicsoftware.com\/blog\/author\/saad\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2026\/04\/DCKS_MG1.png","@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/databricks-magicxpi\/#mainImage","width":516,"height":101},"primaryImageOfPage":{"@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/databricks-magicxpi\/#mainImage"},"datePublished":"2026-04-20T13:35:01+01:00","dateModified":"2026-04-20T17:07:07+01:00"},{"@type":"WebSite","@id":"https:\/\/france.magicsoftware.com\/blog\/#website","url":"https:\/\/france.magicsoftware.com\/blog\/","name":"Blog Magic France","description":"Magic Software France","inLanguage":"fr-FR","publisher":{"@id":"https:\/\/france.magicsoftware.com\/blog\/#organization"}}]},"og:locale":"fr_FR","og:site_name":"Le Blog Techno | Magic Software France","og:type":"article","og:title":"databricks \u2013 Magicxpi | Le Blog Techno","og:description":"Goal : run a databricks job through REST api with Magic xpi Prequisites : access to databricks endpoint PAT (Personal Access Token for free edition) or Oauth2 ( for enterprise edition). table defined in catalog notebook 1\/ Generate your PAT in the user\/developer settings 2\/ Create a table in your catalog 3\/ create a notebook","og:url":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/databricks-magicxpi\/","og:image":"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2023\/11\/Magic.ico","og:image:secure_url":"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2023\/11\/Magic.ico","og:image:width":16,"og:image:height":16,"article:published_time":"2026-04-20T12:35:01+00:00","article:modified_time":"2026-04-20T16:07:07+00:00","article:publisher":"https:\/\/www.facebook.com\/MagicSoftwareEnterprises","twitter:card":"summary_large_image","twitter:site":"@MagicSoftware","twitter:title":"databricks \u2013 Magicxpi | Le Blog Techno","twitter:description":"Goal : run a databricks job through REST api with Magic xpi Prequisites : access to databricks endpoint PAT (Personal Access Token for free edition) or Oauth2 ( for enterprise edition). table defined in catalog notebook 1\/ Generate your PAT in the user\/developer settings 2\/ Create a table in your catalog 3\/ create a notebook","twitter:creator":"@MagicSoftware","twitter:image":"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2023\/11\/Magic.ico"},"aioseo_meta_data":{"post_id":"3603","title":null,"description":null,"keywords":null,"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"schemas":[],"titles":[],"descriptions":[],"socialPosts":{"email":[],"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"created":"2026-04-20 09:57:53","updated":"2026-04-20 17:40:19","seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/france.magicsoftware.com\/blog\" title=\"Domicile\">Domicile<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/\" title=\"Magic xpi\">Magic xpi<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/observability\/\" title=\"Observability\">Observability<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tdatabricks \u2013 Magicxpi\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Domicile","link":"https:\/\/france.magicsoftware.com\/blog"},{"label":"Magic xpi","link":"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/"},{"label":"Observability","link":"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/observability\/"},{"label":"databricks &#8211; Magicxpi","link":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/databricks-magicxpi\/"}],"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}]}}