Skip to main content

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!

Hey Tom! This article may help.


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 



Reply