# mars_rover_photos: NASA Mars Rover Photos ## Documentation Return photos made by the the curiosity rover at the specified amount of sol(length of a day on mars) - Catalog: `NASA` - Schema: `NASA` - Primary Keys: `id` - Label: Mars Rover Photos - Select NASA API URL: `mars-photos/api/v1/rovers/curiosity/photos?sol={sol}` - Insert NASA API URL: `mars-photos/api/v1/rovers/curiosity/photos?sol={sol}` - Update NASA API URL: `mars-photos/api/v1/rovers/curiosity/photos?sol={sol}` - Delete NASA API URL: `mars-photos/api/v1/rovers/curiosity/photos?sol={sol}` - Field Selection Method: NotRequired - Base Path: `photos[*]` This is a read-only table function. The NASA API may not support changing the data or the Invantive SQL driver for NASA does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the NASA API. ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `sol` | `int64` | ☑ | | | ## Columns of Table Function The columns of the table function `mars_rover_photos` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `photos_camera_full_name` | `string` | | ☐ | | | `photos_camera_id` | `int32` | | ☐ | | | `photos_camera_name` | `string` | | ☐ | | | `photos_camera_rover_id` | `int32` | | ☐ | | | `photos_earth_date` | `datetime` | | ☐ | | | `photos_id` | `int32` | | ☐ | | | `photos_img_src` | `string` | | ☐ | | | `photos_sol` | `int32` | | ☐ | |