Skip to main content
Question

System objects in Event collection

  • January 29, 2021
  • 2 replies
  • 1 view

Is there any system tables in Celonis we can check, for example, in Oracle, we have all_objects, user_tables such kind of tables we can have an overview understanding for one DB

2 replies

  • Level 0
  • November 8, 2021

Hi @lingzhi.lingzhi,

 

there are some system tables that you can use in Vertica. Some examples are:

 

  • tables
  • columns

 

Are you looking for something specific?

 

Simply execute the following statement:

 

SELECT * FROM tables

 

in the Celonis EMS.

 

Hopefully, that answers your questions!

 

Best,

 

Justin


lingzhi.li
Level 2
  • Level 2
  • November 9, 2021

Hi @lingzhi.lingzhi,

 

there are some system tables that you can use in Vertica. Some examples are:

 

  • tables
  • columns

 

Are you looking for something specific?

 

Simply execute the following statement:

 

SELECT * FROM tables

 

in the Celonis EMS.

 

Hopefully, that answers your questions!

 

Best,

 

Justin

Thank you Justin. Yes , I can use these tables now.