To create the table, we need a DDL statement - it still feels weird to say stuff like that regarding a NoSQL database
CREATE TABLE TWEETS_TABLE(id LONG, text STRING, author STRING, tweet_timestamp TIMESTAMP(0), language STRING, hashtags STRING, PRIMARY KEY(SHARD(id))) USING TTL 1 DAYS
This can be done in OCI CLI. It is convenient to first set the compartment OCID
export COMPARTMENT_OCID=ocid................................
Then: