It looks like the data type selection for Attributes has a typo. I think it should be DateTime not DataTime. 

Join IPA institute income tax classes and expand your knowledge, expertise in income tax and also learn government rules and law for income tax. Visit the tipa.in for more information.

Can you please add support for Snowflake Engine - https://www.snowflake.net

www.snowflake.com 

Analytics database as a service available as a service in AWS and Azure (and GCP on the roadmap).  JDBC connectivity, and ANSI-standard SQL.

after cancelling the subscription, my account is not working and i am not able to see all the models that i have create.

Please help on this.

I Mistakenly added basic plan accidently, becuase i needed the feature of adding subject area.

but in basic plan i am not able to do so, so please cancel the subscription and refund my money.

Does Vertabelo support Greenplum database? Since it supports PostgreSQL, it could be compatible with Greenplumn.

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?

Google BigQuery has now reached a maturity with their StandardSQL implementation that it should be relatively straightforward and stable to add support for BigQuery StandardSQL datatypes in Vertabelo.  This would be huge for me and many others in the big data space.