This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Is it possible to 'update, insert if new' using the in-database tools? Or is there another way to approach this? There's update but no 'update, insert if new' - my use case is I have a staging table that has last 30 days of data, and I want to 'update, insert if new' into the table that has a full history, updating any existing records and inserting new records. I've done this with the standard tools but it's just too slow so I was wondering if this could be done more efficiently using the in-DB tools.