Hello Team, I am MLOPS and Backend Lead from <Cere...
# troubleshooting
s
Hello Team, I am MLOPS and Backend Lead from Cerebra.ai. We are a well funded AI startup in Bay Area helping fashion retail industry to maximize their profits and reduce their risks using AI. I cam across Airbyte couple of days ago and find it very useful for our use case as we integrate different data source every week. I am facing a problem wondering anyone here can help me. Source: Postgres(DB1) Destination: Postgres(DB2) Problem: 1. Source does not show any tables to sync data to destination 2. When I run the connection nothing gets transfered but show success. Ask: What to do solve or debug it? Thanks.
p
I ran into a similar problem and someone here helped me with this. Had to check the privileges (on the source DB) granted to the user used to connect with Airbyte.
Copy code
SELECT DISTINCT table_catalog, table_schema, table_name, privilege_type 
FROM information_schema.table_privileges 
WHERE grantee = 'yourusername' AND privilege_type = 'SELECT'
Good point. Looking into it.
@Keurcien Luu It actually worked Thanks. Do you know a way using which I can make sure column name in destination is exactly same as of source.
k
@Preet Singh some cases Airbyte changes the column name to not have conflict with internal names, but overall the names should be equal. Do you have an example?