View

Use the Catalog API to retrieve, create, update, and delete views.

View Object

{
  "entityType": "dataset",
  "id": "ef99ab32-89ca-4d1c-9e91-2c8be861bb8a",
  "type": "VIRTUAL_DATASET",
  "path": [
    "Business",
    "Transportation",
    "NYC-taxi-trips-short-distance"
  ],
  "createdAt": "2022-11-17T18:31:23.236Z",
  "isMetadataExpired": false, 
  "lastMetadataRefreshAt": "2024-01-31T09:50:01.012Z", 
  "tag": "f90d1526-e64b-47b1-9ab0-d25df5247cab",
  "sql": "SELECT * FROM \"NYC-taxi-trips\" WHERE trip_distance_mi <= 2.0 ORDER BY trip_distance_mi ASC",
  "sqlContext": [
    "Samples",
    "samples.dremio.com"
  ],
  "accessControlList": {
    "users": [
      {
        "id": "c590ed7f-b2b4-4e1f-ba7d-94173afdc9a3",
        "permissions": [
          "SELECT",
          "ALTER"
        ]
      },
      {
        "id": "30fca499-4abc-4469-7142-fc8dd29acac8",
        "permissions": [
          "SELECT",
          "ALTER",
          "MANAGE_GRANTS"
        ]
      }
    ],
    "roles": [
      {
        "id": "76a9884b-aea5-46d5-a73a-000edf23f390",
        "permissions": [
          "SELECT",
          "ALTER"
        ]
      }
    ]
  },
  "permissions": [
    "READ",
    "WRITE",
    "ALTER_REFLECTION",
    "SELECT",
    "ALTER",
    "VIEW_REFLECTION",
    "MODIFY",
    "MANAGE_GRANTS",
    "CREATE_TABLE",
    "DROP",
    "EXTERNAL_QUERY",
    "INSERT",
    "TRUNCATE",
    "DELETE",
    "UPDATE",
    "EXECUTE",
    "CREATE_SOURCE",
    "ALL"
  ],
  "owner": {
    "ownerId": "30fca499-4abc-4469-7142-fc8dd29acac8",
    "ownerType": "USER"
  },
  "fields": [
    {
      "name": "pickup_datetime",
      "type": {
        "name": "TIMESTAMP"
      }
    },
    {
      "name": "passenger_count",
      "type": {
        "name": "BIGINT"
      }
    },
    {
      "name": "passenger_payment_method",
      "type": {
        "name": "STRUCT",
        "subSchema": [
          {
            "name": "cash",
            "type": {
              "name": "BOOLEAN"
            }
          },
          {
            "name": "credit-debit",
            "type": {
              "name": "BOOLEAN"
            }
          },
          {
            "name": "payment-app",
            "type": {
              "name": "BOOLEAN"
            }
          },
          {
            "name": "other",
            "type": {
              "name": "BOOLEAN"
            }
          }
        ]
      }
    },
    {
      "name": "trip_distance_mi",
      "type": {
        "name": "DOUBLE"
      }
    },
    {
      "name": "fare_amount",
      "type": {
        "name": "DOUBLE"
      }
    },
    {
      "name": "tip_amount",
      "type": {
        "name": "DOUBLE"
      }
    },
    {
      "name": "total_amount",
      "type": {
        "name": "DOUBLE"
      }
    }
  ]
}

View Attributes

entityType String

Type of the catalog object. For views, the entityType is dataset.

id String (UUID)

UUID of the view.

type String

Type of dataset. For views, the type is VIRTUAL_DATASET.

path Array of String

Path of the view within Dremio, expressed as an array. The path consists of the source, followed by any folders and subfolders, and the view itself as the last item in the array.

Example:

[
  "Business",
  "Transportation",
  "NYC-taxi-trips-short-distance"
]

createdAt String

Timestamp when the view was created.

isMetadataExpired Boolean

If true, the metadata of the tables that the view is defined on needs to be refreshed. To refresh it, run the ALTER VIEW command using the REFRESH METADATA clause.
If false, the metadata can still be used for planning queries against the view.
If NULL, metadata has never been collected for the tables that the view is defined on.

