CrateDB Table Creation and Data Insertion
detail.loadingPreview
Workflow to create a table in CrateDB and insert a record.
About This Workflow
This workflow demonstrates how to interact with CrateDB using n8n. It first creates a table named 'test' with 'id' and 'name' columns, and then inserts a single record into it.
Key Features
- CrateDB Integration: Connects to and executes queries on a CrateDB instance.
- Table Creation: Dynamically creates a SQL table.
- Data Insertion: Inserts structured data into the created table.
How To Use
- Ensure you have a CrateDB instance running and accessible.
- Configure the
cratedb_credscredential in n8n with your CrateDB connection details. - The workflow starts with a manual trigger.
- Upon execution, the first CrateDB node (
CrateDB) will execute theCREATE TABLEquery. - The 'Set' node then prepares the data to be inserted.
- The second CrateDB node (
CrateDB1) is configured to insert data into the 'test' table. Note: The current JSON snippet showsCrateDB1configured to fetch columns, not insert. To insert, this node would need to be modified to use anINSERTquery operation.
Apps Used
Workflow JSON
{
"id": "57cb07f8-d5ed-4b55-90f1-f129a706aea5",
"name": "CrateDB Table Creation and Data Insertion",
"nodes": 27,
"category": "Database",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 57cb07f8-d5ed...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
Statistics
Related Workflows
Discover more workflows you might like
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.
Automate Local Business Outreach with AI-Powered Yelp Scraper
This workflow automates the process of scraping local business details from Yelp using AI, then leverages that data to send personalized partnership proposals via Gmail. It's perfect for sales and marketing teams looking to streamline lead generation and outreach campaigns.
Automate Getty Images Editorial Search & CMS Integration
This n8n workflow automates searching for editorial images on Getty Images, extracts key details and embed codes, and prepares them for seamless integration into your Content Management System (CMS), streamlining your content creation process.