Add Rows to Table

If you want to add a small number of rows to a table, you can do so by providing the data inline (being sure that row object structure matches the table schema):

[
  {
    "fullName": "Alex Bard",
    "ageInYears": 30,
    "hiredOn": "2021-07-03"
  }, {
    "fullName": "Alicia Hines",
    "ageInYears": 34,
    "hiredOn": "2023-01-015"
  }
]

However, this is only appropriate for relatively small dataset (a few hundred rows or less, depending on schema complexity). If you need to work with a larger dataset you should utilize stashing.

Stashing is our process for handling the upload of large datasets. Break down your dataset into smaller, more manageable, pieces and upload them to a single stash ID.

Then, to add all the row data in a stash to the table in a single atomic operation, use the $stashID reference in the rows field instead of providing the data inline:

{
    "$stashID": "20240215-job32"
}