INTERFACE

Datasource

Root GraphQL type for embedded and published data sources

Data sources are a way to represent how Tableau Desktop and Tableau Server model and connect to data. Data sources can be published separately, as a published data source, or may be contained in a workbook as an embedded data source.

See https://onlinehelp.tableau.com/current/server/en-us/datasource.htm

link GraphQL Schema definition

  • interface Datasource {
  • # Unique identifier used by the metadata API. Not the same as the numeric ID used
  • # on server
  • id: ID!
  • # Name shown in server and desktop clients
  • name: String
  • # True if data source contains a formula that involves a user function (for
  • # example, USERNAME or ISMEMBEROF)
  • hasUserReference: Boolean
  • # True if datasource contains extracted data
  • hasExtracts: Boolean
  • # True if the datasource contains unsupported custom SQL, in which case lineage
  • # may be incomplete
  • containsUnsupportedCustomSql: Boolean
  • # Time an extract was last fully refreshed
  • extractLastRefreshTime: DateTime
  • # Time an extract was last incrementally updated
  • extractLastIncrementalUpdateTime: DateTime
  • # Time an extract was last updated by either a full refresh, incremental update,
  • # or creation
  • extractLastUpdateTime: DateTime
  • # Fields usable in workbooks connected to this data source
  • #
  • # Arguments
  • # filter: Filter by GraphQL field and given value
  • # orderBy: Sort by given fields. The sort orders defined first in
  • # the list will take priority. If there are no given sort orders or a tie on the
  • # final sorted field then the resulting set will be sorted by ID in ascending
  • # order.
  • # permissionMode: Results filtering mode.
  • fields(
  • filter: Field_Filter,
  • orderBy: FieldSortOrder,
  • permissionMode: PermissionMode
  • ): [Field!]!
  • # Fields usable in workbooks connected to this data source
  • #
  • # Arguments
  • # after: The cursor to receive the next page of objects. If no
  • # cursor is supplied it will start at the beginning of the list. Offset can not be
  • # set at the same time. This is the preferred API to use if possible as it is
  • # faster.
  • # first: Maximum number of objects to be returned in a page. The
  • # default is 100
  • # offset: The number of entries to offset the start of the page
  • # by. If no offset is supplied it will start at the beginning of the list. After
  • # can not be set at the same time.
  • # filter: Filter by GraphQL field and given value
  • # orderBy: Sort by given fields. The sort orders defined first in
  • # the list will take priority. If there are no given sort orders or a tie on the
  • # final sorted field then the resulting set will be sorted by ID in ascending
  • # order.
  • # permissionMode: Results filtering mode.
  • fieldsConnection(
  • after: String,
  • first: Int,
  • offset: Int,
  • filter: Field_Filter,
  • orderBy: FieldSortOrder,
  • permissionMode: PermissionMode
  • ): FieldsConnection
  • # Data source filters contained in this data source
  • #
  • # Arguments
  • # filter: Filter by GraphQL field and given value
  • # orderBy: Sort by given fields. The sort orders defined first in
  • # the list will take priority. If there are no given sort orders or a tie on the
  • # final sorted field then the resulting set will be sorted by ID in ascending
  • # order.
  • # permissionMode: Results filtering mode.
  • datasourceFilters(
  • filter: DatasourceFilter_Filter,
  • orderBy: DatasourceFilterSortOrder,
  • permissionMode: PermissionMode
  • ): [DatasourceFilter!]!
  • # Data source filters contained in this data source
  • #
  • # Arguments
  • # after: The cursor to receive the next page of objects. If no
  • # cursor is supplied it will start at the beginning of the list. Offset can not be
  • # set at the same time. This is the preferred API to use if possible as it is
  • # faster.
  • # first: Maximum number of objects to be returned in a page. The
  • # default is 100
  • # offset: The number of entries to offset the start of the page
  • # by. If no offset is supplied it will start at the beginning of the list. After
  • # can not be set at the same time.
  • # filter: Filter by GraphQL field and given value
  • # orderBy: Sort by given fields. The sort orders defined first in
  • # the list will take priority. If there are no given sort orders or a tie on the
  • # final sorted field then the resulting set will be sorted by ID in ascending
  • # order.
  • # permissionMode: Results filtering mode.
  • datasourceFiltersConnection(
  • after: String,
  • first: Int,
  • offset: Int,
  • filter: DatasourceFilter_Filter,
  • orderBy: DatasourceFilterSortOrder,
  • permissionMode: PermissionMode
  • ): DatasourceFiltersConnection
  • # Sheets downstream from this data source
  • #
  • # Arguments
  • # filter: Filter by GraphQL field and given value
  • # orderBy: Sort by given fields. The sort orders defined first in
  • # the list will take priority. If there are no given sort orders or a tie on the
  • # final sorted field then the resulting set will be sorted by ID in ascending
  • # order.
  • # permissionMode: Results filtering mode.
  • downstreamSheets(
  • filter: Sheet_Filter,
  • orderBy: SheetSortOrder,
  • permissionMode: PermissionMode
  • ): [Sheet!]!
  • # Sheets downstream from this data source
  • #
  • # Arguments
  • # after: The cursor to receive the next page of objects. If no
  • # cursor is supplied it will start at the beginning of the list. Offset can not be
  • # set at the same time. This is the preferred API to use if possible as it is
  • # faster.
  • # first: Maximum number of objects to be returned in a page. The
  • # default is 100
  • # offset: The number of entries to offset the start of the page
  • # by. If no offset is supplied it will start at the beginning of the list. After
  • # can not be set at the same time.
  • # filter: Filter by GraphQL field and given value
  • # orderBy: Sort by given fields. The sort orders defined first in
  • # the list will take priority. If there are no given sort orders or a tie on the
  • # final sorted field then the resulting set will be sorted by ID in ascending
  • # order.
  • # permissionMode: Results filtering mode.
  • downstreamSheetsConnection(
  • after: String,
  • first: Int,
  • offset: Int,
  • filter: Sheet_Filter,
  • orderBy: SheetSortOrder,
  • permissionMode: PermissionMode
  • ): SheetsConnection
  • # Dashboards downstream from this data source
  • #
  • # Arguments
  • # filter: Filter by GraphQL field and given value
  • # orderBy: Sort by given fields. The sort orders defined first in
  • # the list will take priority. If there are no given sort orders or a tie on the
  • # final sorted field then the resulting set will be sorted by ID in ascending
  • # order.
  • # permissionMode: Results filtering mode.
  • downstreamDashboards(
  • filter: Dashboard_Filter,
  • orderBy: DashboardSortOrder,
  • permissionMode: PermissionMode
  • ): [Dashboard!]!
  • # Dashboards downstream from this data source
  • #
  • # Arguments
  • # after: The cursor to receive the next page of objects. If no
  • # cursor is supplied it will start at the beginning of the list. Offset can not be
  • # set at the same time. This is the preferred API to use if possible as it is
  • # faster.
  • # first: Maximum number of objects to be returned in a page. The
  • # default is 100
  • # offset: The number of entries to offset the start of the page
  • # by. If no offset is supplied it will start at the beginning of the list. After
  • # can not be set at the same time.
  • # filter: Filter by GraphQL field and given value
  • # orderBy: Sort by given fields. The sort orders defined first in
  • # the list will take priority. If there are no given sort orders or a tie on the
  • # final sorted field then the resulting set will be sorted by ID in ascending
  • # order.
  • # permissionMode: Results filtering mode.
  • downstreamDashboardsConnection(
  • after: String,
  • first: Int,
  • offset: Int,
  • filter: Dashboard_Filter,
  • orderBy: DashboardSortOrder,
  • permissionMode: PermissionMode
  • ): DashboardsConnection
  • # Workbooks downstream from this data source
  • #
  • # Arguments
  • # filter: Filter by GraphQL field and given value
  • # orderBy: Sort by given fields. The sort orders defined first in
  • # the list will take priority. If there are no given sort orders or a tie on the
  • # final sorted field then the resulting set will be sorted by ID in ascending
  • # order.
  • # permissionMode: Results filtering mode.
  • downstreamWorkbooks(
  • filter: Workbook_Filter,
  • orderBy: WorkbookSortOrder,
  • permissionMode: PermissionMode
  • ): [Workbook!]!
  • # Workbooks downstream from this data source
  • #
  • # Arguments
  • # after: The cursor to receive the next page of objects. If no
  • # cursor is supplied it will start at the beginning of the list. Offset can not be
  • # set at the same time. This is the preferred API to use if possible as it is
  • # faster.
  • # first: Maximum number of objects to be returned in a page. The
  • # default is 100
  • # offset: The number of entries to offset the start of the page
  • # by. If no offset is supplied it will start at the beginning of the list. After
  • # can not be set at the same time.
  • # filter: Filter by GraphQL field and given value
  • # orderBy: Sort by given fields. The sort orders defined first in
  • # the list will take priority. If there are no given sort orders or a tie on the
  • # final sorted field then the resulting set will be sorted by ID in ascending
  • # order.
  • # permissionMode: Results filtering mode.
  • downstreamWorkbooksConnection(
  • after: String,
  • first: Int,
  • offset: Int,
  • filter: Workbook_Filter,
  • orderBy: WorkbookSortOrder,
  • permissionMode: PermissionMode
  • ): WorkbooksConnection
  • # Workbook owners downstream from this data source
  • #
  • # Arguments
  • # filter: Filter by GraphQL field and given value
  • # orderBy: Sort by given fields. The sort orders defined first in
  • # the list will take priority. If there are no given sort orders or a tie on the
  • # final sorted field then the resulting set will be sorted by ID in ascending
  • # order.
  • downstreamOwners(
  • filter: TableauUser_Filter,
  • orderBy: TableauUserSortOrder
  • ): [TableauUser!]!
  • # Workbook owners downstream from this data source
  • #
  • # Arguments
  • # after: The cursor to receive the next page of objects. If no
  • # cursor is supplied it will start at the beginning of the list. Offset can not be
  • # set at the same time. This is the preferred API to use if possible as it is
  • # faster.
  • # first: Maximum number of objects to be returned in a page. The
  • # default is 100
  • # offset: The number of entries to offset the start of the page
  • # by. If no offset is supplied it will start at the beginning of the list. After
  • # can not be set at the same time.
  • # filter: Filter by GraphQL field and given value
  • # orderBy: Sort by given fields. The sort orders defined first in
  • # the list will take priority. If there are no given sort orders or a tie on the
  • # final sorted field then the resulting set will be sorted by ID in ascending
  • # order.
  • downstreamOwnersConnection(
  • after: String,
  • first: Int,
  • offset: Int,
  • filter: TableauUser_Filter,
  • orderBy: TableauUserSortOrder
  • ): TableauUsersConnection
  • # Tables upstream from this data source
  • #
  • # Arguments
  • # filter: Filter by GraphQL field and given value
  • # orderBy: Sort by given fields. The sort orders defined first in
  • # the list will take priority. If there are no given sort orders or a tie on the
  • # final sorted field then the resulting set will be sorted by ID in ascending
  • # order.
  • # permissionMode: Results filtering mode.
  • upstreamTables(
  • filter: DatabaseTable_Filter,
  • orderBy: DatabaseTableSortOrder,
  • permissionMode: PermissionMode
  • ): [DatabaseTable!]!
  • # Tables upstream from this data source
  • #
  • # Arguments
  • # after: The cursor to receive the next page of objects. If no
  • # cursor is supplied it will start at the beginning of the list. Offset can not be
  • # set at the same time. This is the preferred API to use if possible as it is
  • # faster.
  • # first: Maximum number of objects to be returned in a page. The
  • # default is 100
  • # offset: The number of entries to offset the start of the page
  • # by. If no offset is supplied it will start at the beginning of the list. After
  • # can not be set at the same time.
  • # filter: Filter by GraphQL field and given value
  • # orderBy: Sort by given fields. The sort orders defined first in
  • # the list will take priority. If there are no given sort orders or a tie on the
  • # final sorted field then the resulting set will be sorted by ID in ascending
  • # order.
  • # permissionMode: Results filtering mode.
  • upstreamTablesConnection(
  • after: String,
  • first: Int,
  • offset: Int,
  • filter: DatabaseTable_Filter,
  • orderBy: DatabaseTableSortOrder,
  • permissionMode: PermissionMode
  • ): DatabaseTablesConnection
  • # Databases upstream from this data source
  • #
  • # Arguments
  • # filter: Filter by GraphQL field and given value
  • # orderBy: Sort by given fields. The sort orders defined first in
  • # the list will take priority. If there are no given sort orders or a tie on the
  • # final sorted field then the resulting set will be sorted by ID in ascending
  • # order.
  • # permissionMode: Results filtering mode.
  • upstreamDatabases(
  • filter: Database_Filter,
  • orderBy: DatabaseSortOrder,
  • permissionMode: PermissionMode
  • ): [Database!]!
  • # Databases upstream from this data source
  • #
  • # Arguments
  • # after: The cursor to receive the next page of objects. If no
  • # cursor is supplied it will start at the beginning of the list. Offset can not be
  • # set at the same time. This is the preferred API to use if possible as it is
  • # faster.
  • # first: Maximum number of objects to be returned in a page. The
  • # default is 100
  • # offset: The number of entries to offset the start of the page
  • # by. If no offset is supplied it will start at the beginning of the list. After
  • # can not be set at the same time.
  • # filter: Filter by GraphQL field and given value
  • # orderBy: Sort by given fields. The sort orders defined first in
  • # the list will take priority. If there are no given sort orders or a tie on the
  • # final sorted field then the resulting set will be sorted by ID in ascending
  • # order.
  • # permissionMode: Results filtering mode.
  • upstreamDatabasesConnection(
  • after: String,
  • first: Int,
  • offset: Int,
  • filter: Database_Filter,
  • orderBy: DatabaseSortOrder,
  • permissionMode: PermissionMode
  • ): DatabasesConnection
  • # Time the datasource was created. Available in Tableau Cloud June 2022 / Server
  • # 2022.3 and later.
  • createdAt: DateTime
  • # Time the datasource was last updated. Available in Tableau Cloud June 2022 /
  • # Server 2022.3 and later.
  • updatedAt: DateTime
  • # The lenses derived from this datasource
  • #
  • # Arguments
  • # filter: Filter by GraphQL field and given value
  • # orderBy: Sort by given fields. The sort orders defined first in
  • # the list will take priority. If there are no given sort orders or a tie on the
  • # final sorted field then the resulting set will be sorted by ID in ascending
  • # order.
  • # permissionMode: Results filtering mode.
  • lenses(
  • filter: Lens_Filter,
  • orderBy: LensSortOrder,
  • permissionMode: PermissionMode
  • ): [Lens]
  • # The lenses derived from this datasource
  • #
  • # Arguments
  • # after: The cursor to receive the next page of objects. If no
  • # cursor is supplied it will start at the beginning of the list. Offset can not be
  • # set at the same time. This is the preferred API to use if possible as it is
  • # faster.
  • # first: Maximum number of objects to be returned in a page. The
  • # default is 100
  • # offset: The number of entries to offset the start of the page
  • # by. If no offset is supplied it will start at the beginning of the list. After
  • # can not be set at the same time.
  • # filter: Filter by GraphQL field and given value
  • # orderBy: Sort by given fields. The sort orders defined first in
  • # the list will take priority. If there are no given sort orders or a tie on the
  • # final sorted field then the resulting set will be sorted by ID in ascending
  • # order.
  • # permissionMode: Results filtering mode.
  • lensesConnection(
  • after: String,
  • first: Int,
  • offset: Int,
  • filter: Lens_Filter,
  • orderBy: LensSortOrder,
  • permissionMode: PermissionMode
  • ): LensesConnection
  • }

link Require by