Using Snowflake to load the data into a database

Snowflake Software provides standard project templates for several OS products. Users can use these templates to load data to a standard data model to meet the requirements of most end-users.

Snowflake has created a standard project to support the new OS MasterMap Highways Network dataset. This can be downloaded from the Snowflake support portal.

The project also includes columns to help support styling / MapInfo styling if needed.

1. Open GO Loader, File/Download Templates, and download the new standard GO Loader project for Highways, from the Customer portal (Products/GO Loader/Resources/Project Templates).

2. Save the file to your drive and unzip it.

Go Loader UI showing File dropdown menu.

1. In GO Loader, open the new extracted OS_Highways.glp GO Loader Standard project (or drag it into the Project File area of the screen).

GO Loader UI showing standard project details.

1. Select the Loader Configuration tab to set your target database details.

GO Loader UI with Loader Configuration tab shown.

1. Set a directory location on your hard drive for ‘load lists’ (choose any valid local location).

GO Loader UI with load list directory selected in the Loader Configuration tab.

1. Create all the tables defined in the GO Loader Highways project (ideally choose a new database or schema without other existing tables).

Go Loader UI with Create Tables tab shown.

1. Load all your Highways data files.

GO Loader UI showing the Load Files tab.

1. Create the Spatial Indexes and other indexes.

GO Loader UI with Create Indices tab shown.