lastMetadataRefreshAt String

Timestamp when the metadata of the tables that the view is defined on was last refreshed.

tag String (UUID)

UUID of the version of the view. Dremio changes the tag whenever the view changes and uses the tag to ensure that PUT requests apply to the most recent version of the view.

sql String

SQL query used to create the view.

Example: SELECT * FROM "NYC-taxi-trips" WHERE trip_distance_mi <= 2.0 ORDER BY trip_distance_mi ASC

sqlContext Array of String

Context for the SQL query used to create the view.

Example:

[
  "Samples",
  "samples.dremio.com"
]

accessControlList Object

Information about users and roles with access to the view and the specific privileges each user or role has. May include an array of users, an array of roles, or both, depending on the configured access and privileges. The accessControlList array is empty if view-specific access control privileges are not set.

Example:

{
  "users": [
    {
      "id": "c590ed7f-b2b4-4e1f-ba7d-94173afdc9a3",
      "permissions": [
        "SELECT",
        "ALTER"
      ]
    },
    {
      "id": "30fca499-4abc-4469-7142-fc8dd29acac8",
      "permissions": [
        "SELECT",
        "ALTER",
        "MANAGE_GRANTS"
      ]
    }
  ],
  "roles": [
    {
      "id": "76a9884b-aea5-46d5-a73a-000edf23f390",
      "permissions": [
        "SELECT",
        "ALTER"
      ]
    }
  ]
}

permissions Array of String

List of the privileges that you have on the view. Only appears in the response if the request URL includes the permissions query parameter. For more information, see Privileges.

Example:

[
  "READ",
  "WRITE",
  "ALTER_REFLECTION",
  "SELECT",
  "ALTER",
  "VIEW_REFLECTION",
  "MODIFY",
  "MANAGE_GRANTS",
  "CREATE_TABLE",
  "DROP",
  "EXTERNAL_QUERY",
  "INSERT",
  "TRUNCATE",
  "DELETE",
  "UPDATE",
  "EXECUTE",
  "CREATE_SOURCE",
  "ALL"
]

owner Object

Information about the view's owner.

Example:

{
  "ownerId": "30fca499-4abc-4469-7142-fc8dd29acac8",
  "ownerType": "USER"
}

fields Array of Object

Attributes that represent the dataset schema.

Attributes of the `accessControlList` Object

users Array of Object

List of users with access to the view and the specific privileges each user has.

Example:

[
  {
    "id": "c590ed7f-b2b4-4e1f-ba7d-94173afdc9a3",
    "permissions": [
      "SELECT",
      "ALTER"
    ]
  },
  {
    "id": "30fca499-4abc-4469-7142-fc8dd29acac8",
    "permissions": [
      "SELECT",
      "ALTER",
      "MANAGE_GRANTS"
    ]
  }
]

roles Array of Object

List of roles whose members have access to the view and the specific privileges each role has.

Example:

[
  {
    "id": "76a9884b-aea5-46d5-a73a-000edf23f390",
    "permissions": [
      "SELECT",
      "ALTER"
    ]
  }
]

Attributes of Objects in the `users` and `roles` Arrays

id String (UUID)

UUID of the user or role.

permissions Array of String

List of privileges the user or role has on the view. For more information, see Privileges.

Example:

[
  "SELECT",
  "ALTER"
]

Attributes of the `owner` Object

ownerId String (UUID)

UUID of the owner.

ownerType String

Type of owner of the view. Must be USER or ROLE.

Attributes of Objects in the `fields` Array

name String

Name of the view field.

Example: pickup_datetime

type Object

Information about the view field type.

Attributes of the `type` Object

name String

Name of the view field's type.

Valid Values: STRUCT, LIST, UNION, INTEGER, BIGINT, FLOAT, DOUBLE, VARCHAR, VARBINARY, BOOLEAN, DECIMAL, TIME, DATE, TIMESTAMP, INTERVAL DAY TO SECOND, INTERVAL YEAR TO MONTH

precision Integer

Total number of digits in the number. Included only for the DECIMAL type.

