{"id":10091,"date":"2023-10-30T17:22:47","date_gmt":"2023-10-30T16:22:47","guid":{"rendered":"https:\/\/smartdatamodels.org\/?p=10091"},"modified":"2023-10-30T17:27:05","modified_gmt":"2023-10-30T16:27:05","slug":"new-service-export-you-data-models-to-sql-schema","status":"publish","type":"post","link":"https:\/\/smartdatamodels.org\/index.php\/new-service-export-you-data-models-to-sql-schema\/","title":{"rendered":"New service: Export you data models to SQL schema"},"content":{"rendered":"

We provide a service to Generate a PostgreSQL schema SQL script from the model.yaml<\/strong> representation of a Smart Data Model.<\/p>\n

You can access this service under this link<\/a> following Tools > SQL service.<\/strong><\/p>\n

You need to provide as input the standard GitHub link to the model.yaml file or the raw version GitHub link.<\/p>\n

\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

We provide a service to Generate a PostgreSQL schema SQL script from the model.yaml representation of a Smart Data Model. You can access this service under this link following Tools > SQL service. You need to provide as input the standard GitHub link to the model.yaml file or the raw… More…<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[107,109,113,115,119,117,88,143,111,125,182,201],"tags":[],"class_list":["post-10091","post","type-post","status-publish","format-standard","hentry","category-smart-cities","category-smart-energy-domain","category-smart-environment","category-smart-manufacturing","category-smart-robotics","category-smart-water","category-smart-sensoring","category-smartaeronautics","category-smart-agrifood","category-smartdestinations","category-smarthealth","category-smartlogistics"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":10131,"url":"https:\/\/smartdatamodels.org\/index.php\/new-pysmartdatamodels-package-0-6-3-release\/","url_meta":{"origin":10091,"position":0},"title":"New pysmartdatamodels package 0.6.3 Release","author":"maestro","date":"02\/11\/2023","format":false,"excerpt":"We are thrilled to announce the latest update to pysmartdatamodels Python package, version 0.6.3, featuring a new function: generate_sql_schema()This addition enabling seamless generation of SQL schemas with just a few lines of code! Introducing\u00a0 generate_sql_schemqa() Function: With the new function, generate_sql_schemqa()\u00a0 pysmartdatamodels simplifies the process of creating SQL schemas for\u2026","rel":"","context":"In "Smart Cities domain"","block_context":{"text":"Smart Cities domain","link":"https:\/\/smartdatamodels.org\/index.php\/category\/smart-cities\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":9794,"url":"https:\/\/smartdatamodels.org\/index.php\/vote-for-the-new-sql-service-just-two-questions\/","url_meta":{"origin":10091,"position":1},"title":"Vote for the new SQL service (Just two questions)","author":"maestro","date":"05\/10\/2023","format":false,"excerpt":"We are very close to launch a new service and we want to have your feedback on how to create this service. So we made a Survey and you can help us by submitting your preference. Thank you!","rel":"","context":"In "Cross Sector"","block_context":{"text":"Cross Sector","link":"https:\/\/smartdatamodels.org\/index.php\/category\/cross-sector\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10263,"url":"https:\/\/smartdatamodels.org\/index.php\/metadata-of-the-catalogue-available\/","url_meta":{"origin":10091,"position":2},"title":"Metadata of the catalogue available","author":"maestro","date":"01\/02\/2024","format":false,"excerpt":"Now in the tools menu (currently the last option) you have a complete list of the most relevant links to the assets of the data models compile in the Smart Data Models initiative. You can check in the main menu -> Tools\u00a0 -> Metadata of the data models The information\u2026","rel":"","context":"In "Cross Sector"","block_context":{"text":"Cross Sector","link":"https:\/\/smartdatamodels.org\/index.php\/category\/cross-sector\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10291,"url":"https:\/\/smartdatamodels.org\/index.php\/new-version-of-pysmartdatamodels-package-0-6-4-with-adaptations-to-data-spaces\/","url_meta":{"origin":10091,"position":3},"title":"New version of pysmartdatamodels package 0.6.4 with adaptations to Data Spaces","author":"maestro","date":"26\/02\/2024","format":false,"excerpt":"There is a new version of the python package pysmartdatamodels to use it you have just to type pip install pysmartdatamodels in your system Besides the update in the list of data models it includes two new functions - look_for_data_model that allows approximate searches for a data model based on\u2026","rel":"","context":"In "Cross Sector"","block_context":{"text":"Cross Sector","link":"https:\/\/smartdatamodels.org\/index.php\/category\/cross-sector\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2024\/02\/pysmartdatamodels_0.6.4.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":788,"url":"https:\/\/smartdatamodels.org\/index.php\/new-file-new_model-yaml\/","url_meta":{"origin":10091,"position":4},"title":"New file new_model.yaml","author":"maestro","date":"24\/11\/2020","format":false,"excerpt":"You'll notice that there is a new file in the directory of the data models named new_model.yaml This file is a temporary version of model.yaml till we replace model.yaml (formerly created manually) for this new_model.yaml which is automatically generated from the json schema. some other changes will be announced soon.\u2026","rel":"","context":"In "Cross Sector"","block_context":{"text":"Cross Sector","link":"https:\/\/smartdatamodels.org\/index.php\/category\/cross-sector\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10005,"url":"https:\/\/smartdatamodels.org\/index.php\/new-sections-in-readme\/","url_meta":{"origin":10091,"position":5},"title":"New Sections in README","author":"maestro","date":"20\/10\/2023","format":false,"excerpt":"We have introduced several new sections in the README.md for all the smart data models that we've published These are: Links to CSV extensions of example payloads Links to SQL schema Services we designed to help self-contribution Such as in the data model WeatherForecast: Hope you find it useful and\u2026","rel":"","context":"In "Cross Sector"","block_context":{"text":"Cross Sector","link":"https:\/\/smartdatamodels.org\/index.php\/category\/cross-sector\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-18-at-18.32.18-1024x812.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-18-at-18.32.18-1024x812.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-18-at-18.32.18-1024x812.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-18-at-18.32.18-1024x812.png?resize=700%2C400&ssl=1 2x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/posts\/10091","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/comments?post=10091"}],"version-history":[{"count":1,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/posts\/10091\/revisions"}],"predecessor-version":[{"id":10107,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/posts\/10091\/revisions\/10107"}],"wp:attachment":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/media?parent=10091"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/categories?post=10091"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/tags?post=10091"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}