Gets a specific SQL snippet

1
{
2
  "id": "lorem",
3
  "inserted_at": "lorem",
4
  "updated_at": "lorem",
5
  "type": "sql",
6
  "visibility": "user",
7
  "name": "lorem",
8
  "description": "lorem",
9
  "project": {
10
    "id": 42,
11
    "name": "lorem"
12
  },
13
  "owner": {
14
    "id": 42,
15
    "username": "lorem"
16
  },
17
  "updated_by": {
18
    "id": 42,
19
    "username": "lorem"
20
  },
21
  "favorite": true,
22
  "content": {
23
    "favorite": true,
24
    "schema_version": "lorem",
25
    "sql": "lorem"
26
  }
27
}

1
{
2
  "type": "object",
3
  "properties": {
4
    "id": {
5
      "type": "string"
6
    },
7
    "inserted_at": {
8
      "type": "string"
9
    },
10
    "updated_at": {
11
      "type": "string"
12
    },
13
    "type": {
14
      "type": "string",
15
      "enum": [
16
        "sql"
17
      ]
18
    },
19
    "visibility": {
20
      "type": "string",
21
      "enum": [
22
        "user",
23
        "project",
24
        "org",
25
        "public"
26
      ]
27
    },
28
    "name": {
29
      "type": "string"
30
    },
31
    "description": {
32
      "type": "string",
33
      "nullable": true
34
    },
35
    "project": {
36
      "type": "object",
37
      "properties": {
38
        "id": {
39
          "type": "number"
40
        },
41
        "name": {
42
          "type": "string"
43
        }
44
      },
45
      "required": [
46
        "id",
47
        "name"
48
      ]
49
    },
50
    "owner": {
51
      "type": "object",
52
      "properties": {
53
        "id": {
54
          "type": "number"
55
        },
56
        "username": {
57
          "type": "string"
58
        }
59
      },
60
      "required": [
61
        "id",
62
        "username"
63
      ]
64
    },
65
    "updated_by": {
66
      "type": "object",
67
      "properties": {
68
        "id": {
69
          "type": "number"
70
        },
71
        "username": {
72
          "type": "string"
73
        }
74
      },
75
      "required": [
76
        "id",
77
        "username"
78
      ]
79
    },
80
    "favorite": {
81
      "type": "boolean"
82
    },
83
    "content": {
84
      "type": "object",
85
      "properties": {
86
        "favorite": {
87
          "deprecated": true,
88
          "description": "Deprecated: Rely on root-level favorite property instead.",
89
          "type": "boolean"
90
        },
91
        "schema_version": {
92
          "type": "string"
93
        },
94
        "sql": {
95
          "type": "string"
96
        }
97
      },
98
      "required": [
99
        "sql"
100
      ]
101
    }
102
  },
103
  "required": [
104
    "id",
105
    "inserted_at",
106
    "updated_at",
107
    "type",
108
    "visibility",
109
    "name",
110
    "description",
111
    "project",
112
    "owner",
113
    "updated_by",
114
    "favorite",
115
    "content"
116
  ]
117
}