Downloadable Files

This page contains downloadable files and scripts. Files should be downloaded from this page to ensure the latest version of the file.

AltaSQL Ready-to-Execute Excel Files

The following files contains “Ready-to-Execute” AltaSQL Defined Functions (ASDF) for each product. Required arguments are indicated by . Default arguments values are set to ‘NULL’ which result in NO operation and may be omitted for convenience. The statements are fully qualified by ASQL_DB.ASDF_SCHEMA; replace ASQL_DB with the name of the AltaSQL shared database. AltaSQL treats the string ‘NULL’ and true NULL as equivalent; this allows use of Snowflake Session Variables to be used as argument values

SELECT Discover Ready To Execute ASDFs

AltaSQL Enterprise Ready To Execute ASDFS

The following SQL scripts are used used to create the Chinook Music database. The files all use bulk INSERTs. Note that the file extensions are “.txt”.

Create Chinook Music

Add Chinook Invoice Data

Add Chinook Track Data

Add Chinook PlayListTrack Data

The following SQL script is used to create a database for managing and governing AltaSQLMeta-data Repositories.

CREATE META DATA REPO DB