Redivis API
User documentationredivis.com
  • Introduction
  • Referencing resources
  • Client libraries
    • redivis-js
      • Getting started
      • Examples
    • redivis-python
      • Getting started
      • Reference
        • redivis
          • redivis.current_notebook
          • redivis.file
          • redivis.organization
          • redivis.query
          • redivis.table
          • redivis.user
        • Dataset
          • Dataset.add_labels
          • Dataset.create
          • Dataset.create_next_version
          • Dataset.delete
          • Dataset.exists
          • Dataset.get
          • Dataset.list_tables
          • Dataset.list_versions
          • Dataset.query
          • Dataset.release
          • Dataset.remove_labels
          • Dataset.table
          • Dataset.unrelease
          • Dataset.update
          • Dataset.version
        • File
          • File.download
          • File.get
          • File.read
          • File.stream
        • Member
          • Member.add_labels
          • Member.exists
          • Member.get
          • Member.remove_labels
          • Member.update
        • Notebook
          • Notebook.create_output_table
        • Organization
          • Organization.dataset
          • Organization.list_datasets
          • Organization.list_members
          • Organization.member
        • Query
          • Query.download_files
          • Query.get
          • Query.list_files
          • Query.list_rows
          • Query.to_arrow_batch_iterator
          • Query.to_arrow_dataset
          • Query.to_arrow_table
          • Query.to_dataframe
          • Query.to_geopandas_dataframe
          • Query.to_dask_dataframe
          • Query.to_pandas_dataframe
          • Query.to_polars_lazyframe
        • Table
          • Table.add_files
          • Table.create
          • Table.delete
          • Table.download
          • Table.download_files
          • Table.get
          • Table.exists
          • Table.list_files
          • Table.list_rows
          • Table.list_uploads
          • Table.list_variables
          • Table.to_arrow_batch_iterator
          • Table.to_arrow_dataset
          • Table.to_arrow_table
          • Table.to_dataframe
          • Table.to_geopandas_dataframe
          • Table.to_dask_dataframe
          • Table.to_pandas_dataframe
          • Table.to_polars_lazyframe
          • Table.update
          • Table.upload
          • Table.variable
        • Upload
          • Upload.create
          • Upload.delete
          • Upload.exists
          • Upload.get
          • Upload.insert_rows
          • Upload.list_variables
          • Upload.to_*
        • Version
          • Version.dataset
          • Version.delete
          • Version.exists
          • Version.get
          • Version.previous_version
          • Version.next_version
        • User
          • User.dataset
          • User.list_datasets
          • User.workflow
          • User.list_workflows
        • Variable
          • Variable.get
          • Variable.exists
          • Variable.update
        • Workflow
          • Workflow.get
          • Workflow.exists
          • Workflow.list_tables
          • Workflow.query
          • Workflow.table
      • Examples
        • Listing resources
        • Querying data
        • Reading tabular data
        • Uploading data
        • Working with non-tabular files
    • redivis-r
      • Getting started
      • Reference
        • redivis
          • redivis$current_notebook
          • redivis$file
          • redivis$organization
          • redivis$query
          • redivis$table
          • redivis$user
        • Dataset
          • Dataset$create
          • Dataset$create_next_version
          • Dataset$delete
          • Dataset$exists
          • Dataset$get
          • Dataset$list_tables
          • Dataset$query
          • Dataset$release
          • Dataset$table
          • Dataset$unrelease
          • Dataset$update
        • File
          • File$download
          • File$get
          • File$read
          • File$stream
        • Notebook
          • Notebook$create_output_table
        • Organization
          • Organization$dataset
          • Organization$list_datasets
        • Query
          • Query$download_files
          • Query$get
          • Query$list_files
          • Query$to_arrow_batch_reader
          • Query$to_arrow_dataset
          • Query$to_arrow_table
          • Query$to_data_frame
          • Query$to_data_table
          • Query$to_tibble
          • Query$to_sf_tibble
        • Table
          • Table$add_files
          • Table$create
          • Table$delete
          • Table$download
          • Table$download_files
          • Table$get
          • Table$exists
          • Table$list_files
          • Table$list_uploads
          • Table$list_variables
          • Table$to_arrow_batch_reader
          • Table$to_arrow_dataset
          • Table$to_arrow_table
          • Table$to_data_frame
          • Table$to_data_table
          • Table$to_tibble
          • Table$to_sf_tibble
          • Table$update
          • Table$upload
          • Table$variable
        • Upload
          • Upload$create
          • Upload$delete
          • Upload$exists
          • Upload$get
          • Upload$insert_rows
          • Upload$list_variables
          • Upload$to_*
        • User
          • User$dataset
          • User$list_datasets
          • User$workflow
          • User$list_workflows
        • Variable
          • Variable$get
          • Variable$exists
          • Variable$update
        • Workflow
          • Workflow$get
          • Workflow$exists
          • Workflow$list_tables
          • Workflow$query
          • Workflow$table
      • Examples
        • Listing resources
        • Querying data
        • Reading tabular data
        • Uploading data
        • Working with non-tabular data
  • REST API
    • General structure
    • Authorization
    • Access
      • get
      • list
    • Datasets
      • delete
      • get
      • list
      • patch
      • post
    • Exports
      • download
      • get
      • post
    • Files
      • createSignedUrl
      • get
      • head
      • post
    • Members
      • get
      • list
    • Queries
      • get
      • post
      • listRows
    • ReadSessions
      • post
      • getStream
    • Tables
      • createTempUploads
      • delete
      • get
      • list
      • listRows
      • patch
      • post
    • Uploads
      • delete
      • get
      • insertRows
      • list
      • listRows
      • post
    • Variables
      • get
      • list
      • patch
    • Versions
      • delete
      • get
      • list
      • post
      • release
      • unrelease
    • Workflows
      • get
      • list
  • Resource definitions
    • Access
    • Dataset
    • Export
    • Member
    • Organization
    • Query
    • Table
    • Upload
    • User
    • Variable
    • Version
    • Workflow
Powered by GitBook
On this page
  • Base definition
  • Get definition
  • Documentation

Was this helpful?

  1. Resource definitions

Variable

Base definition

{
	"kind": "variable",
	"uri": string,
	"url": string,
	"name": string,
	"type": string("boolean","integer","float","string","date","dateTime","geography"),
	"isFileId": bool,
	"index": integer,
	"label": string,
}

Get definition

In addition to the base definition, any variable resource returned by a get request will contain the following properties:

{
	"description": string,
	"valueLabels": [
		{ "value": string, "label": string }
	],
	"statistics": {
		"status": string("queued","running","completed","failed"),
		"count": integer,
		"numDistinct": integer,
		"min": number,
		"max": number,
		"mean": number,
		"approxMedian": number,
		"geoBBox": {
		  "westLongitude": number,
		  "eastLongitude": number,
		  "northLatitude": number,
		  "southLatitude": number
		}
	}
}

Documentation

Fields

Base

kind

string

The resource type. Will always be "variable".

uri

string

The fully qualified reference to this upload, for use in generating calls to this API.

For example, /tables/imathews.example:123.test:456/variables/var1

url

string

The variable's discoverable url through a web browser interface.

name

string

The variable's name. Will always be unique to the variable's table.

type

string

The variable's type. Will be one of:

"boolean","integer","float","string","date","dateTime"

isFileId

index

integer

A zero based counter for the variable's ordinality for its table.

label

string

A user-provided label for the variable. May be null.

Get

description

string

A user-provided description for the variable, typically longer than the label. May be null.

valueLabels

array<object>

An array of value labels. Value labels are used to provide mappings between the data content of a cell and human-readable meaning of that content.

valueLabels.value

string

The value associated with a given valueLabel

valueLabels.label

string

The human-readable label for the associated value.

statistics

object

An object containing univariate summary statistics about the variable.

If the statistics have not yet been computed on the variable, statistic.status will running and many (or all) of the statistic fields will be missing until status is completed.

statistics.status

string

The current status of the statistic's computation. Will be one of completed, running, or failed. If the statistic is failed, it can only be recomputed in the UI.

statistics.count

integer

The number of non-null values for this variable.

statistics.numDistinct

integer

The number of distinct values for this variable.

statistics.min

number

The minimum value of this variable. Will be null for variables of string and boolean type.

If the variable is of type date or dateTime, this number represents the number of milliseconds since the epoch (1970-01-01). If the variable is of type time, this number represents the number of milliseconds since 00:00:00.

statistics.max

number

The maximum value of this variable. See statistic.min for information about different variable types.

statistics.mean

number

The average value of this variable. See statistic.min for information about different variable types.

statistics.approxMedian

number

See statistic.min for information about different variable types.

statistics.stdDev

number

The sample (unbiased) standard deviation of this variable. Will be null for variables of string and boolean type. For all other variable types this will be a number.

If the variable is of type date , time, or dateTime, this number measures the standard deviation in milliseconds.

statistics.geoBBox

object An object describing the geographic bounding box of the variable. Will only be present for variables of "geography" type.

statistics.geoBBox .westLongitude .eastLongitude .northLatitude .southLatitude

number Each property represents one side of the bounding box, expressed in numeric degrees.

PreviousUserNextVersion

Last updated 10 months ago

Was this helpful?

boolean Whether the variable contains file_ids, which can be used to uniquely reference and download a .

The approximate median of this variable. Uses the

File
BigQuery APPROX_QUANTILES function.