scale Integer

Number of digits to the right of the decimal point. Included only for the DECIMAL type.

subSchema Array of Object

List of objects that represent the field's composition. For example, a field composed of data about a restaurant might have a subSchema with an object for parking options, another for payment methods, and so on. subSchemas may be nested within other subSchemas. subSchema is listed only for the STRUCT, LIST, and UNION types.

Attributes of Objects in the `subSchema` Array

name String

Name for the subSchema object.

Example: cash

type Object

Object that contains a name attribute that provides the field's type.

Example:

{
  "name": "BOOLEAN"
}

Create a View

Method and URL

POST /v0/projects/{project_id}/catalog

Parameters

project_id < Path String (UUID)

entityType Body String

Type of the catalog object. For views, the entityType is dataset.

type Body String

Type of dataset. For views, the type is VIRTUAL_DATASET.

path Body Array of String

Path of the location where you want to save the view within Dremio, expressed as an array. The path consists of the space, followed by any folders and subfolders, followed by a name for the view itself as the last item in the array. The name of the view cannot include the following special characters: /, :, [, or ]. Views can only be created in spaces.

Example:

[
  "Business",
  "Transportation",
  "NYC-taxi-trips-short-distance"
]

sql Body String

SQL query to use to create the view.

Example: SELECT * FROM "NYC-taxi-trips" WHERE trip_distance_mi <= 2.0 ORDER BY trip_distance_mi ASC

sqlContext Body Array of String

Context for the SQL query to use to create the view.

Example:

[
  "Samples",
  "samples.dremio.com"
]

accessControlList Body Object Optional

Object used to specify which users and roles should have access to the view and the specific privileges each user or role should have. May include an array of users, an array of roles, or both.

Example:

{
  "users": [
    {
      "id": "c590ed7f-b2b4-4e1f-ba7d-94173afdc9a3",
      "permissions": [
        "SELECT",
        "ALTER"
      ]
    },
    {
      "id": "30fca499-4abc-4469-7142-fc8dd29acac8",
      "permissions": [
        "SELECT",
        "ALTER",
        "MANAGE_GRANTS"
      ]
    }
  ],
  "roles": [
    {
      "id": "76a9884b-aea5-46d5-a73a-000edf23f390",
      "permissions": [
        "SELECT",
        "ALTER"
      ]
    }
  ]
}

Parameters of the `accessControlList` Object

users Body Array of Object Optional

List of users who should have access to the view and the specific privileges each user should have.

Example:

[
  {
    "id": "c590ed7f-b2b4-4e1f-ba7d-94173afdc9a3",
    "permissions": [
      "SELECT",
      "ALTER"
    ]
  },
  {
    "id": "30fca499-4abc-4469-7142-fc8dd29acac8",
    "permissions": [
      "SELECT",
      "ALTER",
      "MANAGE_GRANTS"
    ]
  }
]

roles Body Array of Object Optional

List of roles whose members should have access to the view and the specific privileges each role should have.

Example:

[
  {
    "id": "76a9884b-aea5-46d5-a73a-000edf23f390",
    "permissions": [
      "SELECT",
      "ALTER"
    ]
  }
]

Parameters of Objects in the `users` and `roles` Arrays

id Body String (UUID) Optional

UUID of the user or role.

permissions Body Array of String Optional

List of privileges the user or role should have on the view. For more information, see Privileges.

Example:

[
  "SELECT",
  "ALTER"
]

Example

Request

