My query to make a new table from an existing table
CREATE TABLE CondensedDailyActivity AS
SELECT Id, ActivityDate, TotalSteps, TotalDistance, Calories FROM `bellabeatcasestudy-313023.fitbit_fitness_tracker_data.daily_activity`
I get this error message and do not know why or how to fix it. I am new to using SQL and I am trying to do a case study for my portfolio.
Table name "CondensedDailyActivity" missing dataset while no default dataset is set in the request.