show sink's dest table id/name in systable/describe statement when sink into table

[st1page]

currently, can not get the infomation.

dev=> create sink ssss into tt as select * from t;
CREATE_SINK

dev=> describe ssss;
       Name        |   Type    | Is Hidden | Description 
-------------------+-----------+-----------+-------------
 v                 | integer   | false     | 
 t._row_id         | serial    | true      | 
 distribution key  | t._row_id |           | 
 table description | ssss      |           | 
(4 rows)

dev=> select * from rw_sinks where name = 'ssss';
  id  | name | schema_id | owner | connector |       sink_type       | connection_id |             definition              | acl |        initialized_at         |          created_at           
------+------+-----------+-------+-----------+-----------------------+---------------+-------------------------------------+-----+-------------------------------+-------------------------------
 1021 | ssss |         0 |     1 | TABLE     | SINK_TYPE_APPEND_ONLY |               | CREATE SINK ssss AS SELECT * FROM t | {}  | 2023-12-19 11:47:06.365+00:00 | 2023-12-19 11:47:06.428+00:00
(1 row)

[github-actions[bot]]

This issue has been open for 60 days with no activity.

If you think it is still relevant today, and needs to be done in the near future, you can comment to update the status, or just manually remove the no-issue-activity label.

You can also confidently close this issue as not planned to keep our backlog clean. Don't worry if you think the issue is still valuable to continue in the future. It's searchable and can be reopened when it's time. 😄