Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Configuring multiple tables with the same name results in only one table getting synced #2

Open
jan-san opened this issue Dec 14, 2022 · 0 comments

Comments

@jan-san
Copy link
Collaborator

jan-san commented Dec 14, 2022

Currently, when providing multiple tables with the same table name (but from different schemas) in the configuration, all tables get synced, but only the rows from the table that takes the longest to sync will end up in the final output table.

Possible fixes could be:

  • check for non-unique table names in the configuration, log a warning and keep only the first entry for each unique table name
  • add a configuration option to prefix the output table names by the input schema (so instead of [snowflake_schema].[pg_table_name], sync to [snowflake_schema].[pg_table_schema]_[pg_table_name])
  • allow specifying aliases for table names in the configuration that are used as target table names instead of the original table names
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant