Shard feed files (legacy)

Depending on your inventory, sharding (or breaking up feeds into multiple files) may be necessary.

Note: Sharding might only be applicable to some of the feeds you submit and is dependent on the type of inventory submitted. Please reach out to your Google contact if you are unsure of the best approach.

When to use sharding

• Feed exceeds 200 MB for 1 file (after gzip compression).

  • Example: Generated availability feed is 1 GB. This should be sharded to 5+ separate files (or shards).

• Partner inventory is distributed across systems and/or regions resulting in difficulty reconciling the inventory.

  • Example: Partner has US and EU inventory that live in separate systems. The feed may be generated with 2 files (or shards), 1 for US, and 1 for EU with the same nonce and generation_timestamp.

Note: Before using sharding, make sure you are compressing your feed uploads with gzip. Using gzip can reduce feed size by 10x or more, and may allow you to skip or defer sharding your feed.

General rules

• Each shard cannot exceed 200 MB for 1 file (after gzip compression).
• We recommend no more than 20 shards per feed. If you have a business justification that requires more than that amount, please contact support for further instruction.
• Individual records (one Merchant object for example) must be sent in one shard, they cannot be split across multiple shards. However, they don't have to be sent in the shard with the same shard_number for future feeds.
• For better performance, your data should be split evenly among the shards so that all sharded files are similar in size.

Note: Google processes feed files as soon as they're uploaded to the SFTP dropbox. If the feed is sharded into multiple files, the process begins after you upload the last file. If your feed contains errors, you receive an email with the feed error codes.

How to shard feeds

For each file (or shard), set the FeedMetadata to the following:

• processing_instructionset to PROCESS_AS_COMPLETE.
• shard_number set to to the current shard of the feed (starting from 0 to total_shards - 1 without discontinuities)
• total_shards set to the total number of shards for the feed (starting from 1).
• nonce set to a unique identifier that is the same across all shards of the same feed but different from the value of other feeds.
• generation_timestamp is the timestamp in unix and EPOCH format. This should be the same across all shards of the feed.

Recommended: For each file (or shard), set the filename to indicate the feed type, the timestamp, the shard number, and the total number of shards. Shards should be roughly equal in size and are processed once all shards are uploaded.

• Example: “availability_feed_1574117613_001_of_002.json.gz”

Sharded Availability feed example

Shard 0

{
  "metadata": {
    "processing_instruction": "PROCESS_AS_COMPLETE",
    "shard_number": 0,
    "total_shards": 3,
    "nonce": "111111",
    "generation_timestamp": 1524606581
  },
  "service_availability": [
    {
      "availability": [
        {
          "spots_total": 1,
          "spots_open": 1,
          "duration_sec": 3600,
          "service_id": "1000",
          "start_sec": 1577275200,
          "merchant_id": "merchant1",
          "confirmation_mode": "CONFIRMATION_MODE_SYNCHRONOUS"
        }
      ]
    }
  ]
}

Shard 1

{
  "metadata": {
    "processing_instruction": "PROCESS_AS_COMPLETE",
    "shard_number": 1,
    "total_shards": 3,
    "nonce": "111111",
    "generation_timestamp": 1524606581
  },
  "service_availability": [
    {
      "availability": [
        {
          "spots_total": 1,
          "spots_open": 1,
          "duration_sec": 3600,
          "service_id": "1000",
          "start_sec": 1577620800,
          "merchant_id": "merchant2",
          "confirmation_mode": "CONFIRMATION_MODE_SYNCHRONOUS"
        }
      ]
    }
  ]
}

Shard 2

{
  "metadata": {
    "processing_instruction": "PROCESS_AS_COMPLETE",
    "shard_number": 2,
    "total_shards": 3,
    "nonce": "111111",
    "generation_timestamp": 1524606581
  },
  "service_availability": [
    {
      "availability": [
        {
          "spots_total": 1,
          "spots_open": 1,
          "duration_sec": 3600,
          "service_id": "1000",
          "start_sec": 1576670400,
          "merchant_id": "merchant3",
          "confirmation_mode": "CONFIRMATION_MODE_SYNCHRONOUS"
        }
      ]
    }
  ]
}

Using sharding for partner distributed inventory

It can be challenging for partners to consolidate inventory distributed across multiple systems and or regions into a single feed. Sharding can be used to resolve reconciliation challenges by setting each shard to match each distributed system’s inventory set.

For example, say a partner’s inventory is separated into 2 regions (US and EU inventory), which live in 2 separate systems.

The partner can break each feed into 2 files (or shards):

• Merchants feed: 1 shard for US, 1 shard for EU
• Services feed: 1 shard for US, 1 shard for EU
• Availability feed: 1 shard for US, 1 shard for EU

Follow the steps below to ensure the feeds are properly processed:

1. Decide on an upload schedule, and configure each instance of inventory to follow the schedule.
2. Assign unique shard numbers for each instance (e.g. US = N, EU = N + 1). Set total_shards to the total number of shards.
3. At each scheduled upload time, decide on a generation_timestamp and nonce. In the FeedMetadata, set all instances to hold the same values for these two fields.
   • generation_timestamp should be current or recent past (ideally, the partner’s read-at database timestamp)
4. After all shards are uploaded, Google groups the shards via generation_timestamp and nonce.

Note: Feeds/shards arriving separately at different times is supported, but coordinated schedules is best. Feed processing occurs only when all shards in a feed set are uploaded.

Google will process the feed as one even though each shard represents a different region of the partner’s inventory and could be uploaded at a different time of the day as long as the generation_timestamp is the same across all shards.

Sharded Availability feed example by region

Shard 0 - US Inventory

{
  "metadata": {
    "processing_instruction": "PROCESS_AS_COMPLETE",
    "shard_number": 0,
    "total_shards": 2,
    "nonce": "111111",
    "generation_timestamp": 1524606581
  },
  "service_availability": [
    {
      "availability": [
        {
          "spots_total": 1,
          "spots_open": 1,
          "duration_sec": 3600,
          "service_id": "1000",
          "start_sec": 1577275200,
          "merchant_id": "US_merchant_1",
          "confirmation_mode": "CONFIRMATION_MODE_SYNCHRONOUS"
        }
      ]
    }
  ]
}

Shard 1 - EU Inventory

{
  "metadata": {
    "processing_instruction": "PROCESS_AS_COMPLETE",
    "shard_number": 1,
    "total_shards": 2,
    "nonce": "111111",
    "generation_timestamp": 1524606581
  },
  "service_availability": [
    {
      "availability": [
        {
          "spots_total": 1,
          "spots_open": 1,
          "duration_sec": 3600,
          "service_id": "1000",
          "start_sec": 1577620800,
          "merchant_id": "EU_merchant_1",
          "confirmation_mode": "CONFIRMATION_MODE_SYNCHRONOUS"
        }
      ]
    }
  ]
}