Hello community - first post, total newbie.
I’ve dropped straight to the DDL, as I build a tool which enables the generation of complex data graphs for test and demonstration purposes.
I see (expected) statements such as:
CREATE TABLE @cdmDatabaseSchema.PERSON
But am puzzled as to the meaning of “@cdmDatabaseSchema” because without quoting, we can’t have a postgres schema of this name. So was wondering is this somekind of variable notation, or something we are supposed to search and replace?
Finally, is there a demonstration dataset available that we can upload into our empty database?
Many thanks for reading and for you time.