Create a new model - Census API Reference

Product Docs

Engineering Blog

Introduction

Organization APIs

Users
Invitations
Workspaces

Workspace APIs

Syncs
Sync Management Links
Sync Runs
Destination Types
Destinations
Destination Connect Links
Source Types
Sources
- GET
  List sources
- POST
  Create a new source
- GET
  Fetch source
- PATCH
  Update source
- DEL
  Delete source
- Objects
- Models
- Topics
- Tables
- Segments
- Projects
Source Connect Links
Segment Management Links

POST

sources

{source_id}

models

curl --request POST \
  --url https://app.getcensus.com/api/v1/sources/{source_id}/models \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '{
  "name": "New App Users",
  "query": "SELECT * FROM \"users\"",
  "description": "Users that have signed up for our product in the last week."
}'

{
  "status": "created",
  "data": {
    "type": "model",
    "id": 18,
    "name": "New App Users",
    "dataset_id": 12,
    "description": "Users that have signed up for our product in the last week.",
    "query": "SELECT * FROM \"users\"",
    "created_at": "2021-10-20T02:43:07.120Z",
    "updated_at": "2021-10-20T02:50:35.477Z",
    "compiled_query": null,
    "columns": [
      {
        "name": "user_id",
        "type": "character varying (256)"
      },
      {
        "name": "full_name",
        "type": "character varying (256)"
      }
    ],
    "dataset_id=": 12,
    "source_object_id": 20
  }
}

Authorizations

Authorization

string

header

required

Bearer token for the current workspace. Can be retrieved from the Workspace's settings page.

Path Parameters

source_id

integer

required

ID of the source

Body

application/json

name

string

required

The name of this model.

Example:

"New App Users"

query

string

required

The SQL query associated with this model.

Example:

"SELECT * FROM \"users\""

description

string

The description for this model.

Example:

"Users that have signed up for our product in the last week."

Response

201 - application/json

Model created successfully

status

enum<string>

Outcome of the operation.

Available options:

success,

updated,

created,

not_found,

error

Example:

"created"

data

object

data.type

enum<string>

The type of this source object, will always be model.

Available options:

model

Example:

"model"

data.id

integer

The id of this model.

Example:

18

data.name

string

The name of this model.

Example:

"New App Users"

data.dataset_id

integer | null

The identifier for the dataset that corresponds to this model. A model will always have a corresponding dataset unless the model belongs to a dbt, looker, sigma recipe that has not been used in Census

Example:

12

data.description

string

The description for this model.

Example:

"Users that have signed up for our product in the last week."

data.query

string

The SQL query associated with this model.

Example:

"SELECT * FROM \"users\""

data.created_at

string

When this model was created.

Example:

"2021-10-20T02:43:07.120Z"

data.updated_at

string

When this model was last updated.

Example:

"2021-10-20T02:50:35.477Z"

data.compiled_query

string | null

The compiled query associated with this model if it is built atop a DBT instance.

Example:

null

data.columns

object[]

A list of columns from this model.

Example:

[
  {
    "name": "user_id",
    "type": "character varying (256)"
  },
  {
    "name": "full_name",
    "type": "character varying (256)"
  }
]

data.dataset_id=

integer | null

deprecated

[Deprecated] Identical to dataset_id but with a typo. Will be removed in a future version.

Example:

12

data.source_object_id

integer

deprecated

[Deprecated] The source object ID for this model. You can typically ignore this.

Example:

20

Was this page helpful?

Raise issue

List models Fetch model

curl --request POST \
  --url https://app.getcensus.com/api/v1/sources/{source_id}/models \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '{
  "name": "New App Users",
  "query": "SELECT * FROM \"users\"",
  "description": "Users that have signed up for our product in the last week."
}'

{
  "status": "created",
  "data": {
    "type": "model",
    "id": 18,
    "name": "New App Users",
    "dataset_id": 12,
    "description": "Users that have signed up for our product in the last week.",
    "query": "SELECT * FROM \"users\"",
    "created_at": "2021-10-20T02:43:07.120Z",
    "updated_at": "2021-10-20T02:50:35.477Z",
    "compiled_query": null,
    "columns": [
      {
        "name": "user_id",
        "type": "character varying (256)"
      },
      {
        "name": "full_name",
        "type": "character varying (256)"
      }
    ],
    "dataset_id=": 12,
    "source_object_id": 20
  }
}