Load Data Into Snowflake

About This Script

Features:

• Makes HTTP requests to external APIs
• Integrates with Snowflake

{
    "nodes": [
        {
            "id": "da710a80-484b-4fe3-80fa-e699bb6499ad",
            "name": "When clicking \"Execute Workflow\"",
            "type": "n8n-nodes-base.manualTrigger",
            "position": [
                440,
                380
            ],
            "parameters": [],
            "typeVersion": 1
        },
        {
            "id": "f419ebfb-9eae-4fea-b05b-aabc97b5f47f",
            "name": "HTTP Request",
            "type": "n8n-nodes-base.httpRequest",
            "position": [
                640,
                380
            ],
            "parameters": {
                "url": "https://n8niostorageaccount.blob.core.windows.net/n8nio-strapi-blobs-prod/assets/example_c0b48ce677.csv?updated_at=2023-05-30T10:36:21.820Z",
                "options": {
                    "response": {
                        "response": {
                            "responseFormat": "file"
                        }
                    }
                }
            },
            "typeVersion": 4.1
        },
        {
            "id": "fe45e2a2-b50f-4459-a8ee-78615239dee0",
            "name": "Spreadsheet File",
            "type": "n8n-nodes-base.spreadsheetFile",
            "position": [
                820,
                380
            ],
            "parameters": {
                "options": []
            },
            "typeVersion": 1
        },
        {
            "id": "54e31892-c8e1-423c-a24a-8e5eb1312b0a",
            "name": "Set",
            "type": "n8n-nodes-base.set",
            "position": [
                1000,
                380
            ],
            "parameters": {
                "values": {
                    "number": [
                        {
                            "name": "first_name",
                            "value": "={{ $json.first_name }}"
                        },
                        {
                            "name": "id",
                            "value": "={{ $json.id }}"
                        }
                    ],
                    "string": [
                        {
                            "name": "last_name",
                            "value": "={{ $json.last_name }}"
                        }
                    ]
                },
                "options": {
                    "dotNotation": false
                },
                "keepOnlySet": true
            },
            "typeVersion": 2
        },
        {
            "id": "c482d8e8-0792-4b61-a2e0-d437c9fe9062",
            "name": "Snowflake",
            "type": "n8n-nodes-base.snowflake",
            "position": [
                1200,
                380
            ],
            "parameters": {
                "table": "users",
                "columns": "id,first_name,last_name"
            },
            "credentials": {
                "snowflake": {
                    "id": "23",
                    "name": "Snowflake account"
                }
            },
            "typeVersion": 1
        }
    ],
    "connections": {
        "Set": {
            "main": [
                [
                    {
                        "node": "Snowflake",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "HTTP Request": {
            "main": [
                [
                    {
                        "node": "Spreadsheet File",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "Spreadsheet File": {
            "main": [
                [
                    {
                        "node": "Set",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "When clicking \"Execute Workflow\"": {
            "main": [
                [
                    {
                        "node": "HTTP Request",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        }
    },
    "n8n_version": "1.5.0"
}

Requirements