Once you have explored the data, you can save the results as a table within Magpie. While it is possible to specify more detailed configuration for the table including descriptive information about fields and mappings to data sources other than the default source for the repository, we will focus on a simplified version save process. By default, tables are saved in an S3 bucket in the Parquet format allowing for high performance query within Magpie.
Using the temporary result table that is created by Magpie SQL statements, we can easily save the results of an analysis. The screenshot below shows the syntax for saving results.
After you have saved a result within a schema, it will be available to other users of the schema and it will be available to you in subsequent sessions. You can find more detail on the SAVE RESULT command in the command reference - Save Result.