Create Table and Insert Data in QuestDB

This automation workflow is designed to efficiently create a table within QuestDB and insert data into it. Upon execution, the workflow first triggers a manual execution event, allowing users to start the process at their convenience. Once initiated, it sets predefined values, including an ID and a name, which are essential for the subsequent data insertion step.

The core functionality of this workflow revolves around the QuestDB node, which executes a SQL query to create a new table labeled 'test'. This table is structured to accommodate integer and string data types, specifically for the columns 'id' and 'name'. The creation of this table is crucial for organizing and storing data efficiently within the database.

After establishing the table's structure, the workflow proceeds to insert the defined data using the same QuestDB node, ensuring that the data aligns with the table schema. This streamlined process not only saves time but also minimizes the potential for human error when creating tables and entering data.

This workflow is particularly beneficial for personal projects involving data management, quick prototyping, or even for users looking to familiarize themselves with database operations in QuestDB. It serves as a practical example of how to automate database interactions, making it an invaluable tool for developers and data enthusiasts alike.