Workflow - RetoolDB - Insert All Results of Query Into Table - Error

Please help inserting all records from SQL into an existing table

Workflow

  1. Trigger daily 5AM
  2. Remove all records from destination table: TRUNCATE ONLY session_logs_processed;
  3. Query source table with transformed data
  4. Insert all transformed records into destination table: INSERT INTO session_logs_processed SELECT * FROM {{sourceDb.data}};

Error received on Step 4. Insert all transformed records into destination table

Error evaluating destinationDb: syntax error at or near "$1"
--- Failed running query: destinationDb ---
--- Hit failure ---

Work Flow URL

@ryanrunchey, have you tried using the GUI mode when writing to the DB?

1 Like

Hi @jocen ,

Yes, after much reading and re-reading, I found that GUI Upsert solution here: 5. Upsert account records into the database‚Äč. Thanks!

2 Likes