Create A Table In Cratedb And Insert Data

About This Script

Features:

• Automates workflow tasks
• Ready to import into n8n
• Configurable parameters

{
    "nodes": [
        {
            "name": "On clicking 'execute'",
            "type": "n8n-nodes-base.manualTrigger",
            "position": [
                550,
                400
            ],
            "parameters": [],
            "typeVersion": 1,
            "id": "98296b5f-87ba-4b6a-ad4b-40a04194f21b"
        },
        {
            "name": "CrateDB",
            "type": "n8n-nodes-base.crateDb",
            "position": [
                750,
                400
            ],
            "parameters": {
                "query": "CREATE TABLE test (id INT, name STRING);",
                "operation": "executeQuery"
            },
            "credentials": {
                "crateDb": "cratedb_creds"
            },
            "typeVersion": 1,
            "alwaysOutputData": true,
            "id": "4466a581-985b-44ea-a86d-8b0c73de5bbb"
        },
        {
            "name": "CrateDB1",
            "type": "n8n-nodes-base.crateDb",
            "position": [
                1150,
                400
            ],
            "parameters": {
                "table": "test",
                "columns": "id, name"
            },
            "credentials": {
                "crateDb": "cratedb_creds"
            },
            "typeVersion": 1,
            "id": "27c08477-b0ab-4102-97bd-0fa34e1ed3e5"
        },
        {
            "name": "Set",
            "type": "n8n-nodes-base.set",
            "position": [
                950,
                400
            ],
            "parameters": {
                "values": {
                    "number": [
                        {
                            "name": "id",
                            "value": 0
                        }
                    ],
                    "string": [
                        {
                            "name": "name",
                            "value": "n8n"
                        }
                    ]
                },
                "options": []
            },
            "typeVersion": 1,
            "alwaysOutputData": false,
            "id": "6c7ef8ec-40d4-4feb-85e4-357cae386ba1"
        }
    ],
    "connections": {
        "Set": {
            "main": [
                [
                    {
                        "node": "CrateDB1",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "CrateDB": {
            "main": [
                [
                    {
                        "node": "Set",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "On clicking 'execute'": {
            "main": [
                [
                    {
                        "node": "CrateDB",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        }
    },
    "n8n_version": "1.5.0"
}

Requirements