can I use a "insert into' statement in redshift ?
Comments
-
0
-
Hi @Ravendran,
It is possible to insert records into a transform dataset using an INSERT statement. The syntax to insert records is:
INSERT INTO table (column_name) VALUES ('value')
Simply add this command in your transform and disable the "Generate Table Output" textbox.
Please let me know if that does not answer your question.
**Say "Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
@Ravendran, did creed's reply help answer your question?
0 -
Is it possible to do the insert (or delete) on a domo dataset? I have a salesforce dataset that I want to be able to delete records from and insert new records on a daily basis. Being able to do the delete and insert on only the transform dataset does not help me unless I can write back to the original domo dataset that was used as input, but I do not believe that is possible.
0 -
@danielbest, please feel free to open up a new thread for better exposure to your question.
0 -
Did this ever get resolved? I'm trying to do the same thing (insert records into a DOMO dataset on a recurring basis) via redshift dataflow but not sure if it's possible.
0 -
0
-
Hi,
I have the same question. Was there ever a resolution to this?
0 -
Hi,
I figured out that you can add an output of a dataflow as an input of the same dataflow. I have been using this as a little trick to updating an existing DOMO dataset. So, I have my new/raw data and my existing set. I have the same output of the dataflow as an input and am updating the data with my new records. I don't set the dataflow to re-run when the dataset that is both an input and output is updated. Only runs when the raw data has changed. Hope this helps.
0
Categories
- 10.6K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 477 Transform
- 1.8K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 218 Visualize
- 260 Beast Mode
- 2.1K Charting
- 12 Variables
- 19 Automate
- 356 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 249 Distribute
- 65 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 191 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive