For similar capabilities to Amazon Timestream for LiveAnalytics, consider Amazon Timestream for InfluxDB. It offers simplified data ingestion and single-digit millisecond query response times for real-time analytics. Learn more here.
SHOW statements
You can view all the databases in an account by using the SHOW DATABASES
statement. The syntax is as follows:
SHOW DATABASES [LIKE pattern]
where the LIKE clause can be used to filter database names.
You can view all the tables in an account by using the SHOW TABLES statement.
The syntax is as follows:
SHOW TABLES [FROM database] [LIKE pattern]
where the FROM clause can be used to filter database names and the
LIKE clause can be used to filter table names.
You can view all the measures for a table by using the SHOW MEASURES statement.
The syntax is as follows:
SHOW MEASURES FROM database.table [LIKE pattern]
where the FROM clause will be used to specify the database and table name and
the LIKE clause can be used to filter measure names.