Like any data warehouse, Space and Time Database accepts standard SQL to efficiently query data. While SQL is fairly easy for most data analysts, it still presents a barrier of use to business professionals and non-technical users.

To expand the number of users that can directly participate in directly asking analytic queries, Space and Time allows users to type in natural language queries, which AI automatically translates into SQL and executes on the user's behalf. This opens the door for non-technical users to ask their own questions directly, using their own language of choice, rather than waiting in a work queue for the next data analyst.

Try out AI-SQL on Space and Time

Running natural language SQL wouldn't be interesting if it were difficult - fortunately it's extremely easy!

Click on the "Queries" tab so that the "Query Editor" pops up. You might notice that the empty editor invites you to:

Write a SQL query or natural language query prompt...

Let's try a simple prompt using preloaded Ethereum data. Enter in the query editor:

show me the count of Ethereum wallets with a balance greater than a billion for last week

...and hit the "Run Query".

🚧

There is a toggle in the upper-right of the query editor - make sure this is "AI Enabled" (default) to take advantage of this capability!

The LLM is sent context by the Space and Time Database on the data model, table/column meaning, business context, etc. All of this context ensures the SQL written by the AI will be accurate.

The sample prompt above generated the SQL, and result:

You'll see that your original prompt was left at the top of the SQL, commented out (in green). This allows you to see your original request, and compare it to the SQL below if you have questions.

Other Prompts to Try:

Tips and Tricks: