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.

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).

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

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

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

1. Load all your Highways data files.

1. Create the Spatial Indexes and other indexes.