Why does Syntasa create a Table and a View?



1 comment

  • Official comment
    Mike Z

    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.