Skip to main content
Answer

where can i find the specification of the csv import for database schema (ERD format) in Lucidchart

  • May 29, 2024
  • 3 replies
  • 165 views

Forum|alt.badge.img+1

I’d like to import schema and relation from a database (bigquery) that is not supported by the import feature of lucid.

I have all the informations and metadata to generate the import file, but i am unable to find a specification of this file to be able to  generate the relationship between objects.

 

We have retrofit some things from the sql examples, but impossible to find how to generate primary/foreign keys and the relationship.

 

Is there a file format specification somewhere ?

Best answer by Phillip W

Hey @julien g -- thanks for posting!  If you are able to generate an output file in the format our ERD importer expects you should be able to import successfully. I've attached an example output file from a PostGreSQL import for reference, that is the format our importer will need your file to be in.

Hope this helps!

Comments

Phillip W
Forum|alt.badge.img+16
  • Lucid support team
  • Answer
  • May 30, 2024

Hey @julien g -- thanks for posting!  If you are able to generate an output file in the format our ERD importer expects you should be able to import successfully. I've attached an example output file from a PostGreSQL import for reference, that is the format our importer will need your file to be in.

Hope this helps!


Forum|alt.badge.img+1
  • Author
  • June 3, 2024

Thank you it’s really helpful.

I think it should be in the main documentation.

 

Best


Phillip W
Forum|alt.badge.img+16
  • Lucid support team
  • June 3, 2024

Hey @julien g -- happy to help!