{"id":25,"date":"2022-02-08T16:33:15","date_gmt":"2022-02-08T16:33:15","guid":{"rendered":"https:\/\/openquery.com\/?p=25"},"modified":"2022-02-28T13:55:55","modified_gmt":"2022-02-28T13:55:55","slug":"what-is-a-snapshot-sql","status":"publish","type":"post","link":"https:\/\/openquery.com\/what-is-a-snapshot-sql\/","title":{"rendered":"What Is A Snapshot SQL?"},"content":{"rendered":"\n<p>A database snapshot in SQL Server is a read-only, static view of the database (the source database). <\/p>\n\n\n\n<p>The database snapshot is transactionally consistent with the source database at the time of snapshot production.<\/p>\n\n\n\n<p>A database snapshot is always saved on the same server instance as the source database. <\/p>\n\n\n\n<p>While database snapshots provide a read-only view of the data in the state it was in at the time the snapshot was created, the snapshot file grows in size as changes are made to the source database.<\/p>\n\n\n\n<p>It is possible to create several snapshots of a source database. Each database snapshot is permanent until it is voluntarily deleted by the database owner.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"569\" src=\"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/What-Is-A-Snapshot-SQL-1024x569.jpg\" alt=\"What Is A Snapshot SQL\" class=\"wp-image-27\" srcset=\"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/What-Is-A-Snapshot-SQL-1024x569.jpg 1024w, https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/What-Is-A-Snapshot-SQL-300x167.jpg 300w, https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/What-Is-A-Snapshot-SQL-768x427.jpg 768w, https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/What-Is-A-Snapshot-SQL.jpg 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p>Read on to learn even more about snapshots in <a href=\"https:\/\/openquery.com\/what-is-sql-server\/\" target=\"_blank\" rel=\"noopener\">SQL servers<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"an-in-depth-look-at-snapshots\"><strong>An In-Depth Look At Snapshots<\/strong><\/h2>\n\n\n\n<p>Database snapshots are performed from data page by data page. <\/p>\n\n\n\n<p>The original page is transferred from the source database to the snapshot prior to the first update of a page in the source database. <\/p>\n\n\n\n<p>The snapshot preserves the original page, preserving all data records in their original state at the moment the snapshot was created. <\/p>\n\n\n\n<p>The same approach is repeated for each page that is modified for the first time. <\/p>\n\n\n\n<p>Because read operations on a database snapshot always access the original data pages, regardless of their location, they appear to be unchanged to the user.<\/p>\n\n\n\n<p>The snapshot stores the replicated original pages in one or more sparse files. A sparse file is a file that does not include any user data and has not yet been allotted disc space for user data. <\/p>\n\n\n\n<p>The file grows in size as the number of pages modified in the source database rises.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"benefits-of-snapshots\"><strong>Benefits Of Snapshots<\/strong><\/h2>\n\n\n\n<p>There are several benefits of snapshotting your data. Here are the best reasons why it should be done:<\/p>\n\n\n\n<ul><li>Reports may be generated using snapshots.<\/li><li>Clients can query a database snapshot, allowing for the creation of reports based on the data included in the snapshot at the time the snapshot was produced.<\/li><\/ul>\n\n\n\n<ul><li>Maintaining historical data in order to make reports.<\/li><li>A snapshot enables people to have access to data from a specific point in time. For example, you can generate a database snapshot at the conclusion of a certain time period (for example, a fiscal quarter) for use in later reports. After then, the snapshot may be utilized to produce period-end reports. <\/li><\/ul>\n\n\n\n<ul><li>Additionally, if sufficient disc space is available, you may preserve end-of-period snapshots indefinitely, allowing queries against the results of these periods for reasons such as analyzing organizational performance.<\/li><li>By utilizing a mirror database that you maintain for availability purposes, you may offload reports.<\/li><li>By combining database snapshots with database mirroring, you may enable reportability for the data on the mirror server. Additionally, searching the mirror database relieves the original database of resources.<\/li><\/ul>\n\n\n\n<ul><li>Defending Data Against Administrative Errors<\/li><li>If a user makes a mistake on a source database, it can be restored to the state it was in when a database snapshot was created. The loss of data is restricted to database changes made since the snapshot was produced. <\/li><li>Creating a database snapshot, for example, prior to conducting large changes, such as a bulk update or schema change, saves data. If you make a mistake, you may revert to the snapshot and restore the database. Although reverting is potentially faster than restoring from a backup, you cannot roll back later.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"defending-data-from-human-error\"><strong>Defending Data From Human Error<\/strong><\/h2>\n\n\n\n<p>By creating database snapshots on a regular basis, you may mitigate the impact of a large user error, such as a dropped table. <\/p>\n\n\n\n<p>To ensure optimal security, you can create a series of database snapshots that span enough time to notice and respond to the vast majority of user failures. <\/p>\n\n\n\n<p>For instance, depending on the capacity of your hard disc, you may maintain six to twelve rolling snapshots throughout a 24-hour period. Following that, each time a new snapshot is created, the prior one can be deleted.<\/p>\n\n\n\n<p>You can roll back the database to the snapshot taken right before the incident occurred to recover from a user mistake. Although reverting is potentially faster than restoring from a backup, you cannot roll back later.<\/p>\n\n\n\n<p>Alternatively, using the data included in a snapshot, you may be able to manually reconstruct a lost table or other missing data. For instance, you might bulk transfer data from the snapshot to the database and then merge it back in manually.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"creating-and-maintaining-a-test-database\"><strong>Creating And Maintaining A Test Database<\/strong><\/h2>\n\n\n\n<p>When regularly performing a test procedure in a testing environment, it might be advantageous for the database to include identical data at the start of each cycle of testing. <\/p>\n\n\n\n<p>An application developer or tester can produce a database snapshot of the test database prior to performing the first cycle. Following each test run, the database snapshot may be rapidly restored to its previous condition.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"key-definitions\"><strong>Key Definitions<\/strong><\/h2>\n\n\n\n<p>Here are some keywords that are commonly used in database language and their definitions.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"a-database-snapshot\"><strong>A Database Snapshot<\/strong><\/h3>\n\n\n\n<p>The transactionally consistent, read-only, static representation of a database (the source database).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"source-database\"><strong>Source Database<\/strong><\/h3>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"569\" src=\"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/Source-Database-1024x569.jpg\" alt=\"Source Database\" class=\"wp-image-28\" srcset=\"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/Source-Database-1024x569.jpg 1024w, https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/Source-Database-300x167.jpg 300w, https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/Source-Database-768x427.jpg 768w, https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/Source-Database.jpg 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p>The database was used to create the database snapshot. Database snapshots are relational in nature and rely on the source database. <\/p>\n\n\n\n<p>The snapshots of a database must be kept on the same server instance as the database itself. Additionally, if a database becomes inaccessible for whatever reason, all of its database snapshots become unavailable.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"sparse-file\"><strong>Sparse File<\/strong><\/h3>\n\n\n\n<p>A file produced by the NTFS file system requires significantly less disc space than it would otherwise. A sparse file is used to store pages that have been copied to a database snapshot. <\/p>\n\n\n\n<p>When a sparse file is created, it takes up very little disc space. As data is written to a database snapshot, NTFS gradually allocates space on the disc to the corresponding sparse file.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"to-conclude\"><strong>To Conclude<\/strong><\/h2>\n\n\n\n<p>In an SQL server, a snapshot is a statistical view of the database (the source database) that can only be seen by the person who made it. <\/p>\n\n\n\n<p>A database snapshot should always be kept on the same server as the original database for security reasons.<\/p>\n\n\n\n<p>There are several benefits to snapshotting a database occasionally, one of which is preventing human error in your data. <\/p>\n\n\n\n<p>It is also a very useful method you can use to generate accurate reports of data from a specific database and time period.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"container-lazyload preview-lazyload container-youtube js-lazyload--not-loaded\"><a href=\"https:\/\/www.youtube.com\/watch?v=BHMU04ylwsw\" class=\"lazy-load-youtube preview-lazyload preview-youtube\" data-video-title=\"SQL Server Tutorial 24: Database snapshots\" title=\"Play video &quot;SQL Server Tutorial 24: Database snapshots&quot;\">https:\/\/www.youtube.com\/watch?v=BHMU04ylwsw<\/a><noscript>Video can&#8217;t be loaded because JavaScript is disabled: <a href=\"https:\/\/www.youtube.com\/watch?v=BHMU04ylwsw\" title=\"SQL Server Tutorial 24: Database snapshots\">SQL Server Tutorial 24: Database snapshots (https:\/\/www.youtube.com\/watch?v=BHMU04ylwsw)<\/a><\/noscript><\/div>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>A database snapshot in SQL Server is a read-only, static view of the database (the source database). The database snapshot is transactionally consistent with the source database at the time of snapshot production. A database snapshot is always saved on the same server instance as the source database. While database snapshots provide a read-only view &#8230; <a title=\"What Is A Snapshot SQL?\" class=\"read-more\" href=\"https:\/\/openquery.com\/what-is-a-snapshot-sql\/\" aria-label=\"More on What Is A Snapshot SQL?\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":27,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[6],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.11 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>What Is A Snapshot SQL? - Open Query<\/title>\n<meta name=\"description\" content=\"A snapshot SQL is a SQL query that takes a snapshot of the data in a database table at a certain point in time.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/openquery.com\/what-is-a-snapshot-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What Is A Snapshot SQL? - Open Query\" \/>\n<meta property=\"og:description\" content=\"A snapshot SQL is a SQL query that takes a snapshot of the data in a database table at a certain point in time.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/openquery.com\/what-is-a-snapshot-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Open Query\" \/>\n<meta property=\"article:published_time\" content=\"2022-02-08T16:33:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-28T13:55:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/What-Is-A-Snapshot-SQL.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"667\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Albert Niall\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Albert Niall\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/openquery.com\/what-is-a-snapshot-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/openquery.com\/what-is-a-snapshot-sql\/\"},\"author\":{\"name\":\"Albert Niall\",\"@id\":\"https:\/\/openquery.com\/#\/schema\/person\/95a786c4eec250fba9d6c71974a39656\"},\"headline\":\"What Is A Snapshot SQL?\",\"datePublished\":\"2022-02-08T16:33:15+00:00\",\"dateModified\":\"2022-02-28T13:55:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/openquery.com\/what-is-a-snapshot-sql\/\"},\"wordCount\":1054,\"publisher\":{\"@id\":\"https:\/\/openquery.com\/#organization\"},\"articleSection\":[\"Knowledge Base\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/openquery.com\/what-is-a-snapshot-sql\/\",\"url\":\"https:\/\/openquery.com\/what-is-a-snapshot-sql\/\",\"name\":\"What Is A Snapshot SQL? - Open Query\",\"isPartOf\":{\"@id\":\"https:\/\/openquery.com\/#website\"},\"datePublished\":\"2022-02-08T16:33:15+00:00\",\"dateModified\":\"2022-02-28T13:55:55+00:00\",\"description\":\"A snapshot SQL is a SQL query that takes a snapshot of the data in a database table at a certain point in time.\",\"breadcrumb\":{\"@id\":\"https:\/\/openquery.com\/what-is-a-snapshot-sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/openquery.com\/what-is-a-snapshot-sql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/openquery.com\/what-is-a-snapshot-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/openquery.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What Is A Snapshot SQL?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/openquery.com\/#website\",\"url\":\"https:\/\/openquery.com\/\",\"name\":\"Open Query\",\"description\":\"Everything about IT\",\"publisher\":{\"@id\":\"https:\/\/openquery.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/openquery.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/openquery.com\/#organization\",\"name\":\"Open Query\",\"url\":\"https:\/\/openquery.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/openquery.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/cropped-openquerylogo.png\",\"contentUrl\":\"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/cropped-openquerylogo.png\",\"width\":1016,\"height\":323,\"caption\":\"Open Query\"},\"image\":{\"@id\":\"https:\/\/openquery.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/openquery.com\/#\/schema\/person\/95a786c4eec250fba9d6c71974a39656\",\"name\":\"Albert Niall\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/openquery.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4728d76122b10a705d1e313fb3a924de?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4728d76122b10a705d1e313fb3a924de?s=96&d=mm&r=g\",\"caption\":\"Albert Niall\"},\"description\":\"Hi, I\u2019m Albert Niall, and I want people to make the most out of their online presence and use it to their advantage. Here at Open Query I want to make it as easy as possible for you to learn about topics that might not be easily accessible elsewhere online. I don\u2019t know about you, but I haven\u2019t seen many other websites talking about the MariaDB Foundation and its updates. That\u2019s what makes Open Query truly unique. While others might assume everyone knows this information already automatically, I am filling my online resource to help.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What Is A Snapshot SQL? - Open Query","description":"A snapshot SQL is a SQL query that takes a snapshot of the data in a database table at a certain point in time.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/openquery.com\/what-is-a-snapshot-sql\/","og_locale":"en_US","og_type":"article","og_title":"What Is A Snapshot SQL? - Open Query","og_description":"A snapshot SQL is a SQL query that takes a snapshot of the data in a database table at a certain point in time.","og_url":"https:\/\/openquery.com\/what-is-a-snapshot-sql\/","og_site_name":"Open Query","article_published_time":"2022-02-08T16:33:15+00:00","article_modified_time":"2022-02-28T13:55:55+00:00","og_image":[{"width":1200,"height":667,"url":"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/What-Is-A-Snapshot-SQL.jpg","type":"image\/jpeg"}],"author":"Albert Niall","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Albert Niall","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/openquery.com\/what-is-a-snapshot-sql\/#article","isPartOf":{"@id":"https:\/\/openquery.com\/what-is-a-snapshot-sql\/"},"author":{"name":"Albert Niall","@id":"https:\/\/openquery.com\/#\/schema\/person\/95a786c4eec250fba9d6c71974a39656"},"headline":"What Is A Snapshot SQL?","datePublished":"2022-02-08T16:33:15+00:00","dateModified":"2022-02-28T13:55:55+00:00","mainEntityOfPage":{"@id":"https:\/\/openquery.com\/what-is-a-snapshot-sql\/"},"wordCount":1054,"publisher":{"@id":"https:\/\/openquery.com\/#organization"},"articleSection":["Knowledge Base"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/openquery.com\/what-is-a-snapshot-sql\/","url":"https:\/\/openquery.com\/what-is-a-snapshot-sql\/","name":"What Is A Snapshot SQL? - Open Query","isPartOf":{"@id":"https:\/\/openquery.com\/#website"},"datePublished":"2022-02-08T16:33:15+00:00","dateModified":"2022-02-28T13:55:55+00:00","description":"A snapshot SQL is a SQL query that takes a snapshot of the data in a database table at a certain point in time.","breadcrumb":{"@id":"https:\/\/openquery.com\/what-is-a-snapshot-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/openquery.com\/what-is-a-snapshot-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/openquery.com\/what-is-a-snapshot-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/openquery.com\/"},{"@type":"ListItem","position":2,"name":"What Is A Snapshot SQL?"}]},{"@type":"WebSite","@id":"https:\/\/openquery.com\/#website","url":"https:\/\/openquery.com\/","name":"Open Query","description":"Everything about IT","publisher":{"@id":"https:\/\/openquery.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/openquery.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/openquery.com\/#organization","name":"Open Query","url":"https:\/\/openquery.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/openquery.com\/#\/schema\/logo\/image\/","url":"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/cropped-openquerylogo.png","contentUrl":"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/cropped-openquerylogo.png","width":1016,"height":323,"caption":"Open Query"},"image":{"@id":"https:\/\/openquery.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/openquery.com\/#\/schema\/person\/95a786c4eec250fba9d6c71974a39656","name":"Albert Niall","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/openquery.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4728d76122b10a705d1e313fb3a924de?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4728d76122b10a705d1e313fb3a924de?s=96&d=mm&r=g","caption":"Albert Niall"},"description":"Hi, I\u2019m Albert Niall, and I want people to make the most out of their online presence and use it to their advantage. Here at Open Query I want to make it as easy as possible for you to learn about topics that might not be easily accessible elsewhere online. I don\u2019t know about you, but I haven\u2019t seen many other websites talking about the MariaDB Foundation and its updates. That\u2019s what makes Open Query truly unique. While others might assume everyone knows this information already automatically, I am filling my online resource to help."}]}},"_links":{"self":[{"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/posts\/25"}],"collection":[{"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/comments?post=25"}],"version-history":[{"count":9,"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/posts\/25\/revisions"}],"predecessor-version":[{"id":252,"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/posts\/25\/revisions\/252"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/media\/27"}],"wp:attachment":[{"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/media?parent=25"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/categories?post=25"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/tags?post=25"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}