topic Re: lookup table data in Workato Pros Discussion Board

lookup table data

b-h-amarnath — Fri, 18 Mar 2022 04:04:48 GMT

How do you keep backup of lookup table data?

Re: lookup table data

christieparker — Fri, 18 Mar 2022 06:31:05 GMT

I'm curious about this. Should I be backing up my lookup tables? We don't keep client "data" in them but they are necessary parts of automations so if one was to get corrupted or wiped automations would break down. Is it best practice to keep back-ups? If so wouldn't it be simple enough to use a cron job to write them externally daily or weekly or is there something else I'm not considering?

Re: lookup table data

james-ng — Fri, 18 Mar 2022 12:59:14 GMT

There is a button on the top right to download as Excel CSV file, but have to do it manually

Re: lookup table data

sanjay-rathod — Mon, 21 Mar 2022 20:18:56 GMT

If you want to Archieved the lookup data...

Keep regulary (Weekly / mothly / quaterly / yearly) backup of Lookup data to external storage... like AWS S3 or on primised MySql database etc.

To do this backup process,

a) you can do it either manually export lookup table or

b) create a scheduled recipe for automaion.

After backup you can wipe out all the data from Lookup. or Rename the Lookup table as "_archieved" and make a replica (table schema) of that table for future reference.