Job Management
https://github.com/sqlparser/sqlflow_public/blob/master/sqlflow_guide_cn.md#job-list
Last updated
https://github.com/sqlparser/sqlflow_public/blob/master/sqlflow_guide_cn.md#job-list
Last updated
Lineage Overview: Show the table level lineages of the database. Summary mode will be applied in case of too many relations in the database.
Lineage Detail: Show the database lineage detail. Summary mode will be applied in case of too many relations in the database.
Job Info: Give the Job meta Info such as create time, execution time, db vendor, job type, submitter and etc.
Delete Job: Delete the selected job.
More Actions: More operations to the Job. Currently there's only the top action. The job will be pinned to the top of the panel if we top the job.
Note that Lineage Overview
can not be applied on regular job cause process data are needed but we don't have that in the database.
Give the default value for server/database/schema when there's no related metadata to the database units(such as table,view etc...). If the default values are given here, will use the given values. Otherwise will use default
as the value for server/database/schema if the default server/database/schema is not set.
Choose the Job type when creating the Job. Read more on the Job type.
Customized the extraction/exclusion content under the advanced
section
excludedDbsSchemas: List of databases and schemas to exclude from extraction, separated by commas database1/schema1,database2 or database1.schema1,database2. It supports wildcard characters such as database1/,/schema,/.
extractedDbsSchemas: List of databases and schemas to extract, separated by commas, which are to be provided in the format database/schema; Or blank to extract all databases. database1/schema1,database2/schema2,database3 or database1.schema1,database2.schema2,database3. It supports wildcard characters such as database1/,/schema,/. Hint: In Oracle, schema name is same as DB name so only give schema name is good for Oracle.
extractedStoredProcedures: A list of stored procedures under the specified database and schema to extract, separated by commas, which are to be provided in the format database.schema.procedureName or schema.procedureName; Or blank to extract all databases, support expression. Example: database1.schema1.procedureName1,database2.schema2.procedureName2,database3.schema3,database4 or database1/schema1/procedureName1,database2/schema2
extractedViews: A list of stored views under the specified database and schema to extract, separated by commas, which are to be provided in the format database.schema.viewName or schema.viewName. Or blank to extract all databases. It supports expression. Example: database1.schema1.procedureName1,database2.schema2.procedureName2,database3.schema3,database4 or database1/schema1/procedureName1,database2/schema2
You can give the configurable parameters under the setting
section. Check here to get more details about these parameters.