curl -X POST "https://api.dremio.cloud/v0/projects/$PROJECT_ID/catalog" \
-H "Authorization: Bearer $DREMIO_TOKEN" \
-H 'Content-Type: application/json' \
--data-raw '{
  "entityType": "dataset",
  "path": [
    "Business",
    "Transportation",
    "NYC-taxi-trips-short-distance"
  ],
  "type": "VIRTUAL_DATASET",
  "sql": "SELECT * FROM \"NYC-taxi-trips\" WHERE trip_distance_mi <= 2.0 ORDER BY trip_distance_mi ASC",
  "sqlContext": [
    "Samples",
    "samples.dremio.com"
  ],
  "accessControlList": {
    "users": [
      {
        "id": "c590ed7f-b2b4-4e1f-ba7d-94173afdc9a3",
        "permissions": [
          "SELECT",
          "ALTER"
        ]
      },
      {
        "id": "30fca499-4abc-4469-7142-fc8dd29acac8",
        "permissions": [
          "SELECT",
          "ALTER",
          "MANAGE_GRANTS"
        ]
      }
    ],
    "roles": [
      {
        "id": "76a9884b-aea5-46d5-a73a-000edf23f390",
        "permissions": [
          "SELECT",
          "ALTER"
        ]
      }
    ]
  }
}'

Response

{
  "entityType": "dataset",
  "id": "ef99ab32-89ca-4d1c-9e91-2c8be861bb8a",
  "type": "VIRTUAL_DATASET",
  "path": [
    "Business",
    "Transportation",
    "NYC-taxi-trips-short-distance"
  ],
  "createdAt": "2022-11-17T18:31:23.236Z",
  "isMetadataExpired": false, 
  "lastMetadataRefreshAt": "2024-01-31T09:50:01.012Z",
  "tag": "f90d1526-e64b-47b1-9ab0-d25df5247cab",
  "sql": "SELECT * FROM \"NYC-taxi-trips\" WHERE trip_distance_mi <= 2.0 ORDER BY trip_distance_mi ASC",
  "sqlContext": [
    "Samples",
    "samples.dremio.com"
  ],
  "accessControlList": {
    "users": [
      {
        "id": "c590ed7f-b2b4-4e1f-ba7d-94173afdc9a3",
        "permissions": [
          "SELECT",
          "ALTER"
        ]
      },
      {
        "id": "30fca499-4abc-4469-7142-fc8dd29acac8",
        "permissions": [
          "SELECT",
          "ALTER",
          "MANAGE_GRANTS"
        ]
      }
    ],
    "roles": [
      {
        "id": "76a9884b-aea5-46d5-a73a-000edf23f390",
        "permissions": [
          "SELECT",
          "ALTER"
        ]
      }
    ]
  },
  "owner": {
    "ownerId": "30fca499-4abc-4469-7142-fc8dd29acac8",
    "ownerType": "USER"
  },
  "fields": [
    {
      "name": "pickup_datetime",
      "type": {
        "name": "TIMESTAMP"
      }
    },
    {
      "name": "passenger_count",
      "type": {
        "name": "BIGINT"
      }
    },
    {
      "name": "passenger_payment_method",
      "type": {
        "name": "STRUCT",
        "subSchema": [
          {
            "name": "cash",
            "type": {
              "name": "BOOLEAN"
            }
          },
          {
            "name": "credit-debit",
            "type": {
              "name": "BOOLEAN"
            }
          },
          {
            "name": "payment-app",
            "type": {
              "name": "BOOLEAN"
            }
          },
          {
            "name": "other",
            "type": {
              "name": "BOOLEAN"
            }
          }
        ]
      }
    },
    {
      "name": "trip_distance_mi",
      "type": {
        "name": "DOUBLE"
      }
    },
    {
      "name": "fare_amount",
      "type": {
        "name": "DOUBLE"
      }
    },
    {
      "name": "tip_amount",
      "type": {
        "name": "DOUBLE"
      }
    },
    {
      "name": "total_amount",
      "type": {
        "name": "DOUBLE"
      }
    }
  ]
}

Response Status Codes

200   OK

400   Bad Request

401   Unauthorized

403   Forbidden

404   Not Found

500   Internal Server Error

Retrieve a View by ID

Method and URL

GET /v0/projects/{project_id}/catalog/{id}

Parameters

project_id Path String (UUID)

id Path String (UUID)

UUID of the view.

include Query String Optional

Include a non-default attribute in the response. The available value for the include query parameter is permissions. For more information, see the include query parameter.

Example: ?include=permissions

Example

Request

curl -X GET "https://api.dremio.cloud/v0/projects/$PROJECT_ID/catalog/$VIEW_ID" \
-H "Authorization: Bearer $DREMIO_TOKEN" \
-H 'Content-Type: application/json'

