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
- Select the database you wish to use to create a table (mydatabase in example), and click “Open”.
- Find the script you want to run (samplesalesdata.sql in example),
and click “OK”.
- The SQL query will appear. Click “Execute”.
- You can see all the new Table Columns in the Instance Explorer view.
Click “Save As”.
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