introspectTables
This mutation is used to introspect the tables in the given Data Source, specified either by its ID or unique name.
The mutation returns the tables along with when they were last cached from the Data Source.
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.
Arguments
input required idOrUniqueName
Returns
Nullable TableIntrospection
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.
introspectTables.dataSource non-null DataSource
The Data Source the table introspection was performed for.
introspectTables.status non-null TableIntrospectionStatus
The status of the table introspection.
The status of a table introspection.
NOT_STARTED
The table introspection has not started.
STARTED
The table introspection has started.
SUCCEEDED
The table introspection succeeded.
FAILED
The table introspection failed.
introspectTables.createdAt non-null DateTime
The table introspection's creation date and time in UTC.
introspectTables.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.
introspectTables.modifiedAt non-null DateTime
The table introspection's last modification date and time in UTC.
introspectTables.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.
introspectTables.numTables nullable Int
The number of tables introspected.
introspectTables.tables nullable TableConnection
The tables introspected.