如何使用python将json从API插入到雪花数据库？

Question

我正在使用python从Linkedin广告API获取数据。
我以json字符串的形式获取数据。
如何将这个json插入到带有variant列的Snowfalke表中？
“elements”中的字段也可以作为常规插入，而不是variant。
我对json和python都不熟悉，所以希望能得到一些帮助。
下面是我得到的示例json字符串。在

{
    "elements": [
        {
            "dateRange": {
                "start": {
                    "month": 3,
                    "year": 2019,
                    "day": 3
                },
                "end": {
                    "month": 3,
                    "year": 2019,
                    "day": 3
                }
            },
            "clicks": 11,
            "impressions": 2453,
            "pivotValues": [
                "urn:li:sponsoredCampaign:1234567"
            ]
        },
        {
            "dateRange": {
                "start": {
                    "month": 3,
                    "year": 2019,
                    "day": 4
                },
                "end": {
                    "month": 3,
                    "year": 2019,
                    "day": 4
                }
            },
            "clicks": 4,
            "impressions": 816,
            "pivotValues": [
                "urn:li:sponsoredCampaign:1234567"
            ]
        },
        {
            "dateRange": {
                "start": {
                    "month": 3,
                    "year": 2019,
                    "day": 7
                },
                "end": {
                    "month": 3,
                    "year": 2019,
                    "day": 7
                }
            },
            "clicks": 1,
            "impressions": 629,
            "pivotValues": [
                "urn:li:sponsoredCampaign:1234565"
            ]
        },
        {
            "dateRange": {
                "start": {
                    "month": 3,
                    "year": 2019,
                    "day": 21
                },
                "end": {
                    "month": 3,
                    "year": 2019,
                    "day": 21
                }
            },
            "clicks": 3,
            "impressions": 154,
            "pivotValues": [
                "urn:li:sponsoredCampaign:1323516"
            ]
        }
    ],
    "paging": {
        "count": 10,
        "start": 0,
        "links": []
    }
}

Answer 1

下面是python中如何插入JSON数据的示例：

https://github.com/snowflakedb/snowflake-connector-python/blob/master/test/test_cursor.py#L456

我想您的insert中缺少了parse_json函数。在