1
General Board / EA16 - Issue with custom database (Owner & column options)
« on: April 03, 2025, 10:21:43 pm »
I created a data types for a custom SnowFlake database but I have the following issues:
- I copied all the DDL templates from Postgres over to my SnowFlake templates. DDL generation for a table works, but the %ddlOwner% in the template is not populated and thus does not populate into the generated DDL. If I change my table to Postgres, the table owner is added to the generated DDL. Seems something is missing somewhere in how the custom database is set up.
- When I create a SQL 2012 table and add a column, I can set the column to be Auto Increment. This option is not available under my own SnowFlake data types. How can I enable that?
- I copied all the DDL templates from Postgres over to my SnowFlake templates. DDL generation for a table works, but the %ddlOwner% in the template is not populated and thus does not populate into the generated DDL. If I change my table to Postgres, the table owner is added to the generated DDL. Seems something is missing somewhere in how the custom database is set up.
- When I create a SQL 2012 table and add a column, I can set the column to be Auto Increment. This option is not available under my own SnowFlake data types. How can I enable that?