Alliances

To access the full sample data set on Amazon Web Services manually or programmatically, the S3 bucket URLs are provided here.

To get user name and password for manual access or access key and secret key for programmatic access, contact sales@ch-aviation.com.

To access the full sample data set on Snowflake, visit the ch-aviation profile on Snowflake Marketplace here.

Sample File NameSample Description
alliances.csvSample data
ColumnData TypeData descriptionPackage requiredKeyData SetJoin On
IDint(11)Unique ch-aviation created alliance IDOperatorsPrimary
Alliance_Codechar(2)ch-aviation alliance code (assigned by ch-aviation)OperatorsUnique
Descriptionvarchar(255)Alliance nameOperators
URLvarchar(255)Alliance URLOperators