# artist table
artist_id = "artist_id"
name = "artist_name"
location = "artist_location"
latitude = "artist_latitude"
longitude = "artist_longitude"

# song table
song_id = "song_id"
title = "title"
artist_id = "artist_id"
year = "year"
duration = "duration"

# user table
user_id = "userId"
first_name = "firstName"
last_name = "lastName"
gender = "gender"
level = "level"

# time table
start_time = "ts"
hour = "hour"
day = "day"
week = "week"
month = "month"
year = "year"
weekday = "weekday"

# songplay table
songplay_id = "songplayIndex"
#start_time = "ts"
#user_id = "userId"
#level = "level"
#song_id = "song_id"
#artist_id = "artist_id"
session_id = "sessionId"
locationSP = "location"
user_agent = "userAgent"
song = "song"
artist = "artist"

# Test data
#    input_song_data = 's3a://udacity-dend/song_data/A/B/C/TRABCEI128F424C983.json'
#    input_log_data = 's3a://udacity-dend/log_data/2018/11/2018-11-12-events.json'