Error message when creating a table from a table in BigQuery

1

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.

ERROR MESSAGE:
Table name "CondensedDailyActivity" missing dataset while no default dataset is set in the request.

2

Hi @aanderson6
Metabase is a reporting tool and not meant to write to your database. Use another tool for modifying your database structure - example DBeaver.io

3

Sorry I thought this was a place to come get answers. I'll go somewhere else.