Create New Table with a Script

At this stage you will need data.

We hope you have your own data available to load into Vectorwise, however if you require some sample data you can download and use Sample Sales Data.

Download Sample Sales Data

The instructions below will show you how to create the table and load the data using the Sample Sales Data (86,849 rows which is about 9MB data). We have purposely kept the data size small so you can download it quickly, but note it is not a lot of data for Vectorwise, even on a small laptop, and we recommend you test Vectorwise with a lot more data if you want to do any serious performance testing.

Create a table using a script

  1. Select the database you wish to use to create a table (mydatabase in example), and click “Open”.
    Create a table using a script

  2. Find the script you want to run (samplesalesdata.sql in example),
    and click “OK”.
    Create a table using a script

  3. The SQL query will appear. Click “Execute”.
    Create a table using a script

  4. You can see all the new Table Columns in the Instance Explorer view.
    Click “Save As”.
    Create a table using a script

You might need to refresh the Instance Explorer view if this does not appear immediately. To do this right-click your database and click Refresh.

Congratulations, you have now created a Table and are ready to load data into Vectorwise.

Next Steps — Load data into Vectorwise