Response

{
  "entityType": "dataset",
  "id": "ef99ab32-89ca-4d1c-9e91-2c8be861bb8a",
  "type": "VIRTUAL_DATASET",
  "path": [
    "Business",
    "Transportation",
    "NYC-taxi-trips-short-distance"
  ],
  "createdAt": "2022-11-17T18:31:23.236Z",
  "isMetadataExpired": false, 
  "lastMetadataRefreshAt": "2024-01-31T09:50:01.012Z",
  "tag": "f90d1526-e64b-47b1-9ab0-d25df5247cab",
  "sql": "SELECT * FROM \"NYC-taxi-trips\" WHERE trip_distance_mi <= 2.0 ORDER BY trip_distance_mi ASC",
  "sqlContext": [
    "Samples",
    "samples.dremio.com"
  ],
  "accessControlList": {
    "users": [
      {
        "id": "c590ed7f-b2b4-4e1f-ba7d-94173afdc9a3",
        "permissions": [
          "SELECT",
          "ALTER"
        ]
      },
      {
        "id": "30fca499-4abc-4469-7142-fc8dd29acac8",
        "permissions": [
          "SELECT",
          "ALTER",
          "MANAGE_GRANTS"
        ]
      }
    ],
    "roles": [
      {
        "id": "76a9884b-aea5-46d5-a73a-000edf23f390",
        "permissions": [
          "SELECT",
          "ALTER"
        ]
      }
    ]
  },
  "owner": {
    "ownerId": "30fca499-4abc-4469-7142-fc8dd29acac8",
    "ownerType": "USER"
  },
  "fields": [
    {
      "name": "pickup_datetime",
      "type": {
        "name": "TIMESTAMP"
      }
    },
    {
      "name": "passenger_count",
      "type": {
        "name": "BIGINT"
      }
    },
    {
      "name": "passenger_payment_method",
      "type": {
        "name": "STRUCT",
        "subSchema": [
          {
            "name": "cash",
            "type": {
              "name": "BOOLEAN"
            }
          },
          {
            "name": "credit-debit",
            "type": {
              "name": "BOOLEAN"
            }
          },
          {
            "name": "payment-app",
            "type": {
              "name": "BOOLEAN"
            }
          },
          {
            "name": "other",
            "type": {
              "name": "BOOLEAN"
            }
          }
        ]
      }
    },
    {
      "name": "trip_distance_mi",
      "type": {
        "name": "DOUBLE"
      }
    },
    {
      "name": "fare_amount",
      "type": {
        "name": "DOUBLE"
      }
    },
    {
      "name": "tip_amount",
      "type": {
        "name": "DOUBLE"
      }
    },
    {
      "name": "total_amount",
      "type": {
        "name": "DOUBLE"
      }
    }
  ]
}

Response Status Codes

200   OK

400   Bad Request

401   Unauthorized

403   Forbidden

404   Not Found

Retrieve a View by Path

Method and URL

GET /v0/projects/{project_id}/catalog/by-path/{path}

Parameters

project_id Path String (UUID)

path Path String

View's location within Dremio, using forward slashes as separators. For example, for the "NYC-taxi-trips" view in the "samples.dremio.com" folder within the space "Transportation," the path is Transportation/samples.dremio.com/NYC-taxi-trips. If the name of any component in the path includes special characters for URLs, such as spaces, use URL encoding to replace the special characters with their UTF-8-equivalent characters. For example, "Dremio University" should be Dremio%20University in the URL path.

Example: Business/Transportation/NYC-taxi-trips-short-distance

include Query String Optional

Include a non-default attribute in the response. The available value for the include query parameter is permissions. For more information, see the include query parameter.

Example: ?include=permissions

Example

Request

curl -X GET "https://api.dremio.cloud/v0/projects/$PROJECT_ID/catalog/by-path/Business/Transportation/NYC-taxi-trips-short-distance" \
-H "Authorization: Bearer $DREMIO_TOKEN" \
-H 'Content-Type: application/json'

Response

