I've been setting up data management framework. Because data modeling is the center of data management, first thing to do is for data modeling tool. the data modeling tool , Vertabelo, is what I want. It's online basis but it has almost everything offline tools have.

I have a question about flexiblity of the price policy.

There are 3 options for price policies which are Team , Premium and Basic. I will be the first user of the data modeling tool for short period , 2 month or 3 month in my company and then a few users will start to use the data modeling tool.

In this situation, after using Premium price policy for first a few months, I want to user Team price policy.

Does it work well in the price policy?

Hi, 

I would like to automate the creation of ERD models using vertabelo. We can do this via the UI at the moment, would it be possible to expose this functionality via the api so I can programatically generate xml, post it to vertabelo's api and have it return the model image back?

I am doing research and want to confirm that this tool can connect to an AZURE SQL Data Warehouse?  Also, has anyone had any luck connecting to a Snowflake database?  It looks like this is not supported yet.

I want to delete my account from Vertabelo, in my profile I see "close account" button. Which data is held after closing it? Can I ask for full deletion of my data?

When uploading the xml file previously generated from Veratbelo and trying to upload it back i get an internal server error

Hi, I´m trying to generate a physical model form a SQL script and it is not working at the moment. It simple doesn't let me click on Generate Model after selecting the SQL script. I'm on a free trial.

Thanks

Sergio

I've 2 csv files that will be provided to me every month. Both these files have the following fields: restaurant name, address, city & cuisine. These 2 files have a discrepancy in the restaurant name field, for ex: in the first csv file, the restaurant name is bel-air hotel & in the 2nd csv file it's hotel bel-air. However, the address & city field is the same in both the files which are 701 stone canyon rd. & bel air respectively. I need to do the following:

1) Combine these 2 data sources & ensure it produces accurate information- I was thinking to create a primary key such as restaurant_id & have a different table that would hold the restaurant information such as the restaraunt_id, name, address & city. Also, the other table would have the restaraut_id as foreign key & cuisine. Does this design make sense? If yes then I was thinking to dump these 2 files into a storage service such as Amazon s3 & then create a sql script that would copy the data from the s3 location to the db tables on the redshift followed by scheduling an ETL update job on a monthly time cadence. I can always directly import the csv files to OLAP cube & do all the ETL cleaning, curation, massaging, transformation & validation over there as well but just wondering how would I perform the data cleaning in the latter case

2) Resolve the discrepancy between the 2 data sources- Since I've created a separate table for the restaurant information, the discrepancy would cease to exists but I would like to know your thoughts about it. Is there any other approach to this?

3) Frame excellent questions for the data owners/ business owners-

The questions would cater around the 7Ws - who, what, when, where, why, how & how many. These seem to be the dimension tables but I don't seem to have an idea about what the fact table would be as there isn't any business event that's been mentioned to me. Can you please shed some light on this front as well?

4) The result of this analysis would be used as a feedback loop for the data owners to correct their source data. Build a report by listing all the columns & their definition as a feedback loop for data owners to fix the data errors in the source systems for continuous data improvements

Can you please help me on how do I get started with respect to the questions above? Appreciate all your help & thank you in advancerestaraunt 1
restaraunt2

Please add support for Postgres 11!!  Unique indexes. Sprocs.

Checking your article "A Dating App Data Model" I saw that in relations that appear from a many-to-many relationship (for instance between relations "user_account" and "gender") you add an artificial primary key (in the case exposed, primary key is a numeric field "id" but the primary key should be the combination of "user_account_id" and "gender_id").

Is there a technical reason to do that?

Is there any plan to provide support for MemSQL in near future?