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
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 88 SQL DataFlows
- 554 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 564 Beast Mode
- 9 App Studio
- 27 Variables
- 577 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 22 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 91 Manage
- 88 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive