Support generating types for foreign tables

[pomdtr]

I'm using steampipe as a way to query cloud apis using sql.

Steampipe use postgresql behind the scene (see https://steampipe.io/docs/develop/overview).

Sadly it looks like kanel is not able to generate types from steampipe foreign tables.

[kristiandupont]

If you can access the underlying Postgres database, you should be able to run Kanel on it.

[pomdtr]

Kanel was able to run on it, but the foreign tables were not included in the output. See the following screenshot:

You can list foreign tables in a postgres database by using SELECT * FROM information_schema.foreign_tables;

[pomdtr]

It looks like extract-pg-schema support foreign tables, but kanel does not use them:

• https://github.com/kristiandupont/extract-pg-schema/blob/main/src/kinds/PgType.ts#L21
• https://github.com/kristiandupont/kanel/blob/main/packages/kanel/src/processDatabase.ts#L65

[kristiandupont]

Ah they're foreign tables, right. Those are not supported at the moment, that's correct.

[alande-amorim]

@kristiandupont, such feature is of interest for an upcoming project I'll be joining. I'm currently assessing this tool and it's pretty cool. I'd like to help develop this feature. Is it being tracked in any roadmap? How can I contribute?

[kristiandupont]

It ought to be fairly simple, actually. There is no roadmap or anything like that but I am assuming you would want a foreign table to create types exactly like regular tables?