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 joins API

The joins API from Select Star — 1 operation(s) for joins.

Select Star joins 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 joins. 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 1 operation across 1 path, and defines 59 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.

1 operations 1 paths 59 schemas 1 GET

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 joins 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 1

Across 1 path, the API surfaces 1 operation — 1 GET. Each is listed below with its method, path, parameters, and response codes.

joins 1
GET
/v1/joins/
List of the joins available in authenticated user's organization Required Role: Authenticated User with Active Organization
joins_list 8 params → 200

Schemas 59

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

DatabaseSerializer.GuidReferenceField.technical_owner
TypeB32Enum
string
status - status dbt - dbt
TablePopularity
object
5 properties 5 required
TableLite
object
5 properties 3 required
DatabaseSerializer.GuidReferenceField.business_owner
BaseMetadata
object
4 properties 4 required
BaseColumn
object
Adds support for reading a description from metadata that support modifying description
3 properties 2 required
TaggedItemsLite
object
Serializer without suggestion source
5 properties 5 required
DescriptionSourceEnum
string
user - User ingestion - Ingestion ai - Ai publicdocs - Public Docs lineage - Lineage downstreamlineage - Downstream Lineage upstreamlineage - Upstream Lineage…
PaginatedJoinList
object
4 properties 2 required
SuggestedDescriptionSourceEnum
string
publicdocs - Public Docs lineage - Lineage downstreamlineage - Downstream Lineage upstreamlineage - Upstream Lineage similarity - Similarity unknown - Unknown
Breadcrumb
object
8 properties 5 required
UserSetting
object
10 properties
JoinPopularity
object
5 properties 5 required
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
SchemaPopularity
object
5 properties 5 required
CloudObjectLite
object
4 properties 1 required
Condition
object
3 properties 3 required
DatabasePopularity
object
5 properties 5 required
SchemaSerializer.GuidReferenceField.business_owner
Table
object
Adds support for reading a description from metadata that support modifying description
43 properties 28 required
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
TableSerializer.GuidReferenceField.technical_owner
CloudObjectTypeEnum
string
s3 - s3 unsupported - unsupported
DSUserName
object
4 properties 2 required
ForeignKey
object
5 properties 4 required
FormatEnum
string
csv - csv json - json unknown - unknown
Join
object
7 properties 5 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
TableColumn
object
13 properties 8 required
Column
object
Adds support for reading a description from metadata that support modifying description
38 properties 36 required
TableSerializer.GuidReferenceField.business_owner
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
TableSerializer.GuidReferenceField.suggested_description_source_object
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-joins-api-openapi.yml Raw ↑

Other APIs Select Star publishes across the network.

Select Star bi API
Select Star collections API
Select Star columns 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
Where this information came from

This is an independent, third-party profile of Select Star joins 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.