api_credentials


Description

A row in this table represents an API key to access Data API endpoints.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
api_credential_id varchar 2147483647 null
api_credential_sources.api_credential_id api_credentials_sources_api_credential_id_fkeyN
api_credential_tags.api_credential_id api_credentials_tags_api_credential_id_fkeyN

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

creator_id varchar 2147483647 null
users.user_id api_credentials_creator_id_fkeyN

ID of the user that created the entity in this entity.

name varchar 2147483647 null

Name of the api credential

partner_name varchar 2147483647 null

The name of the partner that generated and is using this api credential

partner_client_id varchar 2147483647 null

The partner’s client ID associated with this api credential

logo_url varchar 2147483647 null

Link to the image used in-app for actions taken by this key

key_last_four varchar 2147483647 null

Last 4 characters of the raw api credential

last_used_at timestamp 29,6 null

Date the api credential was last used.

created_at timestamp 29,6 null

Date the object referred to in this entity was created.

is_deleted bool 1 false

TRUE if the source of data for the current entity has been deleted.

row_updated_at timestamp 29,6 CURRENT_TIMESTAMP

Date this entity was updated in the database. Useful to setup incremental refreshes of the data in your periodic ETL job.

Indexes

Constraint Name Type Sort Column(s)
api_credentials_pkey Primary key Asc api_credential_id
api_credentials_account_id_index Performance Asc account_id
api_credentials_creator_id_idx Performance Asc creator_id

Relationships