def dimension_info():

	dimension_dicts = {
	    'artist': {'columns': {0: 'artistId', 1: 'artistName', 2: 'labelId'},
	        'table': 'dim_artist'},
	    'label': {'columns': {0: 'labelId', 1: 'labelName', 3: 'countryId', 8: 'ownerId', 7: 'isDistributor'},
	        'table': 'dim_label'},
	    'catalog': {'columns': {0: 'catalogId', 2: 'catalogName', 1: 'catalogNumber', 3: 'labelId', 7: 'subaccountId'},
	        'table': 'dim_catalog'},
	    'country': {'columns': {0: 'countryId', 1: 'countryName', 3: 'continent', 4: 'latitude', 5: 'longitude'},
	        'table': 'dim_country'},
	    'isrc': {'columns': {0: 'isrcId', 1: 'isrc', 2: 'isrcName', 3: 'releaseId'},
	        'table': 'dim_isrc'},
	    'store':{'columns': {0: 'storeId', 1: 'storeName'},
            'table': 'dim_store'}
	}
	return dimension_dicts

# @todo fetch DDL from either redshift or github
#
# dim_label
#
# labelid       | integer                     | 
# labelname     | character varying(1000)     | 
# priority      | integer                     | 
# countryid     | integer                     | 
# owner         | character varying(200)      | 
# last_updated  | timestamp without time zone | 
# date_created  | timestamp without time zone | 
# isdistributor | character varying(3)        | 
# ownerid       | integer                     | 
#
# dim_isrc
#
# isrcid                | integer                     | 
# isrc                  | character varying(100)      | 
# isrcname              | character varying(2000)     | 
# upc                   | bigint                      | 
# cd                    | integer                     | 
# track_id              | integer                     | 
# track_id_uniq         | integer                     | 
# vendor_catalog_number | character varying(200)      | 
# source                | character varying(25)       | 
# last_updated          | timestamp without time zone | 
# date_created          | timestamp without time zone | 
# labelid               | integer                     | 
#
# dim_catalog
#
# catalogid      | integer                     | 
# catalognumber  | character varying(2000)     | 
# catalogname    | character varying(2000)     | 
# labelid        | integer                     | 
# old_catalog_id | integer                     | 
# last_updated   | timestamp without time zone | 
# date_created   | timestamp without time zone | 
# subaccountid   | integer                     | 
#
# dim_country
#
# countryid    | integer                     | 
# countryname  | character varying(255)      | 
# country_code | character varying(2)        | 
# continent    | character varying(30)       | 
# latitude     | numeric(10,6)               | 
# longitude    | numeric(10,6)               | 
# date_created | timestamp without time zone | 
# last_updated | timestamp without time zone |
#
# dim_store
#
# storeid   | integer                | 
# storename | character varying(255) | 
# rawtable  | character varying(255) |