Skip to main content

ERD csv import not showing datatype in generated ERD diagram

  • May 18, 2017
  • 2 replies
  • 16 views

Tom P

When I import a CSV file that is the result of a query against a SQL Server db I do not see the datatype of columns indicated only the field lengths.  DataTypes I am importing are either 'dt'  'nchar' or 'decimal' types.

Is there any documentation on how the csv file is parsed and what could be causing the datatype to not be captured?

 

Thanks!

Comments

Sara M102
  • Lucidite
  • 63 replies
  • May 18, 2017

Hey Tom! This article may help.


Sara M102
  • Lucidite
  • 63 replies
  • May 18, 2017

Quick follow up. I reached out to our Product team to get more information about this. You should be able to include any text in the Data Type field and it should work. Can you take a screenshot of the generated ERD? 

I've attached an example CSV file here for ERD imports in case you want to double check that your file is formatted correctly