Hello all - testing out the defualt tap-postgres (...
# plugins-general
w
Hello all - testing out the defualt tap-postgres (transferwise) to target-postgres (datamill-co) and hitting an error "target_postgres.postgres.PostgresError: Identifier must only contain lower case letters, numbers, underscores, or dollar signs. Got
a
for `public-orders`" The error message aligns with what the code states, namely if an identifier contained upper case letters then it should flag something (https://github.com/datamill-co/target-postgres/blob/9c095d91e215f932caa897a6587c6dc6278db8cf/target_postgres/postgres.py#L389). So how is 'a' triggering this? Maybe I misunderstanding something here...first time using Meltano and Singer taps/targets!