René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"How to insert arrays into ARRAY\u003cSTRING\u003e columns using native parameters?","articleBody":"Hi!\n\nI am trying to insert an string array into a table with an ARRAY\u003cSTRING\u003e column, but it doesn't seem to register my Python string list.\n\n```sql\nCREATE TABLE prod_catalog.eu_projects.project_export (project_id bigint, categories ARRAY\u003cSTRING\u003e);\n```\n\n```python\ndef insert_test():\n    data = {\n        \"project_id\": 123456,\n        \"categories\": [\n            \"Public Sector\",\n            \"Healthcare\",\n        ],\n    }\n    with get_databricks_connection() as connection:\n        cursor = connection.cursor()\n        cursor.execute(\n            \"INSERT INTO prod_catalog.eu_projects.project_export(project_id, categories) VALUES (:project_id, Array(:categories))\",\n            data\n        )\n        print(\"Test insert completed.\")\n```\n\nThis ends up as an empty array. If I check query history on the SQL Warehouse, it says that categories was an empty array []\n\nI have tried to read [the documentation](https://github.com/databricks/databricks-sql-python/blob/main/docs/parameters.md#named-paramstyle-usage-example), but it is very confusing.\n\nI am using the following versions\nPython 3.13.7\ndatabricks-sql-connector==4.1.3\ndatabricks-sdk==0.66.0","author":{"url":"https://github.com/excavator-matt","@type":"Person","name":"excavator-matt"},"datePublished":"2025-09-25T12:07:23.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/694/databricks-sql-python/issues/694"}