1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
0
A DDL like that is mean to alter and actual catalog table, not an immutable view like is "study".
You also have to add some content to the column (even if it's a NULL placeholder you will fill in later).
Even better if you can set the value you need here using other columns.
For instance:
select *, 0 as AccessionNo from study
Contenus pertinents
- demandé il y a un an
- demandé il y a 8 mois
- demandé il y a un an
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a 3 ans
Pls accept apologies for the late response as I was busy with MVP deadlines. It actually worked. Thanks a lot @Gonzalo Herreros.
So, a follow up question. when a data catalog table is getting transformed with SQL transform, does the catalog table always referenced as a View?
They are separate things, a DDL (ALTER TABLE) updates the table, all the other transformations just exists while you make the query