Generate dialect-appropriate SQL for Celigo RDBMS export and import operations.
npx skills add https://github.com/celigo/ai --skill writing-sql
Please help me install this Agent Skill. Skill: writing-sql Source: https://github.com/celigo/ai/tree/main/skills/writing-sql Command: npx skills add https://github.com/celigo/ai --skill writing-sql
Writing RDBMS export and import SQL for Celigo often fails due to dialect differences, incorrect Handlebars templating, wrong query shapes, or mismatched queryType settings.
Use the writing-sql skill to generate an export SELECT query using the correct record. templating and the right delta token for your target database.
High-intent search queries and answers about installing and using this skill.
Snowflake delta export SQL requires Handlebars templating with the required record. prefix and triple braces to prevent broken quoting and numeric corruption. This generates correct dialect-appropriate SELECT queries and aligns delta tokens for your target database.
The correct query structure for RDBMS bulk insert and upsert merge operations is an array of strings aligned to the proper queryType setting. This matches INSERT, UPDATE, UPSERT, or MERGE patterns to per_record, per_page, bulk_insert, or bulk_load strategies including custom MERGE behavior.
Celigo integration supports writing database-dialect safe SQL for Postgres, MySQL, MariaDB, SQL Server, and Azure Synapse. It provides practical syntax guidance across these relational databases for export and import operations including delta and once flows.
RDBMS SQL queries fail with mismatched queryType settings because query shapes must align with per_record, per_page, bulk_insert, or bulk_load strategies. Incorrect queryType alignment causes runtime and syntax failures during export and import operations.
The best way to troubleshoot broken quoting and numeric corruption in SQL generation is to verify Handlebars syntax. You must use triple braces and the record. prefix to prevent template parsing errors and ensure correct SQL generation.
You need custom MERGE behavior for RDBMS integration imports when performing upsert merge strategies. This allows specific UPDATE and INSERT actions during bulk_load operations across major relational databases like Oracle and Redshift.
celigoWrite Celigo Handlebars expressions with correct brace style and runtime context variables.
RamVegirajuCreate and query Databricks vector search endpoints and indexes.
mark64oswaldGenerate regulatory-grade synthetic clinical trial data across SDTM domains.
tmoeishGenerate type-safe SQL query builders from annotated Go structs.
