ETL: Advanced Search

Use advanced search modifiers in Integrate.io ETL to quickly find packages, connections, jobs, and other resources across your account workspace.

Plain text search

On the Packages and Jobs screens, a single-word search performs a case-insensitive substring match on the resource name. For example, proj matches XXBI_PROJECT and XXBI_BPM_PROJECT, and estimat matches XXBI_ESTIMATING_V.

To require an exact whole-word match, wrap the term in double quotes. For example, "two" matches two but not one.two three.

Multi-word plain text searches and digit-only searches continue to use whole-token matching.

Search modifiers preview

Search Modifier	Description
+	preview of search modifiers available
:	preview of search modifiers available

Package group search modifiers

Search Modifier	Description
name:	search for the package group by its name
user:	search for package groups owned by a user
created:	search for a package group created before or after a date
modified:	search for a package group modified before or after a date

Package search modifiers

Search Modifier	Description
id:	search for a package’s id number
name:	search for a package by its name
user:	search for packages owned by a user
created:	search for jobs created before or after a date
modified:	search for jobs modified after a date

Jobs search modifiers

Search Modifier	Description
id:	search for a package’s id number
log:	search for jobs with this error log
user:	search for jobs run by a user
status:	search for jobs with the status (failed, pending, stopped, running, stopping or completed)
package:	search for jobs run with the package name
cluster:	search for jobs run on a cluster name
started:	search for jobs started before or after a date
finished:	search for jobs by finished time after a date
duration:	search for jobs with a duration less than or greater than a number of seconds
schedule:	search for jobs by the schedule name

Here is an example of a cluster search