Is it possible to manually overwrite the schema creation?

The schema is auto detected based on

JDBCType

. It looks like there may be an edge case here. Relevant code here: https://github.com/airbytehq/airbyte/blob/master/airbyte-integrations/connectors/s[…]ava/io/airbyte/integrations/source/jdbc/AbstractJdbcSource.java

If the type cannot be resolved, it defaults to

varchar

.

Do you see anything like this in the log?

Could not convert column: %s from table: %s.%s with type: %s. Casting to VARCHAR.

The exact log line will help us find out what the parsed type is.

Hi Liren, Thanks for your reply, I have sent the logs and schema screenshot in personal chat.

btw, I don’t see that error in log

I just see,

Unknown keyword order - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword

@Liren Tu did you got a chance to look at what might be causing such behaviour? Please can you guide me

This “Unknown keyword order” is not relevant. It’s strange that the “Could not convert column” warning does not exist in the log.

Would you mind telling us what’s the Postgres version you are running?

I created an issue here for tracking: https://github.com/airbytehq/airbyte/issues/7187

Thanks Liren

Postgres version 13.3 AWS RDS

SELECT version();
"PostgreSQL 13.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 7.3.1 20180712 (Red Hat 7.3.1-12), 64-bit"