SHOW CREATE ROUTINE LOAD

Description

This statement is used to display the creation statement of a routine load job.

The result shows the current consuming Kafka partitions and their corresponding offsets to be consumed.

SHOW [ALL] CREATE ROUTINE LOAD for <load_name>;

1. <load_name>

The name of the routine load job

1. [ALL]

Optional parameter that represents retrieving all jobs, including historical jobs

Users executing this SQL command must have at least the following permission:

Privilege	Object	Notes
LOAD_PRIV	Table	SHOW ROUTINE LOAD requires LOAD permission on the table

Show the creation statement of a specified routine load job in the default database
```
SHOW CREATE ROUTINE LOAD for test_load
```