Create a sharding users list (Optional)

Create a sharding users list if you're migrating a large number of files to Google Drive from Microsoft® SharePoint®, file shares, or Box®. If you're not migrating 50,000 files or more to a single user’s Drive account or to a shared drive, you can skip this step and go to Create a scoped view for SharePointfile shares or Box.  

What is a sharding users list?

A sharding users list is a CSV file with email addresses from your target account. The user accounts belonging to the email addresses are used to write objects to a user's My Drive or a shared drive.

Using a sharding user list spreads migration load to a larger group of users. Doing so improves migration performance and speed when you're migrating a large number of files to Drive. It also helps avoid API bottlenecks.

You'll use the list when you configure your bridge. 

Step 1: Create temporary users (Recommended)

You can see the user accounts in your sharding users list in the Drive audit log for the migrated files. For example, you can see which user account created a file. To avoid any confusion with active users, we recommend that you set up temporary G Suite users using an easily-identifiable username, such as shard-user1. Use the new accounts for your sharding users list. Then, delete the users after you complete the migration.

To determine the number of user accounts to add to the sharding users list, compare the following 2 options and use the larger value:

  • One account per 50,000 files that are being migrated to Drive.
  • 10 accounts per node. 

For details on adding and deleting users, see Options for adding users and Delete a user from your organization.

Step 2: Create the CSV file

  • Create the list in a spreadsheet program with one entry per line.
  • Headers are not required.
  • Save the spreadsheet as a CSV file.
  • Make sure the character encoding of the CSV file is set to UTF-8. 

Sharding user list CSV file

Step 3: Add the list

  1. In the G Suite Migrate platform, click New Newand thenList.
  2. Enter a name for the list.
  3. Under Type, click the Down arrow Down Arrowand thenUsers.
  4. Click Upload CSV file to upload a CSV file or drag a file to the box.
  5. Click Create.

You'll be able to select the list when creating a bridge.

Related topics

How many node servers do I need?

Next step

Create a scoped view for SharePointfile shares or Box