{
  "entityType": "dataset",
  "id": "ef99ab32-89ca-4d1c-9e91-2c8be861bb8a",
  "type": "VIRTUAL_DATASET",
  "path": [
    "Business",
    "Transportation",
    "NYC-taxi-trips-short-distance"
  ],
  "createdAt": "2022-11-17T18:31:23.236Z",
  "isMetadataExpired": false, 
  "lastMetadataRefreshAt": "2024-01-31T09:50:01.012Z",
  "tag": "f90d1526-e64b-47b1-9ab0-d25df5247cab",
  "sql": "SELECT * FROM \"NYC-taxi-trips\" WHERE trip_distance_mi <= 2.0 ORDER BY trip_distance_mi ASC",
  "sqlContext": [
    "Samples",
    "samples.dremio.com"
  ],
  "accessControlList": {
    "users": [
      {
        "id": "c590ed7f-b2b4-4e1f-ba7d-94173afdc9a3",
        "permissions": [
          "SELECT",
          "ALTER"
        ]
      },
      {
        "id": "30fca499-4abc-4469-7142-fc8dd29acac8",
        "permissions": [
          "SELECT",
          "ALTER",
          "MANAGE_GRANTS"
        ]
      }
    ],
    "roles": [
      {
        "id": "76a9884b-aea5-46d5-a73a-000edf23f390",
        "permissions": [
          "SELECT",
          "ALTER"
        ]
      }
    ]
  },
  "owner": {
    "ownerId": "30fca499-4abc-4469-7142-fc8dd29acac8",
    "ownerType": "USER"
  },
  "fields": [
    {
      "name": "pickup_datetime",
      "type": {
        "name": "TIMESTAMP"
      }
    },
    {
      "name": "passenger_count",
      "type": {
        "name": "BIGINT"
      }
    },
    {
      "name": "passenger_payment_method",
      "type": {
        "name": "STRUCT",
        "subSchema": [
          {
            "name": "cash",
            "type": {
              "name": "BOOLEAN"
            }
          },
          {
            "name": "credit-debit",
            "type": {
              "name": "BOOLEAN"
            }
          },
          {
            "name": "payment-app",
            "type": {
              "name": "BOOLEAN"
            }
          },
          {
            "name": "other",
            "type": {
              "name": "BOOLEAN"
            }
          }
        ]
      }
    },
    {
      "name": "trip_distance_mi",
      "type": {
        "name": "DOUBLE"
      }
    },
    {
      "name": "fare_amount",
      "type": {
        "name": "DOUBLE"
      }
    },
    {
      "name": "tip_amount",
      "type": {
        "name": "DOUBLE"
      }
    },
    {
      "name": "total_amount",
      "type": {
        "name": "DOUBLE"
      }
    }
  ]
}

Response Status Codes

200   OK

400   Bad Request

401   Unauthorized

403   Forbidden

404   Not Found

Update a View

Method and URL

PUT /v0/projects/{project_id}/catalog/{id}

Parameters

project_id Path String (UUID)

id Path String (UUID)

UUID of the view.

entityType Body String

Type of the catalog object. For views, the entityType is dataset.

type Body String

Type of dataset. For views, the type is VIRTUAL_DATASET.

path Body Array of String

Path of the location where you want to save the updated view within Dremio, expressed as an array. The path consists of the space, followed by any folders and subfolders, followed by the name for the view itself as the last item in the array. Views can only be saved in spaces.

Example:

[
  "Business",
  "Transportation",
  "NYC-taxi-trips-short-distance"
]

tag Body String (UUID) Optional

UUID of the version of the view. If you provide a tag in the request body, Dremio uses the tag to ensure that you are requesting to update the most recent version of the view. If you do not provide a tag, Dremio automatically updates the most recent version of the view.

sql Body String

SQL query to use to update the view.

Example: SELECT * FROM "NYC-taxi-trips" WHERE trip_distance_mi <= 2.0 ORDER BY trip_distance_mi DESC

sqlContext Body Array of String

Context for the SQL query to use for the updated view.

Example:

[
  "Samples",
  "samples.dremio.com"
]

