Skip to main content
May 29, 2024
Solved

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

  • May 29, 2024
  • 3 replies
  • 222 views

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
Phillip WAnswer
Lucid support team
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!

julien gAuthor
June 3, 2024

Thank you it’s really helpful.

I think it should be in the main documentation.

 

Best

Phillip W
Lucid support team
June 3, 2024

Hey @julien g -- happy to help!