`information_schema` does not have the details of a newly created connection

[pskrbasu]

Create a new dynamic connection eg csv:

connection "csv5" {
  plugin = "csv"
  paths = [ "~/.steampipe/csv/*.csv" ]
}

Run query:

steampipe query "SELECT table_name FROM information_schema.tables WHERE table_schema = 'csv5';"

Returns empty:

+------------+
| table_name |
+------------+
+------------+

Running it the second time returns the results:

+------------+
| table_name |
+------------+
| new22      |
| MyFile     |
| MyFile111  |
| new2 copy  |
| new2       |
+------------+

Weirdly, the information_schema does not have the new created connection details yet, but the connection is ready to be used/queried.

Querying the connection works:

steampipe query "SELECT * from csv5.new2;"

+---+---+---+---+---+---+----------------------------------------------------------------+
| a | b | c | d | e | f | _ctx                                                           |
+---+---+---+---+---+---+----------------------------------------------------------------+
| 1 | 2 | 3 | 4 | 5 | 6 | {"connection_name":"csv5","steampipe":{"sdk_version":"5.8.0"}} |
+---+---+---+---+---+---+----------------------------------------------------------------+

[github-actions[bot]]

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

[github-actions[bot]]

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

[github-actions[bot]]

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

[github-actions[bot]]

This issue was closed because it has been stalled for 90 days with no activity.