Why does Syntasa create a Table and a View?

Completed

Follow

Mike Z

November 15, 2019 19:37

For example, when I process Adobe Event Enrich there is a tb_event and vw_event created and available to query. How come you don't just configure the table with the column names instead of cust_fields and cust_metrics?

0

• Official comment

  

  Mike Z November 15, 2019 19:46

  Views allows you to change the column labels easily as we drop and recreate a view whenever data is processed.

  For tables we have to run alter commands to rename the table columns. This would render the old column name values to be inaccessible and only data subsequently processed from column rename will be available. This is because the column name metadata being associated with data values in Parquet format or ORC format.

  Comment actions Permalink

Please sign in to leave a comment.