title: How to insert json from API to snowflake database using python?
body: <p>I am getting data from Linkedin AD API using python.<br>
  I get the data as a json string.<br>
  How can I insert this json into Snowfalke table with a variant column?<br>
  Instead of variant, fields inside "elements" can also be inserted as a normal.<br>
  I am new to both json and python so would love to get some help on this.<br>
  Here is the sample json string I am getting.</p>
  
  <pre><code>{
      "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": []
      }
  }
  </code></pre>