I am using celonis IBC and file uploads option to export eventlogs . By defalut celonis creates table with the csv file name, which we have uploaded. can we change the table name?
if i upload the same file multiple times with different data only the latest data available. How can we preserve previous versions of data?
you could rename your tables in Event Collection with
ALTER TABLE mytable RENAME TO mytable2;
Obs.: if you are working with non-sensitive data that it is ok to have it on a GDrive and you don't have other means to connect to another DB, you could also connect your Celonis IBC to GoogleSheets and drop the new data there.
Per default file uploads are pushed to the global scope. Gabe's options work but you in case you want to use this data in a different scope you can write a statement which creates this table in the scope you want it to be in. During that you need to give a name to the new table which is you option to give them distinct names.
Hope this helps
Kevin
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
