Insert SQL script from BODS to Bigquerry not working

former_member1297747 — Mon, 14 Feb 2022 07:57:31 GMT

Below sql script doesn't give any validation error. When we execute the script, it says sucessfull, But we cannot see any rows inserted in Bigquerry.

sql('DS_BIGQUERY_DW', 'INSERT INTO BQD_Landing.TBL_run_details VALUES(\'a123\', \'running\', NULL)');

Re: Insert SQL script from BODS to Bigquerry not working

lenastodal — Mon, 14 Feb 2022 07:57:50 GMT

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.

For example, you can:
- outline what steps you took to find answers (and why they weren't helpful)
- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags
- use a more descriptive subject line

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://www.youtube.com/watch?v=46bt1juWUUM

topic Insert SQL script from BODS to Bigquerry not working in Application Development and Automation Discussions

Insert SQL script from BODS to Bigquerry not working

Re: Insert SQL script from BODS to Bigquerry not working