accessControlList Body Object Optional

Object used to specify which users and roles should have access to the view and the specific privileges each user or role should have. May include an array of users, an array of roles, or both.

Parameters of the `accessControlList` Object

users Body Array of Object Optional

List of users who should have access to the view and the specific privileges each user should have.

Example:

[
  {
    "id": "c590ed7f-b2b4-4e1f-ba7d-94173afdc9a3",
    "permissions": [
      "SELECT",
      "ALTER"
    ]
  },
  {
    "id": "30fca499-4abc-4469-7142-fc8dd29acac8",
    "permissions": [
      "SELECT",
      "ALTER",
      "MANAGE_GRANTS"
    ]
  }
]

roles Body Array of Object Optional

List of roles whose members should have access to the view and the specific privileges each role should have.

Example:

[
  {
    "id": "76a9884b-aea5-46d5-a73a-000edf23f390",
    "permissions": [
      "SELECT",
      "ALTER"
    ]
  }
]

Parameters of Objects in the `users` and `roles` Arrays

id Body String (UUID) Optional

UUID of the user or role who should have access to the view.

permissions Body Array of String Optional

List of privileges the user or role should have on the view. For more information, see Privileges.

Example:

[
  "SELECT",
  "ALTER"
]

Example

Request

curl -X PUT "https://api.dremio.cloud/v0/projects/$PROJECT_ID/catalog/$VIEW_ID" \
-H "Authorization: Bearer $DREMIO_TOKEN" \
-H 'Content-Type: application/json' \
--data-raw '{
  "entityType": "dataset",
  "id": "ef99ab32-89ca-4d1c-9e91-2c8be861bb8a",
  "path": [
    "Business",
    "Transportation",
    "NYC-taxi-trips-short-distance"
  ],
  "type": "VIRTUAL_DATASET",
  "tag": "f90d1526-e64b-47b1-9ab0-d25df5247cab",
  "sql": "SELECT trip_distance_mi, fare_amount, tip_amount FROM \"NYC-taxi-trips\" WHERE trip_distance_mi <= 2.0 ORDER BY trip_distance_mi DESC",
  "sqlContext": [
    "Samples",
    "samples.dremio.com"
  ]
}'

Response

{
  "entityType": "dataset",
  "id": "ef99ab32-89ca-4d1c-9e91-2c8be861bb8a",
  "type": "VIRTUAL_DATASET",
  "path": [
    "Business",
    "Transportation",
    "NYC-taxi-trips-by-distance"
  ],
  "createdAt": "2023-01-20T15:26:39.780Z",
  "isMetadataExpired": false, 
  "lastMetadataRefreshAt": "2024-01-31T09:50:01.012Z",
  "tag": "7cab1a42-8835-4d31-827b-fedee1ad38d1",
  "sql": "SELECT trip_distance_mi, fare_amount, tip_amount FROM \"NYC-taxi-trips\" WHERE trip_distance_mi <= 2.0 ORDER BY trip_distance_mi DESC",
  "sqlContext": [
    "Samples",
    "samples.dremio.com"
  ],
  "accessControlList": {
    "users": [
      {
        "id": "c590ed7f-b2b4-4e1f-ba7d-94173afdc9a3",
        "permissions": [
          "SELECT",
          "ALTER"
        ]
      },
      {
        "id": "30fca499-4abc-4469-7142-fc8dd29acac8",
        "permissions": [
          "SELECT",
          "ALTER",
          "MANAGE_GRANTS"
        ]
      }
    ],
    "roles": [
      {
        "id": "76a9884b-aea5-46d5-a73a-000edf23f390",
        "permissions": [
          "SELECT",
          "ALTER"
        ]
      }
    ]
  },
  "owner": {
    "ownerId": "30fca499-4abc-4469-7142-fc8dd29acac8",
    "ownerType": "USER"
  },
  "fields": [
    {
      "name": "pickup_datetime",
      "type": {
        "name": "TIMESTAMP"
      }
    },
    {
      "name": "passenger_count",
      "type": {
        "name": "BIGINT"
      }
    },
    {
      "name": "passenger_payment_method",
      "type": {
        "name": "STRUCT",
        "subSchema": [
          {
            "name": "cash",
            "type": {
              "name": "BOOLEAN"
            }
          },
          {
            "name": "credit-debit",
            "type": {
              "name": "BOOLEAN"
            }
          },
          {
            "name": "payment-app",
            "type": {
              "name": "BOOLEAN"
            }
          },
          {
            "name": "other",
            "type": {
              "name": "BOOLEAN"
            }
          }
        ]
      }
    },
    {
      "name": "trip_distance_mi",
      "type": {
        "name": "DOUBLE"
      }
    },
    {
      "name": "fare_amount",
      "type": {
        "name": "DOUBLE"
      }
    },
    {
      "name": "tip_amount",
      "type": {
        "name": "DOUBLE"
      }
    },
    {
      "name": "total_amount",
      "type": {
        "name": "DOUBLE"
      }
    }
  ]
}

