Cases Study1 Example For Google Data Analytics

CREATE TABLE minutecalorieswide_merged (
  "id" BIGINT,
  "activityhour" VARCHAR,
  "calories00" DOUBLE,
  "calories01" DOUBLE,
  "calories02" DOUBLE,
  "calories03" DOUBLE,
  "calories04" DOUBLE,
  "calories05" DOUBLE,
  "calories06" DOUBLE,
  "calories07" DOUBLE,
  "calories08" DOUBLE,
  "calories09" DOUBLE,
  "calories10" DOUBLE,
  "calories11" DOUBLE,
  "calories12" DOUBLE,
  "calories13" DOUBLE,
  "calories14" DOUBLE,
  "calories15" DOUBLE,
  "calories16" DOUBLE,
  "calories17" DOUBLE,
  "calories18" DOUBLE,
  "calories19" DOUBLE,
  "calories20" DOUBLE,
  "calories21" DOUBLE,
  "calories22" DOUBLE,
  "calories23" DOUBLE,
  "calories24" DOUBLE,
  "calories25" DOUBLE,
  "calories26" DOUBLE,
  "calories27" DOUBLE,
  "calories28" DOUBLE,
  "calories29" DOUBLE,
  "calories30" DOUBLE,
  "calories31" DOUBLE,
  "calories32" DOUBLE,
  "calories33" DOUBLE,
  "calories34" DOUBLE,
  "calories35" DOUBLE,
  "calories36" DOUBLE,
  "calories37" DOUBLE,
  "calories38" DOUBLE,
  "calories39" DOUBLE,
  "calories40" DOUBLE,
  "calories41" DOUBLE,
  "calories42" DOUBLE,
  "calories43" DOUBLE,
  "calories44" DOUBLE,
  "calories45" DOUBLE,
  "calories46" DOUBLE,
  "calories47" DOUBLE,
  "calories48" DOUBLE,
  "calories49" DOUBLE,
  "calories50" DOUBLE,
  "calories51" DOUBLE,
  "calories52" DOUBLE,
  "calories53" DOUBLE,
  "calories54" DOUBLE,
  "calories55" DOUBLE,
  "calories56" DOUBLE,
  "calories57" DOUBLE,
  "calories58" DOUBLE,
  "calories59" DOUBLE
);

CREATE TABLE hourlysteps_merged (
  "id" BIGINT,
  "activityhour" VARCHAR,
  "steptotal" BIGINT
);

CREATE TABLE dailycalories_merged (
  "id" BIGINT,
  "activityday" TIMESTAMP,
  "calories" BIGINT
);

CREATE TABLE heartrate_seconds_merged (
  "id" BIGINT,
  "time" VARCHAR,
  "value" BIGINT
);

CREATE TABLE dailysteps_merged (
  "id" BIGINT,
  "activityday" TIMESTAMP,
  "steptotal" BIGINT
);

CREATE TABLE minuteintensitieswide_merged (
  "id" BIGINT,
  "activityhour" VARCHAR,
  "intensity00" BIGINT,
  "intensity01" BIGINT,
  "intensity02" BIGINT,
  "intensity03" BIGINT,
  "intensity04" BIGINT,
  "intensity05" BIGINT,
  "intensity06" BIGINT,
  "intensity07" BIGINT,
  "intensity08" BIGINT,
  "intensity09" BIGINT,
  "intensity10" BIGINT,
  "intensity11" BIGINT,
  "intensity12" BIGINT,
  "intensity13" BIGINT,
  "intensity14" BIGINT,
  "intensity15" BIGINT,
  "intensity16" BIGINT,
  "intensity17" BIGINT,
  "intensity18" BIGINT,
  "intensity19" BIGINT,
  "intensity20" BIGINT,
  "intensity21" BIGINT,
  "intensity22" BIGINT,
  "intensity23" BIGINT,
  "intensity24" BIGINT,
  "intensity25" BIGINT,
  "intensity26" BIGINT,
  "intensity27" BIGINT,
  "intensity28" BIGINT,
  "intensity29" BIGINT,
  "intensity30" BIGINT,
  "intensity31" BIGINT,
  "intensity32" BIGINT,
  "intensity33" BIGINT,
  "intensity34" BIGINT,
  "intensity35" BIGINT,
  "intensity36" BIGINT,
  "intensity37" BIGINT,
  "intensity38" BIGINT,
  "intensity39" BIGINT,
  "intensity40" BIGINT,
  "intensity41" BIGINT,
  "intensity42" BIGINT,
  "intensity43" BIGINT,
  "intensity44" BIGINT,
  "intensity45" BIGINT,
  "intensity46" BIGINT,
  "intensity47" BIGINT,
  "intensity48" BIGINT,
  "intensity49" BIGINT,
  "intensity50" BIGINT,
  "intensity51" BIGINT,
  "intensity52" BIGINT,
  "intensity53" BIGINT,
  "intensity54" BIGINT,
  "intensity55" BIGINT,
  "intensity56" BIGINT,
  "intensity57" BIGINT,
  "intensity58" BIGINT,
  "intensity59" BIGINT
);

