Can we setup 2FA for our Vertabelo users?  Does Vertabelo support SAML for SSO?

I am trying to create a view with columns that are the result of a sum statement.  For instance, when I add the code:

SELECT STATE, SUM(child_count) as Total_Children

from STATE_STATS

group by STATE;

The Total_Children column does not auto_populate  the column name or data type when I choose to "update_columns".  

the column names come back as column_n and the datatype comes back as "unknown".

How do I make this work correctly so that I do not have to manually rekey every column?

Hi

I worked for few hours this morning adding 3-4 tables and details and some more changes to the model. After a gap of 2 hours I came back to work and actually saved once manually as well. But for some reason I clicked on the back button of the browser and lost the work. Now if I even go back to an earlier version all of them showing me the same document.

Can someone suggest what can be the reason?

Thanks

Joydeep

Lets say I am adding new tables that have relationships to existing tables. When I select new tables and new relationships and use "selected only" option in SQL generation it doesn't generate foreign keys between new tables and existing tables (even though that relationship is specifically selected). The only workaround is to select existing tables as well and then remove DDL for existing tables from the script, which is cumbersome. 

Hi. I live and work in Italy, in the EU as Poland. Can we have our invoices in Euro instead than US Dollars?
Thanks

It would be really nice if you could connect to a database from Vertabelo and sync the tables directly.
It could be in a way that it would load the database, generate the diagram and once you change the diagram it would make a change script which you can apply directly from the Vertabelo website to the database itself. (in the best case it would try to apply it and show warning if it would fail)

(2 way syncing between Vertabelo and database) 

I am unable to get enterprise approval to use this software without an enterprise on-premises solution.  Options?