Output Data: Adding data to existing .yxdb

schenkelpat

I am trying to add a daily snapshot to an existing .yxdb database.   Does anyone have any suggestions on how to achieve this? 

In SQL, I would achieve this with an insert statement like below:

Insert Into table_name as

(Select * from view/table)

Thanks,

Pat

Thableaus

Hi @schenkelpat 

I'd do something like this:

Get your "daily snapshot" unioned to your existing database and overwrite the file. Block Until Done is used so you don't have read/write to the same file at the same time problems.

Cheers,