Response Status Codes

200   OK

400   Bad Request

401   Unauthorized

403   Forbidden

404   Not Found

500   Internal Server Error

Refresh the Reflections on a View

See Refreshing Reflections to learn how refreshing works.

Method and URL

POST /v0/projects/{project_id}/catalog/{id}/refresh

Parameters

project_id Path String (UUID)

id Path String (UUID)

UUID for the view.

Example

Request

curl -X POST 'https://api.dremio.cloud/v0/projects/$PROJECT_ID/catalog/$VIEW_ID/refresh   
-H 'Authorization: Bearer <access_token>' \
-H 'Content-Type: application/json' 

A successful request returns an empty response body with HTTP status 204 No Content.

Response Status Codes

204   No Content

400   Bad Request

401   Unauthorized

403   Forbidden

404   Not Found

Delete a View

Method and URL

DELETE /v0/projects/{project_id}/catalog/{id}

Parameters

project_id Path String (UUID)

id Path String (UUID)

UUID of the view.

Example

Request

curl -X DELETE "https://api.dremio.cloud/v0/projects/$PROJECT_ID/catalog/$VIEW_ID" \
-H "Authorization: Bearer $DREMIO_TOKEN" \
-H 'Content-Type: application/json' 

A successful request returns an empty response body with HTTP status 204 No Content.

Response Status Codes

204   No Content

400   Bad Request

401   Unauthorized

403   Forbidden

404   Not Found

View Attributes​

Attributes of the accessControlList Object​

Attributes of Objects in the users and roles Arrays​

Attributes of the owner Object​

Attributes of Objects in the fields Array​

Attributes of the type Object​

Attributes of Objects in the subSchema Array​

Create a View​

Parameters​

Parameters of the accessControlList Object​

Parameters of Objects in the users and roles Arrays​

Example​

Response Status Codes​

Retrieve a View by ID​

Parameters​

Example​

Response Status Codes​

Retrieve a View by Path​

Parameters​

Example​

Response Status Codes​

Update a View​

Parameters​

Parameters of the accessControlList Object​

Parameters of Objects in the users and roles Arrays​

Example​

Response Status Codes​

Refresh the Reflections on a View​

Parameters​

Example​

Response Status Codes​

Delete a View​

Parameters​

Example​

Response Status Codes​

View Attributes

Attributes of the `accessControlList` Object

Attributes of Objects in the `users` and `roles` Arrays

Attributes of the `owner` Object

Attributes of Objects in the `fields` Array

Attributes of the `type` Object

Attributes of Objects in the `subSchema` Array

Create a View

Parameters

Parameters of the `accessControlList` Object

Parameters of Objects in the `users` and `roles` Arrays

Example

Response Status Codes

Retrieve a View by ID

Parameters

Example

Response Status Codes

Retrieve a View by Path

Parameters

Example

Response Status Codes

Update a View

Parameters

Parameters of the `accessControlList` Object

Parameters of Objects in the `users` and `roles` Arrays

Example

Response Status Codes

Refresh the Reflections on a View

Parameters

Example

Response Status Codes

Delete a View

Parameters

Example

Response Status Codes