This application is not supported by InterSystems Corporation. Please be notified that you use it at your own responsibility.
What's new in this version
Easy way to import the HoleFoods Sample data into InterSystems IRIS and a sample AtScale model using the AtScale Sample Bundle
Installing the Sample
Prep IRIS before loading the sample
Make sure you have the MySample schema defined in the IRIS namespace you want to import the sample into
If the schema is not defined, run the following SQL in the SMP:
CREATE TABLE MySample.Dummy (P1 INT NOT NULL)
If you want to also set up some global mappings, insert at least 1 row so you can find out the global hash that needs to be mapped
INSERT INTO MySample.Dummy (P1) VALUES (1)
In AtScale, log in and go to the PROJECTS tab
Click on the hamburger menu icon and select "Use a sample"
Select your DWH, the MySample schema, and the zip file
Default permissions can be used
You should expect new tables in IRIS and a new Project in AtScale!
The manifest.json file controls the data files and project files also and describes the delimiters
The /MySample/data folder holds all the tables that will be imported into IRIS. Each folder will hold a file with the data (please note that there are no headers in the <table name>.csv comma delimited file)
The /MySample/project folder will hold the project file that will contain the following:
Source table metadata
In the <data-set> tags
Maps to data files
Can control the names of the tables and columns
Creating a new Project zip
Once you have made your changes you will need to zip up the files. To create the zip file, the top level MySample directory and manifest.json should be zipped together.