Adding columns to Timestream table in the AWS web query editor

Question

First...is it possible?

I am trying to add a column to a table called "MedFlaminator". I just created the table and it has the default layout. Two columns exist:

> measure_name	varchar	MEASURE_NAME

> time	timestamp	TIMESTAMP

My query looks like this:

> alter table MedFlaminator
add column feedback_score int

I have tried all kinds of combinations of this query. I am getting the following error:

> 10:58:16 AM	 Failed	The query syntax is invalid at line 1:1	
alter table MedFlaminator add column feedback_score int

What is wrong here?

flycast · Accepted Answer

I found my answer. Although Timestream uses sql language the database tables are not managed the same way. Timestream tables get columns automatically added based on what data you send them. I highly recommend watching [this deep dive](https://youtu.be/39ijv_pfWSQ) (it really isn't that hard). This video is very, very worth while.

Adding columns to Timestream table in the AWS web query editor

Add your answer

Relevant content