Select Star tables API

openapi: 3.2.0
info:
  title: Select Star Metadata bi Tables API
  version: 1.0.0
  x-role-system:
    description: This API uses role-based access control
    roles:
      admin: Full access to all operations
      data_manager: Can modify data and configurations
      user: Read-only access to most resources
  description: API for interacting with the Select Star system
  termsOfService: https://www.selectstar.com/terms-of-service
  contact:
    email: support@selectstar.com
  license:
    name: All Rights Reserved
servers:
- url: https://api.production.selectstar.com
  description: Base URL declared by the provider in apis.yml (roadmap#122).
tags:
- name: tables
paths:
  /v1/tables/:
    get:
      operationId: tables_list
      description: 'List of the tables available in authenticated user''s organization


        **Required Role:** Viewer or higher'
      parameters:
      - name: cloud_object_format
        required: false
        in: query
        description: Filter to only return the entities with the specific file format for the cloud objects.
        schema:
          type: string
      - name: collections
        required: false
        in: query
        description: A comma separated list of collection guids, for to filter the collection items from
        schema:
          type: string
          pattern: ^(cn)_(?P<guid>[23456789ABCDEFGHJKLMNPQRSTUVWXYZabcdefghijkmnopqrstuvwxyz]{22})$
      - name: databases
        required: false
        in: query
        description: A comma separated list of database guids to filter for items within those databases.
        schema:
          type: string
          pattern: ^(db)_(?P<guid>[23456789ABCDEFGHJKLMNPQRSTUVWXYZabcdefghijkmnopqrstuvwxyz]{22})$
      - name: datasources
        required: false
        in: query
        description: A comma separated list of data sources guids to filter for tables.
        schema:
          type: string
          pattern: ^(ds)_(?P<guid>[23456789ABCDEFGHJKLMNPQRSTUVWXYZabcdefghijkmnopqrstuvwxyz]{22})$
      - name: dbt_projects_names
        required: false
        in: query
        description: A comma separated list of dbt project names
        schema:
          type: string
      - name: dbt_tags
        required: false
        in: query
        description: A comma separated list of tag guids
        schema:
          type: string
          pattern: ^(tg)_(?P<guid>[23456789ABCDEFGHJKLMNPQRSTUVWXYZabcdefghijkmnopqrstuvwxyz]{22})$
      - name: dsuser_created_by
        required: false
        in: query
        description: A comma separated list of Data Source Users guids to filter for element creator. Allowed Values include DSUser GUIDs + 'known_users' + 'unknown_users'
        schema:
          type: string
      - name: filenames
        required: false
        in: query
        description: A comma separated list of source file names
        schema:
          type: string
      - name: folders
        required: false
        in: query
        description: A list of dbt project guids to filter thesetables for. The returned values will be dbt models
        schema:
          type: string
          pattern: ^(df)_(?P<guid>[23456789ABCDEFGHJKLMNPQRSTUVWXYZabcdefghijkmnopqrstuvwxyz]{22})$
      - name: include_counts
        required: false
        in: query
        description: Calculate and include total object counts in the response.
        schema:
          type: boolean
          default: true
      - name: is_hidden
        required: false
        in: query
        description: A boolean to show hidden objects when true and hide hidden objects when false. Defaults to False.
        schema:
          type: string
      - name: last_queried_on
        required: false
        in: query
        description: "Filter objects by last_queried_on. May specify __gt, __gte, __lt or __lte.\n\n API call to: \n\n ENDPOINT/last_queried_on__gt=2021-08-04T15:12:40&last_queried_on__lt=2021-08-23 \n\n will result with objects last_queried_on after  August 4th 2021 at 15:12:40, but before August 23rd 2021. \n\n. If you want to include lower or upper bound of the range use __gte or __lte respectively."
        schema:
          type: string
      - name: new
        required: false
        in: query
        description: A boolean which filters for newest tables in the organization.
        schema:
          type: string
      - name: no_business_owner
        required: false
        in: query
        description: A flag that filters out any table that has a business owner.
        schema:
          type: string
      - name: no_description
        required: false
        in: query
        description: A flag that filters out any tables with descriptions
        schema:
          type: string
      - name: no_downstream_lineage
        required: false
        in: query
        description: A flag that shows only tables with no downstream lineage
        schema:
          type: string
      - name: no_popularity
        required: false
        in: query
        description: A flag that filters out any table that has a popularity rating.
        schema:
          type: string
      - name: no_tags
        required: false
        in: query
        description: A flag that filters out any tagged tables
        schema:
          type: string
      - name: no_technical_owner
        required: false
        in: query
        description: A flag that filters out any table that has a technical owner.
        schema:
          type: string
      - name: no_upstream_lineage
        required: false
        in: query
        description: A flag that shows only tables with no upstream lineage
        schema:
          type: string
      - name: order
        required: false
        in: query
        description: "Specify the ordering for the results. \n\n A comma separated list for ordering by multiple fields and a preceding `-` indicates reverse order. \n\nNote: Order is case-sensitive."
        schema:
          type: string
          enum:
          - business_owner
          - bytes
          - collection
          - description
          - downstream_dashboards
          - downstream_objects_total
          - impact_score
          - is_custom
          - label
          - name
          - popularity
          - row_count
          - schema
          - technical_owner
          - upstream_objects_total
      - name: owners
        required: false
        in: query
        description: A comma separated list of user or team guids to filter for objects within these users as owners (technical or business).
        schema:
          type: string
          pattern: ^(us|te)_(?P<guid>[23456789ABCDEFGHJKLMNPQRSTUVWXYZabcdefghijkmnopqrstuvwxyz]{22})$
      - name: page
        required: false
        in: query
        description: A page number within the paginated result set.
        schema:
          type: integer
      - name: page_size
        required: false
        in: query
        description: Number of results to return per page.
        schema:
          type: integer
      - name: popularity
        required: false
        in: query
        description: A comma separated list of popularity ranges (inclusive) can include integers from 1-100 ex) 1-10,90-100 would be the bottom 10 percent and the top 10 percent, respectively. Ranges can overlap.
        schema:
          type: string
      - name: schemas
        required: false
        in: query
        description: A comma separated list of schema guids to filter for tables within those schemas.
        schema:
          type: string
          pattern: ^(cl)_(?P<guid>[23456789ABCDEFGHJKLMNPQRSTUVWXYZabcdefghijkmnopqrstuvwxyz]{22})$
      - name: search_all
        required: false
        in: query
        description: Search a table with multiple types of params in one go
        schema:
          type: string
      - name: search_business_owner
        required: false
        in: query
        description: Search for an asset using business owner name
        schema:
          type: string
      - name: search_collections
        required: false
        in: query
        description: Search for an asset using a collection name
        schema:
          type: string
      - name: search_description
        required: false
        in: query
        description: Search for an asset using its description
        schema:
          type: string
      - name: search_location
        required: false
        in: query
        description: A search term.
        schema:
          type: string
      - name: search_name
        required: false
        in: query
        description: Search for tables given a table name (upto data source name)
        schema:
          type: string
      - name: search_tag_name
        required: false
        in: query
        description: Search for an asset using a tag name
        schema:
          type: string
      - name: search_technical_owner
        required: false
        in: query
        description: Search for an asset using technical owner name
        schema:
          type: string
      - name: status_tags
        required: false
        in: query
        description: A comma separated list of tag guids
        schema:
          type: string
          pattern: ^(tg)_(?P<guid>[23456789ABCDEFGHJKLMNPQRSTUVWXYZabcdefghijkmnopqrstuvwxyz]{22})$
      - name: tables
        required: false
        in: query
        description: A list of table guids to filter for
        schema:
          type: string
          pattern: ^(ta)_(?P<guid>[23456789ABCDEFGHJKLMNPQRSTUVWXYZabcdefghijkmnopqrstuvwxyz]{22})$
      - name: teams
        required: false
        in: query
        description: A comma separated list of team guids to filter for tables owned by users of those teams.
        schema:
          type: string
          pattern: ^(te)_(?P<guid>[23456789ABCDEFGHJKLMNPQRSTUVWXYZabcdefghijkmnopqrstuvwxyz]{22})$
      - name: updated_on
        required: false
        in: query
        description: "Filter objects by updated_on. May specify __gt, __gte, __lt or __lte.\n\n API call to: \n\n ENDPOINT/updated_on__gt=2021-08-04T15:12:40&updated_on__lt=2021-08-23 \n\n will result with objects updated_on after  August 4th 2021 at 15:12:40, but before August 23rd 2021. \n\n. If you want to include lower or upper bound of the range use __gte or __lte respectively."
        schema:
          type: string
      tags:
      - tables
      security:
      - JWTAuthentication: []
      - tokenAuth: []
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/PaginatedTableList'
          description: ''
      x-role-requirements: Viewer or higher
  /v1/tables/{guid}/:
    get:
      operationId: tables_retrieve
      description: 'Retrieve a single table


        **Required Role:** Viewer or higher'
      parameters:
      - in: path
        name: guid
        schema:
          type: string
          pattern: ^([a-zA-z]{2}_[a-zA-Z0-9]{22})|me|default|([a-zA-z]{2}_[a-zA-Z0-9]{22}).personal$
        required: true
      tags:
      - tables
      security:
      - JWTAuthentication: []
      - tokenAuth: []
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Table'
          description: ''
      x-role-requirements: Viewer or higher
    patch:
      operationId: tables_partial_update
      description: 'Update a single table


        **Required Role:** Data Manager or higher'
      parameters:
      - in: path
        name: guid
        schema:
          type: string
          pattern: ^([a-zA-z]{2}_[a-zA-Z0-9]{22})|me|default|([a-zA-z]{2}_[a-zA-Z0-9]{22}).personal$
        required: true
      tags:
      - tables
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/PatchedTableRequest'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/PatchedTableRequest'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/PatchedTableRequest'
      security:
      - JWTAuthentication: []
      - tokenAuth: []
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Table'
          description: ''
      x-role-requirements: Data Manager or higher
  /v1/tables/{guid}/frequent-bi-dsusers/:
    get:
      operationId: tables_frequent_bi_dsusers_retrieve
      description: 'Get the most frequent BI users that query a table.


        **Required Role:** Authenticated User with Active Organization'
      parameters:
      - in: path
        name: guid
        schema:
          type: string
          pattern: ^([a-zA-z]{2}_[a-zA-Z0-9]{22})|me|default|([a-zA-z]{2}_[a-zA-Z0-9]{22}).personal$
        required: true
      tags:
      - tables
      security:
      - JWTAuthentication: []
      - tokenAuth: []
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/FrequentDSUser'
          description: ''
      x-role-requirements: Authenticated User with Active Organization
  /v1/tables/{guid}/frequent-dsusers/:
    get:
      operationId: tables_frequent_dsusers_retrieve
      description: 'Get the most frequent data source users and associated Select Star users (if any) that query specified table


        **Required Role:** Authenticated User with Active Organization'
      parameters:
      - in: path
        name: guid
        schema:
          type: string
          pattern: ^([a-zA-z]{2}_[a-zA-Z0-9]{22})|me|default|([a-zA-z]{2}_[a-zA-Z0-9]{22}).personal$
        required: true
      tags:
      - tables
      security:
      - JWTAuthentication: []
      - tokenAuth: []
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/FrequentDSUser'
          description: ''
      x-role-requirements: Authenticated User with Active Organization
  /v1/tables/{guid}/frequent-teams/:
    get:
      operationId: tables_frequent_teams_retrieve
      description: 'Get the teams that most frequently query the specified table.


        **Required Role:** Authenticated User with Active Organization'
      parameters:
      - in: path
        name: guid
        schema:
          type: string
          pattern: ^([a-zA-z]{2}_[a-zA-Z0-9]{22})|me|default|([a-zA-z]{2}_[a-zA-Z0-9]{22}).personal$
        required: true
      tags:
      - tables
      security:
      - JWTAuthentication: []
      - tokenAuth: []
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Team'
          description: ''
      x-role-requirements: Authenticated User with Active Organization
  /v1/tables/{guid}/frequent-users/:
    get:
      operationId: tables_frequent_users_retrieve
      description: 'Get the most frequent users that query specified table


        **Required Role:** Authenticated User with Active Organization'
      parameters:
      - in: path
        name: guid
        schema:
          type: string
          pattern: ^([a-zA-z]{2}_[a-zA-Z0-9]{22})|me|default|([a-zA-z]{2}_[a-zA-Z0-9]{22}).personal$
        required: true
      tags:
      - tables
      security:
      - JWTAuthentication: []
      - tokenAuth: []
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/FrequentUser'
          description: ''
      x-role-requirements: Authenticated User with Active Organization
  /v1/tables/{guid}/related-dashboards/:
    get:
      operationId: tables_related_dashboards_list
      description: 'Gets a list of related dashboards given a table_guid


        **Required Role:** Viewer or higher'
      parameters:
      - name: distance
        required: false
        in: query
        description: A search term.
        schema:
          type: string
      - in: path
        name: guid
        schema:
          type: string
          pattern: ^([a-zA-z]{2}_[a-zA-Z0-9]{22})|me|default|([a-zA-z]{2}_[a-zA-Z0-9]{22}).personal$
        required: true
      - name: include_hidden
        required: false
        in: query
        description: A flag allowing to include hidden dashboards in the response.
        schema:
          type: boolean
      - name: order
        required: false
        in: query
        description: "Specify the ordering for the results. \n\n A comma separated list for ordering by multiple fields and a preceding `-` indicates reverse order. \n\nNote: Order is case-sensitive."
        schema:
          type: string
          enum:
          - dashboard_updated_at
          - distance
          - dsuser_created_by
          - last_run_at
          - last_run_or_viewed_at
          - name
          - popularity
          - rank
          - view_count
      - name: page
        required: false
        in: query
        description: A page number within the paginated result set.
        schema:
          type: integer
      - name: page_size
        required: false
        in: query
        description: Number of results to return per page.
        schema:
          type: integer
      - name: relevant_lineage
        required: false
        in: query
        description: When `relevant_lineage` is `true`, we only use edges between columns to traverse the graph. Requires relevant lineage to be enabled in the organization; the flag is ignored otherwise.
        schema:
          type: boolean
      - name: search_all
        required: false
        in: query
        description: A search term.
        schema:
          type: string
      - name: search_dsuser_created_by
        required: false
        in: query
        description: A search term.
        schema:
          type: string
      - name: search_name
        required: false
        in: query
        description: A search term.
        schema:
          type: string
      - name: updated_on
        required: false
        in: query
        description: "Filter objects by updated_on. May specify __gt, __gte, __lt or __lte.\n\n API call to: \n\n ENDPOINT/updated_on__gt=2021-08-04T15:12:40&updated_on__lt=2021-08-23 \n\n will result with objects updated_on after  August 4th 2021 at 15:12:40, but before August 23rd 2021. \n\n. If you want to include lower or upper bound of the range use __gte or __lte respectively."
        schema:
          type: string
      tags:
      - tables
      security:
      - JWTAuthentication: []
      - tokenAuth: []
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/PaginatedTableRelatedDashboardList'
          description: ''
      x-role-requirements: Viewer or higher
  /v1/tables/export/:
    get:
      operationId: tables_export_retrieve
      description: 'Returns a CSV with data to export.


        **Required Role:** Viewer or higher'
      tags:
      - tables
      security:
      - JWTAuthentication: []
      - tokenAuth: []
      responses:
        '200':
          content:
            text/csv:
              schema:
                $ref: '#/components/schemas/Table'
          description: ''
      x-role-requirements: Viewer or higher
  /v1/tables/frequent-dsusers/:
    get:
      operationId: tables_frequent_dsusers_list
      description: 'Get the most frequent data source users and associated Select Star users (if any) that query a list of tables


        **Required Role:** Authenticated User with Active Organization'
      parameters:
      - name: datasources
        required: false
        in: query
        description: A comma separated list of data source guids to filter for items within those data sources.
        schema:
          type: string
          pattern: ^(ds)_(?P<guid>[23456789ABCDEFGHJKLMNPQRSTUVWXYZabcdefghijkmnopqrstuvwxyz]{22})$
      - name: only_registered_users
        required: false
        in: query
        description: A flag to hide DSUsers with no association with registered application users
        schema:
          type: string
      - name: order
        required: false
        in: query
        description: "Specify the ordering for the results. \n\n A comma separated list for ordering by multiple fields and a preceding `-` indicates reverse order. \n\nNote: Order is case-sensitive."
        schema:
          type: string
          enum:
          - last_queried
          - name
          - query_count
      - name: page
        required: false
        in: query
        description: A page number within the paginated result set.
        schema:
          type: integer
      - name: page_size
        required: false
        in: query
        description: Number of results to return per page.
        schema:
          type: integer
      - name: require_email
        required: false
        in: query
        description: A flag to hide DSUsers with no associated registered user nor email
        schema:
          type: string
      - name: search_name
        required: false
        in: query
        description: A search term.
        schema:
          type: string
      - name: type
        required: false
        in: query
        description: A comma separated list of data source types to filter for dsusers within that type
        schema:
          type: string
      tags:
      - tables
      security:
      - JWTAuthentication: []
      - tokenAuth: []
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/PaginatedFrequentDSUserList'
          description: ''
      x-role-requirements: Authenticated User with Active Organization
  /v1/tables/owners/:
    patch:
      operationId: tables_owners_partial_update
      description: 'Update table owners


        **Required Role:** Data Manager or higher'
      tags:
      - tables
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/PatchedTableOwnersBulkEditRequest'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/PatchedTableOwnersBulkEditRequest'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/PatchedTableOwnersBulkEditRequest'
      security:
      - JWTAuthentication: []
      - tokenAuth: []
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/TableOwnersBulkEdit'
          description: ''
      x-role-requirements: Data Manager or higher
