The table introspection object.
When setting up a Data Source, Propel may need to introspect tables in order to determine what tables and columns are available to create Data Pools from. The table introspection represents the lifecycle of this operation (whether it's in-progress, succeeded, or failed) and the resulting tables and columns. These will be captured as table and column objects, respectively.
dataSource non-null DataSource
The Data Source the table introspection was performed for.
The Data Source object.
A Data Source is a connection to your data warehouse. It has the necessary connection details for Propel to access Snowflake or any other supported Data Source.
dataSource.id non-null ID
The Data Source's unique identifier.
dataSource.uniqueName non-null String
The Data Source's unique name.
dataSource.description non-null String
The Data Source's description.
dataSource.account non-null Account
The Data Source's Account.
dataSource.environment non-null Environment
The Data Source's Environment.
dataSource.createdAt non-null DateTime
The Data Source's creation date and time in UTC.
dataSource.modifiedAt non-null DateTime
The Data Source's last modification date and time in UTC.
dataSource.createdBy non-null String
The Data Source's creator. It can be either a User ID, an Application ID, or "system" if it was created by Propel.
dataSource.modifiedBy non-null String
The Data Source's last modifier. It can be either a User ID, an Application ID, or "system" if it was modified by Propel.
dataSource.type non-null DataSourceType
The Data Source's type.
The types of Data Sources.
Indicates an S3 Data Source.
Indicates an Http Data Source.
Indicates a BigQuery Data Source.
Indicates a Snowflake Data Source.
dataSource.status non-null DataSourceStatus
The Data Source's status.
The status of a Data Source.
The Data Source has been created, but it is not connected yet.
Propel is attempting to connect the Data Source.
The Data Source is connected.
The Data Source failed to connect.
Propel is deleting the Data Source.
dataSource.connectionSettings non-null ConnectionSettings
The Data Source's connection settings.
dataSource.tables nullable TableConnection
The tables contained within the Data Source, according to the most recent table introspection.
dataSource.tableIntrospections nullable TableIntrospectionConnection
A list of table introspections performed for the Data Source. You can see how tables and columns changed over time by paging through this list.
dataSource.checks nullable array of DataSourceCheck
A list of checks performed on the Data Source during its most recent connection attempt.
dataSource.dataPools nullable DataPoolConnection
If you list Data Pools via the
dataPoolsfield on a Data Source, you will get Data Pools for the Data Source.
dataPoolsfield uses cursor-based pagination typical of GraphQL APIs. You can use the pairs of parameters
beforeto page forward or backward through the results, respectively.
For forward pagination, the
firstparameter defines the number of results to return, and the
afterparameter defines the cursor to continue from. You should pass the cursor for the last result of the current page to
For backward pagination, the
lastparameter defines the number of results to return, and the
beforeparameter defines the cursor to continue from. You should pass the cursor for the first result of the current page to
status non-null TableIntrospectionStatus
The status of the table introspection.
The status of a table introspection.
The table introspection has not started.
The table introspection has started.
The table introspection succeeded.
The table introspection failed.
createdAt non-null DateTime
The table introspection's creation date and time in UTC.
createdBy non-null String
The table introspection's creator. It can be either a User ID, an Application ID, or "system" if it was created by Propel.
modifiedAt non-null DateTime
The table introspection's last modification date and time in UTC.
modifiedBy non-null String
The table introspection's last modifier. It can be either a User ID, an Application ID, or "system" if it was modified by Propel.
numTables nullable Int
The number of tables introspected.
tables nullable TableConnection
The tables introspected.
The table connection object.
Learn more about pagination in GraphQL.
The time at which the tables were cached (i.e., the time at which they were introspected).
The table connection's edges.
The table connection's nodes.
The table connection's page info.