CREATE TABLE minutemetsnarrow_merged (
  "id" BIGINT,
  "activityminute" VARCHAR,
  "mets" BIGINT
);

CREATE TABLE hourlyintensities_merged (
  "id" BIGINT,
  "activityhour" VARCHAR,
  "totalintensity" BIGINT,
  "averageintensity" DOUBLE
);

CREATE TABLE minutesleep_merged (
  "id" BIGINT,
  "date" VARCHAR,
  "value" BIGINT,
  "logid" BIGINT
);

CREATE TABLE minutestepsnarrow_merged (
  "id" BIGINT,
  "activityminute" VARCHAR,
  "steps" BIGINT
);

CREATE TABLE sleepday_merged (
  "id" BIGINT,
  "sleepday" VARCHAR,
  "totalsleeprecords" BIGINT,
  "totalminutesasleep" BIGINT,
  "totaltimeinbed" BIGINT
);

CREATE TABLE dailyintensities_merged (
  "id" BIGINT,
  "activityday" TIMESTAMP,
  "sedentaryminutes" BIGINT,
  "lightlyactiveminutes" BIGINT,
  "fairlyactiveminutes" BIGINT,
  "veryactiveminutes" BIGINT,
  "sedentaryactivedistance" DOUBLE,
  "lightactivedistance" DOUBLE,
  "moderatelyactivedistance" DOUBLE,
  "veryactivedistance" DOUBLE
);

CREATE TABLE minuteintensitiesnarrow_merged (
  "id" BIGINT,
  "activityminute" VARCHAR,
  "intensity" BIGINT
);

CREATE TABLE dailyactivity_merged (
  "id" BIGINT,
  "activitydate" TIMESTAMP,
  "totalsteps" BIGINT,
  "totaldistance" DOUBLE,
  "trackerdistance" DOUBLE,
  "loggedactivitiesdistance" DOUBLE,
  "veryactivedistance" DOUBLE,
  "moderatelyactivedistance" DOUBLE,
  "lightactivedistance" DOUBLE,
  "sedentaryactivedistance" DOUBLE,
  "veryactiveminutes" BIGINT,
  "fairlyactiveminutes" BIGINT,
  "lightlyactiveminutes" BIGINT,
  "sedentaryminutes" BIGINT,
  "calories" BIGINT
);

CREATE TABLE weightloginfo_merged (
  "id" BIGINT,
  "date" VARCHAR,
  "weightkg" DOUBLE,
  "weightpounds" DOUBLE,
  "fat" DOUBLE,
  "bmi" DOUBLE,
  "ismanualreport" BOOLEAN,
  "logid" BIGINT
);

CREATE TABLE minutestepswide_merged (
  "id" BIGINT,
  "activityhour" VARCHAR,
  "steps00" BIGINT,
  "steps01" BIGINT,
  "steps02" BIGINT,
  "steps03" BIGINT,
  "steps04" BIGINT,
  "steps05" BIGINT,
  "steps06" BIGINT,
  "steps07" BIGINT,
  "steps08" BIGINT,
  "steps09" BIGINT,
  "steps10" BIGINT,
  "steps11" BIGINT,
  "steps12" BIGINT,
  "steps13" BIGINT,
  "steps14" BIGINT,
  "steps15" BIGINT,
  "steps16" BIGINT,
  "steps17" BIGINT,
  "steps18" BIGINT,
  "steps19" BIGINT,
  "steps20" BIGINT,
  "steps21" BIGINT,
  "steps22" BIGINT,
  "steps23" BIGINT,
  "steps24" BIGINT,
  "steps25" BIGINT,
  "steps26" BIGINT,
  "steps27" BIGINT,
  "steps28" BIGINT,
  "steps29" BIGINT,
  "steps30" BIGINT,
  "steps31" BIGINT,
  "steps32" BIGINT,
  "steps33" BIGINT,
  "steps34" BIGINT,
  "steps35" BIGINT,
  "steps36" BIGINT,
  "steps37" BIGINT,
  "steps38" BIGINT,
  "steps39" BIGINT,
  "steps40" BIGINT,
  "steps41" BIGINT,
  "steps42" BIGINT,
  "steps43" BIGINT,
  "steps44" BIGINT,
  "steps45" BIGINT,
  "steps46" BIGINT,
  "steps47" BIGINT,
  "steps48" BIGINT,
  "steps49" BIGINT,
  "steps50" BIGINT,
  "steps51" BIGINT,
  "steps52" BIGINT,
  "steps53" BIGINT,
  "steps54" BIGINT,
  "steps55" BIGINT,
  "steps56" BIGINT,
  "steps57" BIGINT,
  "steps58" BIGINT,
  "steps59" BIGINT
);

CREATE TABLE minutecaloriesnarrow_merged (
  "id" BIGINT,
  "activityminute" VARCHAR,
  "calories" DOUBLE
);

CREATE TABLE hourlycalories_merged (
  "id" BIGINT,
  "activityhour" VARCHAR,
  "calories" BIGINT
);