components:
  schemas:
    CloudObjectLiteRequest:
      type: object
      properties:
        location:
          type: string
          minLength: 1
          description: Location on the cloud, the Directory of the Data. NOT the file name
        objects_count:
          type:
          - integer
          - 'null'
          maximum: 9223372036854775807
          minimum: -9223372036854775808
          format: int64
          description: Number of Files/Objects in the specified location
        format:
          $ref: '#/components/schemas/FormatEnum'
        cloud_object_type:
          allOf:
          - $ref: '#/components/schemas/CloudObjectTypeEnum'
          description: 'Type of cloud object i.e., S3, Google Cloud Storage, Azure Blob Storage


            * `s3` - s3

            * `unsupported` - unsupported'
      required:
      - location
    Dashboard:
      type: object
      description: 'Adds support for reading a description from metadata

        that support modifying description'
      properties:
        guid:
          type: string
          maxLength: 25
        bifolder:
          $ref: '#/components/schemas/BIFolder'
        name:
          type:
          - string
          - 'null'
        data_type:
          type: string
          readOnly: true
        description:
          type:
          - string
          - 'null'
          description: Active description
        search_name:
          type: string
          readOnly: true
        description_source:
          allOf:
          - $ref: '#/components/schemas/DescriptionSourceEnum'
        user_description:
          type:
          - string
          - 'null'
          description: User description
        user_description_author:
          allOf:
          - $ref: '#/components/schemas/UserLite'
          readOnly: true
        ingested_description:
          type:
          - string
          - 'null'
          description: Unmodified description from the data source
        ai_description:
          type:
          - string
          - 'null'
          description: AI-generated description
        richtext_description:
          type:
          - string
          - 'null'
          description: Richtext formatted description. Can be in Slatejs or Draftjs format.
        dashboard_created_at:
          type:
          - string
          - 'null'
          format: date-time
          description: The creation date ingested from API
        dashboard_updated_at:
          type:
          - string
          - 'null'
          format: date-time
          description: The updation date ingested from API
        last_successful_run:
          type:
          - string
          - 'null'
          format: date-time
          description: The last date where the dashboard was successfully run at
        was_last_run_successful:
          type:
          - boolean
          - 'null'
          description: Was the last run to this dashboard successful at the time we ingested?
        last_run_at:
          type:
          - string
          - 'null'
          format: date-time
          description: The last date where the dashboard was attempted to run at
        query_count:
          type: integer
          maximum: 2147483647
          minimum: -2147483648
        chart_count:
          type: integer
          maximum: 2147483647
          minimum: -2147483648
        runs_count:
          type: integer
          maximum: 2147483647
          minimum: -2147483648
        view_count:
          type: integer
          maximum: 2147483647
          minimum: -2147483648
        dsuser_created_by:
          $ref: '#/components/schemas/DSUser'
        top_dsuser:
          $ref: '#/components/schemas/DSUser'
        dsuser_owned_by:
          $ref: '#/components/schemas/DSUser'
        business_owner:
          $ref: '#/components/schemas/DashboardSerializer.GuidReferenceField.business_owner'
        technical_owner:
          $ref: '#/components/schemas/DashboardSerializer.GuidReferenceField.technical_owner'
        url:
          type:
          - string
          - 'null'
          readOnly: true
          description: 'The full url of the report obtained from the links field. '
        popularity:
          allOf:
          - $ref: '#/components/schemas/DashboardPopularity'
          readOnly: true
        query_errors:
          type: array
          items:
            $ref: '#/components/schemas/QueryError'
        tagged_items:
          type: array
          items:
            $ref: '#/components/schemas/TaggedItemsLiteWithSource'
          readOnly: true
        size:
          type:
          - integer
          - 'null'
          maximum: 9223372036854775807
          minimum: -9223372036854775808
          format: int64
          description: Size of dashboard objects in bytes
        full_path:
          type:
          - string
          - 'null'
          description: The cached full path of the dashboard folder
        is_hidden:
          type: boolean
          readOnly: true
        downstream_objects_counts:
          allOf:
          - $ref: '#/components/schemas/RelatedObjectsCounts'
          readOnly: true
        upstream_objects_counts:
          allOf:
          - $ref: '#/components/schemas/RelatedObjectsCounts'
          readOnly: true
        source_tables_count:
          type: integer
          default: 0
        last_query_error:
          $ref: '#/components/schemas/QueryError'
        breadcrumbs:
          type: array
          items:
            $ref: '#/components/schemas/Breadcrumb'
          readOnly: true
        data_types:
          allOf:
          - $ref: '#/components/schemas/BaseType'
          readOnly: true
        raw_sql:
          type:
          - string
          - 'null'
        last_viewed_at:
          type: string
          format: date
        collections:
          type: array
          items:
            $ref: '#/components/schemas/CollectionLite'
          readOnly: true
      required:
      - bifolder
      - breadcrumbs
      - collections
      - data_type
      - data_types
      - downstream_objects_counts
      - is_hidden
      - popularity
      - search_name
      - tagged_items
      - upstream_objects_counts
      - url
      - user_description_author
    DashboardLiteSerializer.GuidReferenceField.technical_owner:
      anyOf:
      - $ref: '#/components/schemas/DSUserName'
      - $ref: '#/components/schemas/Team'
      - $ref: '#/components/schemas/UserLite'
      discriminator:
        propertyName: object_type
        mapping:
          dsuser: '#/components/schemas/DSUserName'
          team: '#/components/schemas/Team'
          user: '#/components/schemas/UserLite'
    TargetDataSourceTypeEnum:
      enum:
      - airflow
      - aws_s3
      - bigquery
      - data_studio
      - databricks
      - db_agent
      - db2
      - dbt
      - fivetran
      - glue
      - hex
      - looker
      - metabase
      - mode
      - monte_carlo
      - mssql
      - mysql
      - omni
      - openlineage
      - oracle
      - periscope
      - postgres
      - power_bi
      - quicksight
      - redshift
      - salesforce
      - salesforce_crma
      - sigma
      - snowflake
      - tableau
      - thoughtspot
      - trial
      - trial_redshift
      type: string
      description: '* `airflow` - Airflow

        * `aws_s3` - AWS S3

        * `bigquery` - BigQuery

        * `data_studio` - Looker Studio

        * `databricks` - Databricks

        * `db_agent` - DB Agent

        * `db2` - DB2

        * `dbt` - dbt

        * `fivetran` - Fivetran

        * `glue` - Glue

        * `hex` - Hex

        * `looker` - Looker

        * `metabase` - Metabase

        * `mode` - Mode

        * `monte_carlo` - Monte Carlo

        * `mssql` - MS SQL

        * `mysql` - MySQL

        * `omni` - Omni BI

        * `openlineage` - Open Lineage

        * `oracle` - Oracle

        * `periscope` - Periscope

        * `postgres` - PostgreSQL

        * `power_bi` - Power BI

        * `quicksight` - QuickSight

        * `redshift` - Redshift

        * `salesforce` - Salesforce

        * `salesforce_crma` - Salesforce Analytics

        * `sigma` - Sigma

        * `snowflake` - Snowflake

        * `tableau` - Tableau

        * `thoughtspot` - ThoughtSpot

        * `trial` - Trial

        * `trial_redshift` - Trial Redshift'
    SchemaPopularity:
      type: object
      properties:
        timeframe:
          type: integer
          readOnly: true
          default: 90
        user_count:
          type: integer
          readOnly: true
        service_query_count:
          type: integer
          readOnly: true
        popularity:
          type: integer
          readOnly: true
          description: Popularity score for this object from 0-100
        query_count:
          type: integer
      required:
      - popularity
      - query_count
      - service_query_count
      - timeframe
      - user_count
    FormatEnum:
      enum:
      - csv
      - json
      - unknown
      type: string
      description: '* `csv` - csv

        * `json` - json

        * `unknown` - unknown'
    UserRequest:
      type: object
      properties:
        first_name:
          type: string
          minLength: 1
        last_name:
          type: string
          minLength: 1
        email:
          type: string
          format: email
          pattern: ''
          description: Email address of the user. Only corporate email addresses are allowed.
          minLength: 1
        is_agreed_to_terms:
          type: boolean
        settings:
          $ref: '#/components/schemas/UserSettingRequest'
        passw

# --- truncated at 32 KB (94 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/select-star/refs/heads/main/openapi/select-star-tables-api-openapi.yml