How AI is applied across API Evangelist and APIs.io. Read my AI disclosure →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

Select Star columns API

The columns API from Select Star — 3 operation(s) for columns.

Select Star columns API is one of 26 APIs that Select Star publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

Tagged areas include Columns. The published artifact set on APIs.io includes an OpenAPI specification, authentication docs, API documentation, an API reference, and a getting-started guide.

This API exposes 4 operations across 3 paths, and defines 54 schemas. It is described by OpenAPI 3.0.3, at version 1.0.0.

Requests are made against the base URL https://api.production.selectstar.com.

4 operations 3 paths 54 schemas 3 GET1 PATCH

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.0.3
API Version
1.0.0
Base URL
https://api.production.selectstar.com
Authentication
HTTP Bearer, API Key
License
All Rights Reserved
Terms of Service
Resource Areas
1

Authentication & Security 2

Select Star columns API declares 2 security schemes for authenticating requests. It accepts HTTP bearer tokens (JWT) (JWTAuthentication). An API key is passed in the header as Authorization (tokenAuth).

  • tokenAuth — Token-based authentication with required prefix "Token"

Paths & Operations 4

Across 3 paths, the API surfaces 4 operations — 3 GET, 1 PATCH. Each is listed below with its method, path, parameters, and response codes.

columns 4
GET
/v1/columns/
get a list of columns Required Role: Viewer or higher
columns_list 29 params → 200
GET
/v1/columns/{guid}/
get a single column Required Role: Viewer or higher
columns_retrieve 1 param → 200
PATCH
/v1/columns/{guid}/
Update the isprimary key value in columns Required Role: Data Manager or higher
columns_partial_update 1 param body → 200
GET
/v1/columns/export/
Returns a CSV with data to export. Required Role: Viewer or higher
columns_export_retrieve → 200

Schemas 54

The contract defines 54 schemas that model the data the API accepts and returns. The most detailed are RelatedObjectsCounts (39 properties), Column (38 properties), Database (15 properties), User (14 properties). Each schema is shown below with its type and property counts.

