Create A Table And Insert And Update Data In The Table In Snowflake

About This Script

Features:

• Integrates with Snowflake

{
    "nodes": [
        {
            "name": "On clicking 'execute'",
            "type": "n8n-nodes-base.manualTrigger",
            "position": [
                250,
                300
            ],
            "parameters": [],
            "typeVersion": 1,
            "id": "0cd984bc-2fb3-47ef-b41b-017e58ff0482"
        },
        {
            "name": "Set",
            "type": "n8n-nodes-base.set",
            "position": [
                650,
                300
            ],
            "parameters": {
                "values": {
                    "number": [
                        {
                            "name": "id",
                            "value": 1
                        }
                    ],
                    "string": [
                        {
                            "name": "name",
                            "value": "n8n"
                        }
                    ]
                },
                "options": [],
                "keepOnlySet": true
            },
            "typeVersion": 1,
            "id": "47f2a79f-4248-4714-a676-3d72ee321ea0"
        },
        {
            "name": "Snowflake",
            "type": "n8n-nodes-base.snowflake",
            "position": [
                450,
                300
            ],
            "parameters": {
                "query": "CREATE TABLE docs (id INT, name STRING);",
                "operation": "executeQuery"
            },
            "credentials": {
                "snowflake": "Snowflake n8n Credentials"
            },
            "typeVersion": 1,
            "id": "13b4dcfb-7836-4465-85b9-5c2627de51fb"
        },
        {
            "name": "Snowflake1",
            "type": "n8n-nodes-base.snowflake",
            "position": [
                850,
                300
            ],
            "parameters": {
                "table": "docs",
                "columns": "id, name"
            },
            "credentials": {
                "snowflake": "Snowflake n8n Credentials"
            },
            "typeVersion": 1,
            "id": "c0308f41-9734-4f28-8459-cdf89738c7c0"
        },
        {
            "name": "Set1",
            "type": "n8n-nodes-base.set",
            "position": [
                1050,
                300
            ],
            "parameters": {
                "values": {
                    "number": [
                        {
                            "name": "id",
                            "value": 1
                        }
                    ],
                    "string": [
                        {
                            "name": "name",
                            "value": "nodemation"
                        }
                    ]
                },
                "options": [],
                "keepOnlySet": true
            },
            "typeVersion": 1,
            "id": "28e012c8-285f-4b7c-930f-0b47b15302f1"
        },
        {
            "name": "Snowflake2",
            "type": "n8n-nodes-base.snowflake",
            "position": [
                1250,
                300
            ],
            "parameters": {
                "table": "={{$node[\"Snowflake1\"].parameter[\"table\"]}}",
                "columns": "name",
                "operation": "update"
            },
            "credentials": {
                "snowflake": "Snowflake n8n Credentials"
            },
            "typeVersion": 1,
            "id": "c5522b99-6150-4e86-9763-3e1335b8a438"
        }
    ],
    "connections": {
        "Set": {
            "main": [
                [
                    {
                        "node": "Snowflake1",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "Set1": {
            "main": [
                [
                    {
                        "node": "Snowflake2",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "Snowflake": {
            "main": [
                [
                    {
                        "node": "Set",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "Snowflake1": {
            "main": [
                [
                    {
                        "node": "Set1",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "On clicking 'execute'": {
            "main": [
                [
                    {
                        "node": "Snowflake",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        }
    },
    "n8n_version": "1.5.0"
}

Requirements