DatabaseSerializer.GuidReferenceField.technical_owner
TypeB32Enum
string
status - status dbt - dbt
TableLite
object
5 properties 3 required
DatabaseSerializer.GuidReferenceField.business_owner
TableInfoRequest
object
5 properties 2 required
DatabaseRequest
object
Adds support for reading a description from metadata that support modifying description
4 properties 1 required
BaseMetadata
object
4 properties 4 required
BaseColumn
object
Adds support for reading a description from metadata that support modifying description
3 properties 2 required
PaginatedColumnList
object
4 properties 2 required
DescriptionSourceEnum
string
user - User ingestion - Ingestion ai - Ai publicdocs - Public Docs lineage - Lineage downstreamlineage - Downstream Lineage upstreamlineage - Upstream Lineage…
Breadcrumb
object
8 properties 5 required
SuggestedDescriptionSourceEnum
string
publicdocs - Public Docs lineage - Lineage downstreamlineage - Downstream Lineage upstreamlineage - Upstream Lineage similarity - Similarity unknown - Unknown
TaggedItemsLite
object
Serializer without suggestion source
5 properties 5 required
UserSetting
object
10 properties
ListSerializer.GuidReferenceField.Request
string
GUID
TargetDataSourceTypeEnum
string
airflow - Airflow awss3 - AWS S3 bigquery - BigQuery datastudio - Looker Studio databricks - Databricks dbagent - DB Agent db2 - DB2 dbt - dbt fivetran - Fivet…
TaggedItemsLiteWithSourceSerializer.GuidReferenceField.suggestion_source_object
DataSourceInfoRequest
object
4 properties 2 required
SchemaPopularity
object
5 properties 5 required
DatabasePopularity
object
5 properties 5 required
SchemaSerializer.GuidReferenceField.business_owner
DefaultTableDashboardTabEnum
string
overview - overview columnscharts - columnscharts
UserLite
object
7 properties 7 required
TableTypeEnum
string
table - table view - view materializedview - materializedview externaltable - externaltable dynamictable - dynamictable incremental - dbtincremental ephemeral…
CollectionLite
object
8 properties 8 required
ColumnPopularity
object
5 properties 5 required
DSUserName
object
4 properties 2 required
ForeignKey
object
5 properties 4 required
TagSetRequest
object
This serializer represents a list of tag guids to be applied to a given item
2 properties 1 required
PatchedColumnRequest
object
Adds support for reading a description from metadata that support modifying description
5 properties
SchemaRequest
object
Adds support for reading a description from metadata that support modifying description
5 properties 2 required
SchemaSerializer.GuidReferenceField.technical_owner
TaggedItemsLiteSerializer.GuidReferenceField.item
PiiRule
object
7 properties 5 required
Type6b6Enum
string
airflow - Airflow awss3 - AWS S3 bigquery - BigQuery datastudio - Looker Studio databricks - Databricks dbagent - DB Agent db2 - DB2 dbt - dbt fivetran - Fivet…
TagLite
object
8 properties 6 required
DataSourceInfo
object
4 properties 2 required
BaseType
object
Base Serializer to inject the following type information: - Object Type: Model Name of the Object: Table, Dashboard, ReportQuery - Data Source Type: snowflake,…
4 properties 4 required
User
object
14 properties 13 required
QueryLite
object
6 properties 3 required
ColumnSerializer.GuidReferenceField.suggested_description_source_object
DefaultDatabaseTableColumnOrderEnum
string
popularity - popularity columnordinalposition - columnordinalposition alphabetical - alphabetical
Column
object
Adds support for reading a description from metadata that support modifying description
38 properties 36 required
TeamShortcut
object
2 properties 2 required
RelatedObjectsCounts
object
39 properties
TableInfo
object
7 properties 4 required
Schema
object
Adds support for reading a description from metadata that support modifying description
14 properties 11 required
TaggedItemsLiteWithSource
object
6 properties 5 required
Database
object
Adds support for reading a description from metadata that support modifying description
15 properties 12 required
SuggestedDescriptionSourceObject
object
6 properties 5 required
TaggedItemsSourceSerializer.GuidReferenceField.item
Team
object
5 properties 3 required
PIIType
string
address - address banking - banking birthdate - birthdate document - document email - email facephoto - facephoto gender - gender maritalstatus - maritalstatus…
TaggedItemsSource
object
1 property 1 required

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

select-star-columns-api-openapi.yml Raw ↑

Other APIs Select Star publishes across the network.

Select Star bi API
Select Star collections API
Select Star comments API
Select Star custom-attribute-values API
Select Star custom-attributes API
Select Star custom-attributes-with-value API
Select Star data-metrics API
Select Star data-sources API
Select Star databases API
Select Star dbt API
Select Star documents API
Select Star ingestion API
Where this information came from

This is an independent, third-party profile of Select Star columns API, published by API Evangelist. We do not operate, host, resell, or support these APIs, and we are not affiliated with or endorsed by the company unless stated above. Everything here is built from publicly available information — the company's own site, developer portal, documentation, public repositories, and the specifications it publishes for public use. Nothing is obtained by breaching a system, defeating an access control, or using credentials.

The Kin Score and Agent Readiness rating are independently calculated assessments of a company's public API artifacts, scored against a published rubric. They are not certifications, endorsements, security assessments, or audits.

Corrections, re-scores, and removal are free — no partnership or purchase required, and you do not need to justify the request. A removed company is recorded as unrated, never scored zero for having asked. Acknowledgement within one business day; removal within two.

info@apievangelist.com · Read the full data-sourcing policy →
On a security or compliance team? Put security in the subject line and you will get a person, not a form — we will tell you exactly which public URLs this profile was built from.